IMPORTDATA

IMPORTDATA fetches a CSV or TSV file from a given public URL and populates the sheet with its rows and columns. It refreshes periodically so the data stays current, making it useful for live data feeds, public datasets, or any CSV-based API endpoint.

Excel

=IMPORTDATA("https://example.com/data.csv")

Google Sheets

=IMPORTDATA("https://example.com/data.csv")

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2

Formula

Runs server-side · free · no signup

How it works

1Find the direct URL to a publicly accessible CSV or TSV file.
2Enter =IMPORTDATA("<URL>") in the top-left cell where you want the data to appear.
3The function spills all rows and columns from the file into your sheet and refreshes automatically.

Need a version for your data?

Try: “Import a live CSV file from the web into my Google Sheet”

IMPORTRANGE IMPORTHTML IMPORTXML

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026

IMPORTDATA

Try it with your data

How it works

Related