Sheetzy guide

How to Open a CSV File in Google Sheets (Without Losing Your Data)

By Mani Dazzle, Template maker at Sheetzy · 17 November 2026

What a CSV actually is

CSV stands for comma-separated values: a plain text file where each line is a row and commas mark the columns. Banks, Shopify, Etsy, payment apps and government portals all export data this way because every spreadsheet program on earth can read it.

There is nothing to install and nothing to convert. Google Sheets reads CSVs out of the box - the only skill is knowing which of the three import routes fits what you are doing.

Way 1: Import into a brand-new spreadsheet

Go to sheets.google.com and click the folder icon (Open file picker) at the top right. Choose Upload, drag your CSV in, and Sheets opens it as a brand-new spreadsheet in one step.

This is the route for a quick look at a bank statement or an export you will not keep. The new file lives in your Drive like any other Sheet.

Way 2: Import into a spreadsheet you already have

Open your existing file, then File > Import > Upload and pick the CSV. The important choice is the Import location dropdown: Append to current sheet adds the rows under your data, Replace data at selected cell drops them where your cursor is, and Insert new sheet puts them on their own tab.

This is the route we use when a template needs historical data loaded in - for example past transactions going into a budget tracker's data tab. Set Separator to Comma rather than Detect automatically if the columns come out wrong.

Way 3: Straight through Google Drive

Drag the CSV into drive.google.com. Once uploaded, double-click it and choose Open with > Google Sheets. Drive shows a plain preview first, so do not panic at the unformatted table - the Sheets version opens properly columned.

This route is best when someone emails you a CSV and you want it filed in a specific Drive folder before you even look at it.

Fix 1: Everything lands in one column

If the whole import sits in column A with commas visible, the separator guess went wrong. Delete the imported data, import again, and this time choose the separator manually: Comma for most exports, Semicolon for files from some European tools, Tab for TSV files.

Already imported and do not want to redo it? Select the column, then Data > Split text to columns, and pick the separator there. Same result, no re-import.

Fix 2: Dates, phone numbers and codes get mangled

Sheets helpfully converts anything date-shaped into its own date format and strips leading zeros from numbers. 007 becomes 7, and 03/04/2026 may flip day and month depending on your locale.

For codes and IDs that must keep their zeros, format the target column as Plain text (Format > Number > Plain text) before pasting or importing. For flipped dates, check File > Settings > Locale - a file exported in US format read under a UK locale swaps day and month silently.

When the CSV is too big

Google Sheets tops out at 10 million cells per file. Most CSVs never come close, but multi-year payment exports can. Split the CSV by year (any text editor can do it) and import the parts onto separate tabs, then point your summary formulas at all of them.

Once your data is in, the next step is usually turning it into something readable - our guide on building a Google Sheets dashboard covers exactly that, and the Ledger sales tracker has the data tab pre-formatted so CSV imports land cleanly.

Quick answers

Can Google Sheets open CSV files?

Yes, natively. Upload the CSV to Google Drive and open it with Google Sheets, or use File > Import inside an existing spreadsheet. No converter or paid tool is needed.

Why does my CSV open as one long column in Google Sheets?

The import guessed the wrong separator. Re-import and set the separator option to Comma (or Semicolon for some European exports) instead of Detect automatically. The columns will split correctly.

Why do my dates or codes change when I open a CSV?

Sheets auto-formats anything that looks like a date or a number: 01/02 becomes 1 February and 007 becomes 7. Import into a plain-text formatted column, or fix the column format right after import and re-type only the broken cells.

How do I open a CSV in Google Sheets on my phone?

Save the CSV to Google Drive, open the Drive app, tap the file, and choose Open with Sheets. The mobile app handles small CSVs fine; for files over about 10 MB, use a computer.

Keep going

More from Sheetzy

Momentum habit tracker Google Sheets template on a tablet, dashboard with monthly progress

Momentum

Habit Tracker Spreadsheet Template

A full-year habit tracker that keeps score gently: daily ticks, weekly rhythm, monthly rollups and a year view that shows how far you have come.

₹358₹39810% OFF DIRECT
Details

All guides Browse the templates