How to Import a CSV File into Google Sheets: The Complete Manual Guide

This guide walks through the full manual process of importing a CSV file into Google Sheets, screen by screen. If you have ever stared at the Import file dialog wondering which of the five radio buttons to pick, or watched Sheets silently turn your product codes into numbers, this article covers exactly what each option does and how to avoid the usual mistakes. It focuses on the built-in Google Sheets flow — no extensions, no scripts, no third-party tools.

Before you start: prepare the CSV

Ninety percent of import problems happen before the file ever reaches Google Sheets. Two minutes of preparation saves an hour of cleanup later.

Check the file extension

Google Sheets accepts .csv, .tsv, and .txt files as delimited data. If your file was renamed to .xls or .xlsx by accident, the importer will refuse it — rename it back to .csv first.

Check the encoding

Open the file in a plain-text editor (VS Code, Notepad++, Sublime Text) and confirm the status bar reads UTF-8. If it reads Windows-1252, ISO-8859-1, or UTF-16, use File → Save with Encoding → UTF-8 to re-save a clean copy. Sheets always assumes UTF-8; anything else produces question marks, replacement characters, or garbled accents.

Check the delimiter

Open the file and look at the first line. Commas, semicolons, tabs, and pipes are all common. European exports frequently use semicolons because commas serve as decimal separators in those locales. Note which delimiter is in use — you will pick it in the importer.

Method 1: Import into a new Google Sheet from scratch

This is the fastest manual method when you want the CSV to become its own spreadsheet, not part of an existing one.

1. Open sheets.google.com and click the blank + button to create a new spreadsheet.
2. In the new sheet, click File → Import in the top menu bar.
3. The Import file dialog opens with three tabs: My Drive, Shared with me, and Upload. Click Upload.
4. Drag your CSV file into the drop zone, or click Browse and select it from your computer.
5. Wait for the upload progress bar to complete. Small files finish in under a second; files above 50 MB may take a minute or two.
6. The Import file settings dialog appears. Choose Replace spreadsheet as the Import location.
7. Leave Separator type on Detect automatically unless columns look merged — see the troubleshooting section below.
8. Leave Convert text to numbers, dates, and formulas set to Yes for numeric data. Set it to No if you need to preserve leading zeros, phone numbers, or IDs exactly as typed.
9. Click Import data. The dialog closes and your CSV appears in the sheet.

Method 2: Import into an existing Google Sheet

When you want the CSV added to a spreadsheet you are already using — for example, appending this week's ad export to a running master sheet — pick this path.

1. Open the destination Google Sheet.
2. If you want the CSV to land in a specific tab, click that tab first.
3. Click File → Import → Upload and pick the CSV.
4. In Import location, choose one of the five options: Create new spreadsheet, Insert new sheet(s), Replace spreadsheet, Replace current sheet, or Append to current sheet.
5. For a running log, pick Append to current sheet — the CSV rows are pasted below your existing data.
6. For a fresh snapshot of the same report, pick Replace current sheet — the tab is wiped and refilled.
7. Click Import data.

What each Import location actually does

• Create new spreadsheet — Sheets makes a brand-new file in your Drive from the CSV. Your current spreadsheet is untouched.
• Insert new sheet(s) — the CSV is added as a new tab in the current spreadsheet, named after the file.
• Replace spreadsheet — every tab in the current spreadsheet is deleted and replaced with the CSV data. Use with care.
• Replace current sheet — only the active tab is wiped and refilled. Formulas that referenced this tab keep working if the column layout matches.
• Append to current sheet — CSV rows are added at the bottom of the active tab. The header row is included, so most people delete it after import.

Method 3: Import through Google Drive

Useful when the CSV is already in your Drive or a shared drive.

1. Open drive.google.com and locate the CSV.
2. Right-click the file and choose Open with → Google Sheets.
3. Drive creates a brand-new Google Sheet in the same folder, with the same name minus the .csv extension.
4. The original CSV stays in Drive; the Sheet is a separate document.

Method 4: Use the IMPORTDATA function for public CSV URLs

If your CSV lives at a stable public URL — an open data feed, a report exposed by your own server, or a public Google Cloud Storage object — you can pull it in with a formula instead of uploading.

1. Open a Google Sheet and click cell A1.
2. Type =IMPORTDATA("https://example.com/file.csv") and press Enter.
3. Sheets fetches the file and populates the range. It refreshes automatically every hour or so.

IMPORTDATA only works for public, unauthenticated URLs. It does not send headers, cookies, or API keys.

Troubleshooting: the eight things that usually go wrong

1. Every row lands in column A

The importer is using the wrong delimiter. Open the Import file settings dialog again and change Separator type from Detect automatically to Comma, Semicolon, Tab, or Custom. For custom, type the exact character used (for example |).

2. Special characters show as question marks or replacement symbols

The file is not UTF-8. Open it in a text editor, use Save with Encoding → UTF-8, and re-import the converted copy.

3. Leading zeros are stripped from IDs, SKUs, or zip codes

Set Convert text to numbers, dates, and formulas to No in the Import file settings dialog. If you already imported, pre-format the target column as Format → Number → Plain text and re-import.

4. Dates flipped between month and day

Sheets applies your account locale to date parsing. Go to File → Settings → General and match the Locale to the CSV's origin (United States for MM/DD/YYYY, United Kingdom for DD/MM/YYYY). Re-import, then switch the locale back if you need to.

5. Long numeric IDs turn into scientific notation

Sheets converts 16+ digit numbers to notation like 1.23E+15. Set the column to Plain text before import, or set Convert text to numbers to No.

6. Import fails with a size error

A Google Sheet supports up to 10 million cells. Split the CSV into smaller files or filter rows before importing.

7. Columns with commas in the values get split incorrectly

The source CSV is missing quote wrapping. Fields that contain commas should be wrapped in double quotes. Re-export the CSV with proper quoting from the source tool.

8. Import dialog never appears

Third-party cookies are blocked or an ad blocker is interfering. Allow cookies for accounts.google.com and docs.google.com, then try again.

Manual import checklist

• File is saved as .csv with UTF-8 encoding.
• Delimiter is known (comma, semicolon, tab, or pipe).
• Destination spreadsheet is open and the right tab is active.
• Import location choice matches the intent (append vs replace vs new).
• Convert text setting matches the data (No for IDs, Yes for numeric analysis).
• Post-import: spot-check the first ten rows and the last ten rows for silent format changes.

When manual import stops being worth it

The manual flow described above takes around 45 seconds per file once you know every option. That is fine for occasional CSVs. If you import the same report every day or every week, the setup cost per import stops feeling small — five minutes a day is 20 hours a year.

At that point, one of three shortcuts helps: a Chrome extension that turns the whole flow into a single click, an Apps Script trigger that fetches and pastes automatically, or a paid pipeline for team-critical feeds. The right choice depends on the source and volume — see our guide to automating CSV imports for a side-by-side comparison.