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.
- The value for
Notes
- A maximum of 50
IMPORTDATA
calls are supported on a single spreadsheet. This limit is removed in the new version of Google Sheets.
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.
Examples
Retrieves Google office-address information from the specified CSV file URL
.