How to Import CSV to Google Sheets (4 Methods Compared)

Every day, millions of people need to get CSV data into Google Sheets. And every day, most of them waste 3–15 minutes doing it the hard way.

This guide covers all four methods for importing CSV to Google Sheets — with honest trade-offs, exact step counts, and a clear recommendation at the end.

Method 1: Manual Upload via Google Drive

The default approach. Works everywhere, requires nothing extra, and is the most universally known method.

Steps:

1. Open drive.google.com in your browser
2. Click New → File upload
3. Select your CSV file
4. Wait for the upload to complete
5. Right-click the uploaded file → Open with → Google Sheets
6. Google Sheets opens — but your file is still a CSV, not a Sheet
7. Go to File → Save as Google Sheets
8. Wait for the conversion

That's 8 steps. And you now have two copies of the file — the original CSV and a new Sheet — which you'll need to manage.

Time: 2–4 minutes per file Best for: One-off imports when you have no other tools installed

Limitations:

• No automatic updates when the CSV changes
• You end up with duplicate files in Drive
• Encoding issues (UTF-8 vs. Windows-1252) can corrupt special characters
• Leading zeros in fields like phone numbers or ZIP codes get silently dropped

---

Method 2: IMPORTDATA Function

Google Sheets has a built-in function that can pull CSV data directly from a URL — no file upload needed.

Syntax:

=IMPORTDATA("https://example.com/your-file.csv")

Steps:

1. Open a new Google Sheet
2. Click on cell A1
3. Type =IMPORTDATA("YOUR_CSV_URL")
4. Press Enter — data populates automatically

Time: 30 seconds (if your CSV is already hosted online) Best for: CSVs hosted on a public URL that update regularly (data feeds, reports from web services)

Limitations:

• Only works with publicly accessible URLs — won't work with local files
• Updates on a delay (Google caches the data)
• No control over delimiter, encoding, or header rows
• Breaks entirely if the URL changes or goes offline
• Hard to use for files sitting on your desktop

---

Method 3: Google Apps Script

For teams that need to automate bulk imports, Apps Script is the power-user option.

Steps:

1. Open a Google Sheet
2. Click Extensions → Apps Script
3. Write a script using UrlFetchApp or DriveApp to read your CSV
4. Parse the CSV data manually (split by commas, handle quoted fields)
5. Write the data to the sheet using sheet.setValues()
6. Save and run the script
7. Authorize the script (Google OAuth flow)
8. Debug any encoding or parsing errors

Time: 30–120 minutes to write and test; then automated forever Best for: Engineering teams with recurring automated imports, CI/CD pipelines, or large volumes of files

Limitations:

• Requires JavaScript knowledge
• Brittle — CSV format changes break the script
• Apps Script has daily quota limits
• Overkill for individual users or small teams

---

Method 4: CSVtoSheets (Recommended for Mac Users)

CSVtoSheets is a Mac app that makes CSV import a single action — double-click the file and it opens directly in Google Sheets.

Steps:

1. Double-click your CSV file

That's it. One step.

Time: Under 5 seconds Best for: Anyone on a Mac who regularly works with CSV or Excel files

How it works: CSVtoSheets registers itself as the default handler for .csv, .xls, and .xlsx files on your Mac. When you open a file, it securely uploads it to your Google Drive and opens it in Google Sheets — automatically, without any browser gymnastics.

What makes it different:

• Preserves leading zeros (phone numbers, ZIP codes, product codes stay intact)
• Handles encoding correctly — no more garbled special characters
• Works with .csv, .xls, and .xlsx files
• One-time purchase, no subscription
• OAuth-based — your files go directly to your own Google Drive

---

Method Comparison

Method	Steps	Time	Local Files	Auto-update	Requires Setup
Manual Upload	8	2–4 min	Yes	No	None
IMPORTDATA	4	30 sec	No (URL only)	Yes	None
Apps Script	8+	30–120 min	With effort	Yes	High
CSVtoSheets	1	<5 sec	Yes	No	One-time install

---

Common Problems When Importing CSV to Google Sheets

Leading zeros disappear

When you import a CSV file that contains values like 00123 or 01234567890, Google Sheets treats them as numbers and strips the leading zeros.

Fix: Use CSVtoSheets, which preserves the original string values. Or in the manual import dialog, set the column type to "Plain text."

Special characters look garbled

If your CSV uses Windows encoding (CP-1252) instead of UTF-8, you'll see ’ instead of ' and similar garbage.

Fix: Open the file in a text editor and re-save as UTF-8. Or use CSVtoSheets, which handles encoding detection automatically.

Data ends up in a single column

This happens when the CSV uses semicolons or tabs as delimiters instead of commas — common in European data exports.

Fix: Use the manual import dialog (File → Import → Upload) and explicitly set the delimiter. CSVtoSheets handles this automatically.

The file opens in Excel instead of Google Sheets

Your Mac's default file handler is set to Microsoft Excel (or another app) for CSV files.

Fix: Install CSVtoSheets to set Google Sheets as your default CSV handler on Mac.

---

Frequently Asked Questions

Can I import a CSV directly from my Mac without uploading to Drive first?

Yes — CSVtoSheets handles this automatically. With the manual method, you must upload to Drive first.

Does Google Sheets support semicolon-delimited CSV files?

Yes, but only through the File → Import menu (not drag-and-drop). Set the delimiter manually in the import dialog.

Is there a file size limit for CSV imports in Google Sheets?

Google Sheets supports files up to 100 MB via Drive upload. For larger files, you'll need Apps Script or a third-party tool.

Can I import multiple CSV files at once?

Not natively. The manual method requires uploading files one at a time. CSVtoSheets opens each file individually with a double-click, but for true batch importing, see our guide on how to batch convert CSV files to Google Sheets.

Will my formulas work after importing a CSV?

No — CSV files only store values, not formulas. After import, you'll need to re-add any formulas manually.

---

The Bottom Line

If you're on a Mac and import CSV files more than once a week, CSVtoSheets pays for itself in the first hour. The manual method is fine for occasional one-off imports. IMPORTDATA is useful for live data feeds. Apps Script is for teams with engineering resources.

For everything else: one double-click, and you're in Google Sheets.

Related articles:

• The Brutally Honest Guide to Converting CSV to Google Sheets
• CSV vs Excel: Which Format Should You Use in 2026?
• How to Batch Convert CSV Files to Google Sheets