Hello everyone,



I'm working with an online educational platform that caters to UPSC students, and we're trying to enhance how we provide current affairs data. Our goal is to automatically populate an Excel sheet with the title, publishing date, and link of each current affairs post from both our dedicated section (here's the link: Daily Current Affairs for UPSC - Compass by Rau's IAS) and various other news sources. Ideally, this Excel should also allow for date-based filtering, similar to the functionality on our website.

Furthermore, we want to expand this capability to automatically gather similar data from a range of news sources and compile it into the same Excel file. This way, we can provide our students with a comprehensive, up-to-date resource that they can use for their studies, without needing to visit multiple websites.

I'm looking for any insights or tools that could help in setting up such a system. Is there a way to automate this process that integrates easily with Excel? How do you manage to gather and filter data like this efficiently?

Any help or pointers would be greatly appreciated as we try to make learning more accessible and streamlined for our students.

Thank you in advance for your suggestions!