Copy from Firefox and paste into Excel

December 3, 2008 – 22:58

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.

Tags: , ,

  1. One Response to “Copy from Firefox and paste into Excel”

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

    By Cracker on Feb 28, 2010

Post a Comment