Automating Current Affairs Data Collection into Excel for UPSC Students

[rauiosl]

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!

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Automating Current Affairs Data Collection into Excel for UPSC Students
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[rauiosl]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Automating Current Affairs Data Collection into Excel for UPSC Students
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Oh We get it. We are just looking to get a solution as soon as possible as our new batch has started and live classes are going on currently. So, a quick solution would do a world of good to us.

 

[Fluff]

@rauiosl
Maybe you missed this part of my message.

if you have posted the question at other places, please provide links to those as well.

Please provide links to ALL sites where you have asked this question.

 

[rauiosl]

@rauiosl
Maybe you missed this part of my message.

Please provide links to ALL sites where you have asked this question.

Also posted on: Seeking Guidance on Integrating Advanced Features into UPSC Coaching App

Still waiting for the answer.

 

[Fluff]

You need to supply links to ALL other sites, not just some.