With the help of the Web Page Query OpenOffice.org Calc import filter, you can insert tables from HTML documents in a OpenOffice.org Calc spreadsheet.
Let us step through the relatively straightforward process of importing data from tables in a HTML document.
The data for this example was obtained from an excellent website with tons of population data from all over the world : citypopulation.de
Here is what the source HTML file looks like : swiss.html
For this example, we will be importing awebpage from the local disk.
The External Data dialog is activated by Insert-External Data.
Once we fill in the path to the local copy of the HTML file and the table inside this file we wish to import – we hit OK and we are done – it is that easy.