Keep formatting in Excel when copying/pasting from web page

Question from B.G.:

Sorry to bother. How can I export and keep the integrity of the web page table columns? When I copy and paste to excel, it puts all data to 1 row.

Answer:  Good question! Please find the steps below:

  1. In your web browser window showing the table/report, press CTRL+A (to select all)
  2. Then press CTRL+C (to copy)
  3. Switch to a blank spreadsheet in Excel, press CTRL+V (to paste)
That should result in a nice separate set of columns/rows.

Select All, Copy/Paste Results

Please let me know if you encounter any issues. Have a great day!

Leave a Reply

Your email address will not be published. Required fields are marked *