How to obtain data from Website

[duttaabhishek7]

I need the data from the webpage (https://www.transparency.org/en/cpi/2023) with the table score rank etc on the left side of the page and input them as output in excel format

[Wesley Mendonca]

Hello @duttaabhishek7 

I've developed a workflow that allows you to perform web scraping by copying the HTML of a page. You can then download the data in either Excel or CSV format using a download tool, eliminating the need to create a script. All you need to do is locate the relevant objects on the page. You can do this by using the F12 key in your browser to inspect the elements and copy their paths.

I'll attach my workflow for you to review and adapt to your specific situation. Additionally, if the page is hosted in the cloud, there may be certain roles you can directly copy from the download tool.

[bgreedy]

My solutions a bit janky as I couldn't directly extract the data in that table from using just that url, however it does contain a list of all the countries, which you can use to create a URL to download data for each country individually.

The question is very similar to one I answered earlier today, so I hope I'm not doing people's homework for them 😅 make sure you go through the workflow and understand what it's doing!!

Also if there anyone who's more experienced with html parsing who can think of a prettier way to do this I'd love to know!