Import data from the web and other workbooks

Updated November 13, 2026

These functions fetch data when the workbook opens and when you choose Formulas › Calculate. They need a connection and for you to be signed in.

From a web page

  • IMPORTHTML(address, “table”, n): the nth table on a page. Use "list" for a list.
  • IMPORTXML(address, path): the parts of a page an XPath picks, such as "//h2".
  • IMPORTDATA(address): a .csv or .tsv file on the web.
  • WEBSERVICE(address): the text a web address returns.

Example: =IMPORTHTML("https://example.com/prices","table",1).

From another workbook in MyCloudSuites

  • IMPORTRANGE(workbook, “Sheet1!A1:C10”): the cells of another workbook you keep in MyCloudSuites, read with your own access. For the first argument, use the workbook’s address from your browser, or its id.

Good to know

  • Pages must be public. MyCloudSuites fetches the page for you, so pages behind a sign-in can’t be read.
  • Up to 2 MB a page. Bigger pages show an error.
  • The values are saved with the workbook, so it still shows them when you’re offline.

If something goes wrong

  • #N/A or #REF! The address can’t be reached, the table number doesn’t exist, or (for IMPORTRANGE) you don’t have access to that workbook.

Was this article helpful?