How to Import CSV to Google Sheets

Google Sheets is one of the most popular spreadsheet applications, and it has excellent support for CSV files. There are several ways to import CSV data into Google Sheets, and we'll cover all of them in this guide.

Method 1: Open CSV File Directly

The simplest way to work with a CSV file in Google Sheets:

1. Go to Google Drive (drive.google.com)
2. Click the "+ New" button in the top left
3. Select "File upload"
4. Choose your CSV file from your computer
5. Once uploaded, double-click the file to open it
6. Google Sheets will automatically parse the CSV and display it as a spreadsheet

Method 2: Import into Existing Spreadsheet

If you want to add CSV data to an existing Google Sheets document:

1. Open your existing Google Sheets document
2. Go to File → Import
3. Click the "Upload" tab
4. Drag your CSV file or click "Select a file from your device"
5. Choose your import location:
   • Create new spreadsheet: Opens CSV in a new document
   • Insert new sheet(s): Adds as a new tab in current document
   • Replace spreadsheet: Replaces all current data
   • Append to current sheet: Adds data below existing content
6. Configure the separator type (usually auto-detect works fine)
7. Click "Import data"

Method 3: Import from URL

Google Sheets can import CSV data directly from a URL using the IMPORTDATA function:

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

This method is useful for:

• Automatically refreshing data from a live source
• Pulling data from a public API or data feed
• Keeping your spreadsheet synchronized with external data

Method 4: Copy-Paste Text Data

If you have CSV-formatted text (not a file), you can paste it directly:

1. Copy your CSV text to clipboard
2. Open Google Sheets and select the cell where you want to start
3. Paste with Ctrl+V (Windows) or Cmd+V (Mac)
4. If the data appears in a single column, select it and go to Data → Split text to columns
5. Choose the appropriate separator (comma, tab, etc.)

Troubleshooting Common Issues

1. Special Characters Display Incorrectly

If you see strange characters like "é" instead of "é", it's an encoding issue:

• Make sure your CSV file is saved with UTF-8 encoding
• Open the CSV in a text editor, then "Save As" with UTF-8 encoding
• Use our Text to CSV Converter which outputs UTF-8 by default

2. Numbers Formatted as Text

If your numbers appear left-aligned or calculations don't work:

• Select the column with numbers
• Go to Format → Number → Number
• Or use =VALUE(A1) to convert text to number

3. Dates Not Recognized

Date formats vary by region. If dates aren't recognized:

• Check your spreadsheet locale: File → Settings → Locale
• Use =DATEVALUE() to convert text dates
• Use ISO format (YYYY-MM-DD) in your CSV for best compatibility

4. Wrong Delimiter Detected

If your data ends up in one column instead of being split:

• Select all the data in the single column
• Go to Data → Split text to columns
• Click the dropdown and select the correct separator
• For European CSV files, manually select "Semicolon"

Handling Large CSV Files

Google Sheets has a limit of 10 million cells per spreadsheet. For very large CSV files:

• Split the CSV into smaller files before importing
• Use Google BigQuery for datasets larger than Sheets can handle
• Filter or remove unnecessary columns before importing

Best Practices

• Use UTF-8 encoding: Always save CSV files with UTF-8 encoding to preserve special characters
• Include headers: The first row should contain column names
• Consistent formatting: Use the same date format, number format throughout
• Clean data first: Use our Text to CSV Converter to ensure proper formatting before importing