I sometimes want to copy html tables found on websites into a program that can display them properly on my computer so that I work with the data or use it in documents.
Whenever I copy a table in Firefox and paste it into Microsoft Excel or Open Office, the table structure and formatting is lost.
All cells are pasted without the correct formatting which can be quite frustrating if you copy a large table as you need to go through it manually afterwards to correct issues caused during the process.
The creator of one of the runner up add-ons of the Extend Firefox competition must have had similar thoughts because he created the Firefox add-on Table 2 Clipboard which retains the formatting of the table when you are copying and pasting it.
If you want to retain the table structure you right-click on the table and select Copy Whole Table from the menu.
Open the software you want to copy the table to and paste it. The table structure will be retained and all data is displayed correctly in rows and columns just like in the original table.
It is also possible to copy selected cells only. Press the CTRL key and left-click on the cells that you want to copy to select them. Right-click the table at the end and select Copy selected cells.
The right-click menu displays options to select a single row or column instead which can be useful if you only need it and not everything. While you can select it using the Ctrl-key modifier, it is often faster to use the right-click menu directly for it.
Table 2 Clipboard works well if tables are used to display contents on the website. It won't work however if other formatting options, CSS for instance, are used to render a table-like structure.Advertisement
Advertising revenue is falling fast across the Internet, and independently-run sites like Ghacks are hit hardest by it. The advertising model in its current form is coming to an end, and we have to find other ways to continue operating this site.
We are committed to keeping our content free and independent, which means no paywalls, no sponsored posts, no annoying ad formats or subscription fees.
If you like our content, and would like to help, please consider making a contribution:
Ghacks is a technology news blog that was founded in 2005 by Martin Brinkmann. It has since then become one of the most popular tech news sites on the Internet with five authors and regular contributions from freelance writers.