We’re rewarding the question askers & reputations are being recalculated! Read more.

For questions specifically about the Google Sheets function: IMPORTDATA()

Use this tag if your question is specifically about using IMPORTDATA() in Google Sheets.

From the Google Support page for IMPORTDATA:

IMPORTDATA

Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.

Sample Usage

IMPORTDATA("http://www.census.gov/2010census/csv/pop_change.csv")

IMPORTDATA(A2)

Syntax

IMPORTDATA(url)

  • url - The url from which to fetch the .csv or .tsv-formatted data, including protocol (e.g. http://).

    • The value for url must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.

Notes

  • A maximum of 50 IMPORTDATA calls are supported on a single spreadsheet.

Related:

history | excerpt history