Copy from Firefox and paste into Excel

By | December 3, 2008

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.

4 thoughts on “Copy from Firefox and paste into Excel

  1. Cracker

    Thanks Christian… This is a good TIP for copy/paste option for formatted data

  2. steve

    Thanks!! I’ve been wondering about this for years! I always just would open IE and now no more..

  3. Mike

    Fantastic !! This was/is one of the reasons I was hardly ever using FF…

  4. Mike

    Thanks!! This was one of the reasons I did not use FF

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.