How To Import A CSV File Into Google Sheets (2026)
Google Sheets can bring in a CSV file from your computer with File, Import, and it can also pull one straight from a web address with a formula.
The right method depends on whether the file is on your device, already in Drive, or published online.
These steps come from Google’s Docs Editors Help pages on importing data, Excel files and the IMPORTDATA function.
Quick answer: pick a method
| Your file | Best method |
|---|---|
| A CSV or Excel file on your computer | File, Import, Upload |
| A CSV at a public web address | The IMPORTDATA function |
| A small amount of data, a few hundred rows | Copy and paste |
| A file Sheets says is too large | Connect it to BigQuery with Data, Data connectors |
| An Excel file you want to keep as Excel | Open it in Sheets and edit it in place |
For a normal CSV on your computer, the first method below is the one to use.
Import a file from your computer
- Open a spreadsheet in Google Sheets.
- Click File, then Import.
- Choose Upload, then select a file from your device.
- Pick the file.
- Choose an Import location.
- Choose a Separator type.
- Click Import data.
Google describes the import location as a choice to replace or append to a sheet.
Google’s page does not list the separator choices, so check the drop-down in your own import window.
Why File, Import beats copy and paste
Google says File, Import is more reliable and faster than copy and paste for large data, and that it keeps more of the original file’s features.
Copy and paste is best for small amounts, such as a few hundred rows of values.
When you paste, use Paste special, then Values only, to bring over just the values.
| Method | Google’s guidance |
|---|---|
| Copy and paste | A few hundred rows of values, or images under 1 MB |
| File, Import | Large data, and it keeps more of the original file’s features |
| Import functions | Small amounts of data that change often |
Import an Excel file instead
The same File, Import path works for an Excel file, but the choices are different.
| Import option | Available for Excel files |
|---|---|
| Create new spreadsheet | Yes |
| Insert new sheet(s) | Yes |
| Replace spreadsheet | Yes |
| Replace current sheet | No |
| Append to current sheet | No |
| Replace data at selected cell | No |
Google says the Excel file itself is not changed by the import.
If you want the whole file converted, see how to convert Excel to Google Sheets and back.
Open an Excel file in Sheets without importing
- Edit in place: open the Excel file from Drive in Sheets and your changes save to the original Excel file.
- Convert: open the file, then click File, then Save as Google Sheets, and the original Excel file stays unchanged.
- Auto-convert: in Drive settings, turn on Convert uploaded files to Google Docs editor format.
Auto-convert does not touch files you uploaded earlier.
On Chrome, Google says to remove the Office Editing for Docs, Sheets and Slides extension first if it is installed, then double-click the file in Drive and choose Open with Google Sheets.
Upload the file to Drive first
Another route is to put the file in Drive and open it from there.
- In Google Drive, click New, then File upload.
- Pick the file from your device.
- Open the uploaded file in Google Sheets.
This is the Drive upload method Google lists for Excel files.
When to convert an Excel file and when to leave it
Google suggests converting when your team needs to collaborate or co-edit, with datasets of 20 million cells or fewer.
| Stay in Excel when | Note |
|---|---|
| The dataset is over 20 million cells | It is beyond the size Google recommends converting |
| The file uses the Hyperion add-on | Google lists it as a reason to stay in Excel |
| The file has rare chart types such as 3D pyramid or pie-of-pie | Google lists these as a reason to stay in Excel |
When auto-convert is on, Excel tables become Sheets tables, and Excel pivot tables can also be imported.
After converting, you can keep or delete the Excel original, and Google suggests renaming it with an [Archived] prefix to avoid confusion.
Pull a CSV from a web address with IMPORTDATA
IMPORTDATA fetches CSV or TSV data from a web address and places it in your spreadsheet.
The syntax is IMPORTDATA(url).
| Part | What it means |
|---|---|
| url | The address of the CSV or TSV file, including the protocol such as http:// |
| In quotation marks | Type the address directly inside the formula |
| Cell reference | Point to a cell that holds the address, for example IMPORTDATA(A2) |
Google’s own example pulls a U.S. Census population change file, written as IMPORTDATA(“https://www2.census.gov/programs-surveys/popest/datasets/2010-2019/national/totals/nst-est2019-popchg2010_2019.csv”).
Google’s page does not list data size limits, refresh timing or error messages for this function.
Other import functions
| Function | What it imports |
|---|---|
| IMPORTRANGE | A range of cells from another spreadsheet |
| IMPORTHTML | A table or list from an HTML page |
| IMPORTFEED | An RSS or ATOM feed |
| IMPORTXML | Structured data such as XML, HTML, CSV, TSV, RSS or ATOM |
Google says these functions refresh periodically rather than in real time.
That makes them suit data that another sheet or source updates every few hours.
If the CSV is too large for Sheets
Google says Sheets can reject a file that is too large to import directly.
- Open the file.
- Click Data, then Data connectors, then Connect to BigQuery.
- Select your Google Cloud project.
- Name the table.
- Continue, then open the file from the pop-up.
Google says this lets you open CSV files of any size with familiar Sheets tools.
The page gives no exact row, column or file-size caps for File, Import.
Export a sheet back to a file
To send a copy out, click File, then Download, and pick a format.
Google’s Excel guidance lists Excel, PDF, CSV and ODS among the choices.
You can also email a copy as an Excel or PDF attachment with File, then Email as attachment.
Related guides
After the data is in, remove duplicates in Google Sheets to clean it up.
To organise the rows, read how to sort and filter data in Google Sheets.