title: How to copy content from html into excel with desired format (that contains all rows and certain columns)
body: <p>I tag this question with both excel and python is because I want to explore the possibilities of using either approach (by doing simple copy content from the website and paste it to excel with the right format, or use any python library to extract the content and covert to a dataframe).</p>
  <p>I need to copy and paste the below table into excel from <a href="https://ndcpartnership.org/climate-tools/ndcs" rel="nofollow noreferrer">https://ndcpartnership.org/climate-tools/ndcs</a> .However,  The format I need to have in excel file contains row (all records) and 3 columns include &quot;Country&quot;, &quot;Latest Submission&quot; and &quot;Latest submission date&quot; like what I see from the table below.</p>
  <p>However, when I select all ,copy the entire table and paste over to excel cell, I only get certain rows of records (all records shown in one column). I have tried to inspect the URL and attempted to use bs4 but I do not see all the info (3 columns I mentioned above) I need from the html structure, so I did not have any code posted in this question. Given this is a one time effort, I want to figure out a way to paste the content in a desired format into excel.</p>
  <p>Any suggestions and advice are highly appreciated.
  <a href="https://i.stack.imgur.com/MKagR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MKagR.png" alt="enter image description here" /></a></p>