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:
Instructions
- In your web browser window showing the table/report, press CTRL+A (to select all)
- Then press CTRL+C (to copy)
- 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!
–J.D.
Top Search Terms:
- copy and paste in excel keeping format (6)
- excel keep formatting when pasting (2)
- why is my paste formatting turned off in web excel (1)
- formatting excel sheets from copying web (1)
- formatting error when copying text from web page (1)
- excel keep formatting from webpage (1)
- excel how to copy past page and keep format (1)
- excel - retain format on web page (1)
- copy spreadsheet from webpage to excel formatting (1)
- copy paste format from webpage to excel (1)
Hello. When I “CTRL+V” into the excel document, all of the information pastes into column A. This happens regardless of me selecting the right amount of cells, when I select the entire worksheet, or if I just select cell A1.
Any idea how to fix this?
Hey Keeley, that usually means the source content was copied as plain text rather than as HTML with table formatting. Make sure you’re selecting the actual table on the web page (not just the surrounding text) before copying. In some browsers it helps to click inside the table first, then do Ctrl+A to select all content on the page, then Ctrl+C. When you paste into Excel with Ctrl+V, if it’s still going into one column, try right-clicking the destination cell and choosing “Paste Special” to see if there’s a “Use Text Import Wizard” option that lets you set column delimiters.