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.
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
Click the clock icon (Triggers) in the left sidebar
Click Add Trigger
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:
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:
Install the add-on
Connect your CSV source (upload, Google Drive, or cloud storage)
Map columns to your sheet
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.
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:
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.