Frequently asked questions - Calc

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

• Wiki Home
• Development
• Design
• QA
• Events
• Documentation
• Website
• Localization
• Accessibility
• Marketing
• Diversity
• Wiki Help

• Documentation Home
• Official Publications
• Other Resources
• FAQ
• HowTo
• Macros
• Docs Development

• FAQ Home
• General
• Writer
• Calc
• Impress
• Draw
• Math
• Base

How to import data tables from an Internet site and have them automatically updated

1. Create a new LibreOffice Calc document.
2. Click on a cell in the table (A1 for example)
3. Go to Sheet ▸ Link to external data.
4. The External Data dialog opens:
   • If the internet page that interests you has been saved locally :
     1. Click on the "..." button to the right of the URL of external data source box.
     2. Select File Type = Web Page Query (Calc) (*.html;*.xhtml;*.htm) (at the bottom of the list).
     3. Choose the URL of the page source in the list.
     4. Click on the Open button.
   • Otherwise:
     1. Write in the URL of external data source box , the address of the internet page containing the data table to be recovered, for example: http://www.boursorama.com/cours.phtml?symbole=1rPCAC. It is also possible to copy the address from the address bar of your browser, then paste it into the URL box (with {key|Ctrl|V}}.
     2. Press ↵ Enter to validate this address.
5. After a few seconds (sometimes a bit longer) a new window appears:
6. Check the Detect special numbers box.
7. Click OK.
8. The dialog for import options disappears. The External Data dialog reappears. The Available pages/ ranges area will now show a list of the type (in the example above) :
   HTML_1
   HTML_2
   HTML_all
   HTML_tables
   
9. Select by clicking on the line HTML_tables (or another line if the data do not correspond to the desired table).
10. 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.
11. Click OK. The data from the internet server will be copied into your sheet from the cell selected initially and are usable. Warning! Each time you update, the previous information is deleted. Therefore you should not insert things like formulas . Use the elements of this area on another sheet with a formula like =Sheet.A3.