IMPORTDATA

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

Sample usage

IMPORTDATA ('https://www2.census.gov/programs-surveys/popest/datasets/2010-2019/national/totals/nst-est2019-popchg2010_2019.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.

See also

IMPORTXML: Imports data from any of various structured data types including XML, HTML, CSV, TSV and RSS and Atom XML feeds.

IMPORTRANGE: Imports a range of cells from a specified spreadsheet.

IMPORTHTML: Imports data from a table or list within an HTML page.

IMPORTFEED: Imports an RSS or Atom feed.

Learn how to optimise your data reference.

Examples

Retrieves United States population data from the specified CSV file URL.