Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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