Need to copy content from website to excel with desired format

Occasional Contributor
 

I need to copy and paste the below table into excel from a website (https://ndcpartnership.org/climate-tools/ndcs )  The format I need in excel file should contain all row (for each country) and 3 columns "Country", "Latest Submission" and "Latest Submission Date" like what I see from the table.

 

However, when I select all ,copy the entire table and paste over to excel cell, I encounter two issues: 1) I only get certain records (corresponds to each country), but not all records. 2) Each record(corresponds to each country) is shown in one column.  

 

I want to figure out a way to paste the content in a desired format into excel.

 

Can anyone offer some helps or advices?.Capture.PNG

2 Replies

@user_2020  The problem is that table is NOT a table but a dynamic web element that automatically updates and refreshes and looks like a table but is only elements being dynamically added and removed.  That said have you tried to just download the data and use that directly?

mtarler_0-1663355548797.png

Notice the "Download data" button near the top of the page.

@mtarler Thanks for looking into this. I tried to download but I got a jpg, or the data being downloaded does not have the 2 columns I need.