This does not include the source code of LibreOffice, which is licensed under the GNU Lesser General Public License ( LGPLv3).

Please note that all contributions to The Document Foundation Wiki are considered to be released under the Creative Commons Attribution-ShareAlike 3.0 Unported License, unless otherwise specified.

Based on work by Han V and Raal Raal and others.

This page was last edited 18:35, 24 March 2023 by Ilmari Lauhakangas.

Use the elements of this area on another sheet with a formula like =Sheet.A3.

Therefore you should not insert things like formulas. Warning! Each time you update, the previous information is deleted. The data from the internet server will be copied into your sheet from the cell selected initially and are usable. To have the recovered data updated periodically, check the Update every box at the bottom of the External data dialog and indicate the periodicity you want.Select by clicking on the line HTML_tables (or another line if the data do not correspond to the desired table).The Available pages/ ranges area will now show a list of the type (in the example above) : The dialog for import options disappears.After a few seconds (sometimes a bit longer) a new window appears:.Press ↵ Enter to validate this address.It is also possible to copy the address from the address bar of your browser, then paste it into the URL box (with. Write in the URL of external data source box, the address of the internet page containing the data table to be recovered, for example.Choose the URL of the page source in the list.Select File Type = Web Page Query (Calc) (*.html *.xhtml *.htm) (at the bottom of the list).' button to the right of the URL of external data source box. If the internet page that interests you has been saved locally :.

Click on a cell in the table (A1 for example).Create a new LibreOffice Calc document.How to import data tables from an Internet site and have them automatically updated

Open office calc online