From The Document Foundation Wiki
- If the internet page that interests you has been saved locally :
- Click on the "..." button to the right of the URL of external data source box.
- Select File Type = Web Page Query (Calc) (*.html;*.xhtml;*.htm) (at the bottom of the list).
- Choose the URL of the page source in the list.
- Click on the Open button.
- Otherwise:
- 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}}.
- Press ↵ Enter to validate this address.
After a few seconds (sometimes a bit longer) a new window appears: