How to Use IMPORTDATA in Google Sheets in 2020?

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

Sample Usage





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.


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

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 a RSS or ATOM feed.


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