|

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 fileBest method
A CSV or Excel file on your computerFile, Import, Upload
A CSV at a public web addressThe IMPORTDATA function
A small amount of data, a few hundred rowsCopy and paste
A file Sheets says is too largeConnect it to BigQuery with Data, Data connectors
An Excel file you want to keep as ExcelOpen 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

  1. Open a spreadsheet in Google Sheets.
  2. Click File, then Import.
  3. Choose Upload, then select a file from your device.
  4. Pick the file.
  5. Choose an Import location.
  6. Choose a Separator type.
  7. 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.

MethodGoogle’s guidance
Copy and pasteA few hundred rows of values, or images under 1 MB
File, ImportLarge data, and it keeps more of the original file’s features
Import functionsSmall 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 optionAvailable for Excel files
Create new spreadsheetYes
Insert new sheet(s)Yes
Replace spreadsheetYes
Replace current sheetNo
Append to current sheetNo
Replace data at selected cellNo

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.

  1. In Google Drive, click New, then File upload.
  2. Pick the file from your device.
  3. 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 whenNote
The dataset is over 20 million cellsIt is beyond the size Google recommends converting
The file uses the Hyperion add-onGoogle lists it as a reason to stay in Excel
The file has rare chart types such as 3D pyramid or pie-of-pieGoogle 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).

PartWhat it means
urlThe address of the CSV or TSV file, including the protocol such as http://
In quotation marksType the address directly inside the formula
Cell referencePoint 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

FunctionWhat it imports
IMPORTRANGEA range of cells from another spreadsheet
IMPORTHTMLA table or list from an HTML page
IMPORTFEEDAn RSS or ATOM feed
IMPORTXMLStructured 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.

  1. Open the file.
  2. Click Data, then Data connectors, then Connect to BigQuery.
  3. Select your Google Cloud project.
  4. Name the table.
  5. 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.

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.

Official sources

Leave a Reply

Your email address will not be published. Required fields are marked *