Copy from Firefox and paste into Excel

You’ve probably already noticed that if you try to copy a table from Firefox and paste into an Excel spreadsheet, using the classic methods the table formatting is not preserved, and the data from the table is copied into one cell from the Excel spreadsheet.

The solution is to paste the table contents in Unicode format into the Excel spreadsheet. You can do it using the Paste Special command from the Edit menu in Excel.

Step by step instructions:

1. Copy the table content from Firefox into clipboard (using CTRL+C or right-click and Copy).

2. Go to the Excel spreadsheet, select Edit from the menu, then Paste Special; in the Paste Special dialog box, select Unicode and pres the Ok button.

Now your data is properly formatted.