Expense Sorted

Import CSV to Google Sheets: 4 Methods + Auto-Update

|
By Anonymous

To import a CSV into Google Sheets, open a spreadsheet, click File > Import, choose the Upload tab, select your CSV, then pick an import location and separator type and click Import data. For a CSV that changes, use IMPORTDATA with a public URL or an Apps Script trigger to auto-update it.

Importing CSV files is one of the most common Google Sheets tasks, whether you're moving bank transactions, sales exports or budget records. This guide covers four methods, from a one-time upload to a scheduled auto-import, plus fixes for the errors people hit most: wrong columns, dates turning into numbers, and broken characters.

If you're importing bank data specifically, see how to import a bank CSV into Google Sheets or how to auto-categorize bank transactions in Google Sheets.

Try Your CSV Import Here

Preview how your CSV splits into columns before you bring it into Sheets:

Try it yourself

See Privacy in Action

Upload any CSV file to see how data is processed entirely in your browser. Nothing leaves your device.

Start importing

The Quick Answer: Which Method Should You Use?

MethodBest forUpdates automatically?Setup
1. File > ImportOne-time imports from your computerNoUnder a minute
2. IMPORTDATA formulaA CSV at a public URLYes, on recalculationA few minutes
3. Apps Script + triggerPrivate or recurring CSVs, custom cleanupYes, on a schedule10-20 minutes
4. Add-on / extensionNo-code scheduled importsYes, depends on toolA few minutes

Method 1: File > Import (Manual, One-Time)

This is the method to use for a CSV saved on your computer.

Step 1: Open a spreadsheet

Go to sheets.google.com and open a blank or existing spreadsheet.

Step 2: Open the Import dialog

Click File → Import, then choose the Upload tab and drag in your CSV (or click Browse).

Step 3: Choose the import location

Google Sheets asks where the data should go:

  • Create new spreadsheet: a fresh file, best for your first import
  • Insert new sheet(s): adds a tab to the current file
  • Replace spreadsheet or Replace current sheet: overwrites existing data
  • Append to current sheet: adds rows below your existing data
  • Replace data at selected cell: drops the data where your cursor is

Step 4: Pick the separator type

Leave it on Detect automatically, or choose Comma, Semicolon, Tab or a custom separator if your columns come out wrong.

Step 5: Decide on text conversion

The Convert text to numbers, dates, and formulas option turns values like 2026-10-01 into real dates. Untick it if you need to keep leading zeros (account numbers, postcodes) as text.

Click Import data and you're done.

Tip: File > Open also accepts a CSV, but it always creates a brand new spreadsheet. Use File > Import when you want to append to or replace data in a sheet you already use.


Method 2: The IMPORTDATA Formula (CSV at a URL)

If your CSV lives at a URL, one formula pulls it in and keeps it updated:

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

IMPORTDATA also takes an optional delimiter and locale, which helps with semicolon-separated exports:

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

Using a Google Drive file

IMPORTDATA can only read URLs that are reachable without signing in. For a file in Drive, the simplest route is to open the CSV with Google Sheets (right-click → Open with → Google Sheets). If you need it to feed another sheet, use IMPORTRANGE from that converted sheet instead.

Best for: Public data feeds and exports that refresh on their own.

Limitation: It won't work for files that need a login, and you get little control over formatting. For private files, use Method 3.


Method 3: Google Apps Script (Automatic and Private)

Apps Script is free, runs inside your Google account and can import on a schedule.

Step 1: Open Apps Script

In your Google Sheet, click Extensions → Apps Script.

Step 2: Paste this script

function importCSV() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Import");

  // Replace with your CSV URL
  const csvUrl = "YOUR_CSV_URL_HERE";

  const csv = UrlFetchApp.fetch(csvUrl).getContentText();
  // parseCsv handles quoted fields and commas inside values
  const data = Utilities.parseCsv(csv);

  sheet.clearContents();
  sheet.getRange(1, 1, data.length, data[0].length).setValues(data);
}

Create a tab called Import first, or change the name in the script. Using Utilities.parseCsv instead of splitting on commas means a value like "Smith, John" stays in one cell.

Step 3: Run it once

Click Run, then approve the permission prompt (Review permissions → Allow).

Step 4: Schedule it

  1. Click the clock icon (Triggers) in the left sidebar
  2. Click Add Trigger
  3. Choose importCSV, Time-driven, and how often (hourly, daily, weekly)

Your sheet now refreshes on that schedule.

Importing a CSV from Google Drive

For a CSV stored in your own Drive, swap the fetch line for:

const csv = DriveApp.getFileById("YOUR_FILE_ID").getBlob().getDataAsString();

Best for: Recurring imports, private files, and cleanup steps you want to run every time.


Method 4: Add-ons and Extensions (No Code)

Add-ons from the Google Workspace Marketplace, such as Coupler.io and Sheetgo, connect a CSV source and refresh it on a schedule without code.

The usual flow:

  1. Install the add-on
  2. Connect your CSV source (upload, Google Drive, or cloud storage)
  3. Map columns to your sheet
  4. Turn on auto-refresh

If your CSV is a bank export and the goal is a categorized expense list rather than raw rows, a dedicated bank CSV expense tracker does the import and categorization in one step.


Troubleshooting Common CSV Import Problems

My data split into the wrong columns

The separator is wrong. Re-import with File > Import and choose the separator your file uses. European bank exports often use semicolons because the comma is the decimal mark.

My dates show as numbers

Sheets stores dates as serial numbers. Select the column, then Format → Number → Date. If dates landed in the wrong day/month order, set File → Settings → Locale to match the file before importing.

Leading zeros disappeared

Untick Convert text to numbers, dates, and formulas during import, or format the column as Plain text first.

Strange characters (é, �) in my data

The file isn't UTF-8 encoded. Re-save it as CSV UTF-8 (Excel offers this option in Save As) and import again.

Can I import an Excel (.xlsx) file?

Yes, with File > Import or File > Open: Sheets accepts .xlsx directly. IMPORTDATA only reads CSV and TSV.

How do I add new rows without overwriting old ones?

Choose Append to current sheet in the import dialog. In Apps Script, write to sheet.getLastRow() + 1 instead of row 1.

My CSV is very large

Google Sheets has a per-spreadsheet cell limit, so very large files can fail. Split the file, import only the columns you need, or import recent rows only.


From CSV to a Working Expense Tracker

Importing is step one. If the CSV is your bank statement:

  1. Import the CSV with one of the methods above
  2. Categorize transactions: AI transaction categorization explained
  3. Working in Excel instead? Auto-categorize bank transactions in Excel
  4. Build a dashboard: a complete financial dashboard
  5. Follow a repeatable routine: the complete expense tracking workflow
  6. See how long your savings last: financial runway calculator

Bottom Line

  • One-off file on your computer? Use File > Import
  • CSV at a public URL? Use IMPORTDATA
  • Private file that changes? Use Apps Script with a time-driven trigger
  • No code at all? Use an add-on

Set it up once and the import keeps itself up to date.

Related Articles

Frequently Asked Questions

How do I import a CSV into Google Sheets without losing formatting?▾

Use File > Import instead of File > Open. After uploading your CSV, the Import dialog lets you choose delimiter types, column data formats, and whether to replace or append the current sheet, which preserves your existing formatting.

Can I automatically update a Google Sheet when a CSV file changes?▾

Yes. If the CSV is at a public URL, IMPORTDATA refreshes it on its own. For private files or more control, use Google Apps Script with a time-driven trigger that fetches the CSV and overwrites the sheet on a schedule.

What is the difference between IMPORTDATA and File > Import in Google Sheets?▾

IMPORTDATA is a formula that pulls live data from a CSV URL into a sheet, but it has limited formatting control. File > Import is a manual upload that gives you full control over delimiters, column formats, and where the data is placed.

Why does my CSV data split into the wrong columns in Google Sheets?▾

This usually happens when the delimiter is incorrect. During import, check the Separator type option and select the delimiter your CSV actually uses—typically a comma, but sometimes a semicolon or tab.