How to Open a CSV File (Excel, Sheets, Text Editor)

Someone sent you a .csv file and you just want to look at it. Sounds simple — until you double-click it and Excel smears everything into one column, or the names with accents turn into garbage like é and ñ. CSV is supposed to be the universal, no-fuss format, and most of the time it is. The trouble starts with two things almost nobody mentions: which character the file uses to separate values, and which text encoding it was saved in.

This guide covers every practical way to open and view a CSV file, how to fix the two classic problems, and how to convert a CSV into Excel or JSON when you need more than a quick look.

What a CSV file actually is

A CSV (Comma-Separated Values) file is just plain text. The first line is usually a header row of column names; every line after it is a row, with values separated by commas:

id,name,city,active
1,Ana,Berlin,true
2,Marko,Zagreb,false

Because it's plain text, you can open a CSV in almost anything — a spreadsheet app, a text editor, or a browser. The right choice depends on what you want to do with it.

Option 1: Open a CSV in Excel

Excel is the default for most people, but double-clicking isn't always the best route — Excel sometimes guesses the separator or encoding wrong.

The reliable way:

1. Open Excel first, with a blank workbook.
2. Go to the Data tab and choose From Text/CSV (Get Data).
3. Select your file.
4. In the preview, check the Delimiter (comma, semicolon, tab) and the File Origin (encoding). Pick UTF-8 if accented characters look wrong.
5. Click Load.

Using the import dialog instead of double-clicking is what lets you fix split columns and garbled text before the data even lands in the sheet.

Option 2: Open a CSV in Google Sheets

Google Sheets handles CSVs cleanly and works on any device with a browser:

1. In Google Sheets, choose File → Import.
2. Upload the CSV (or pick it from Drive).
3. Choose Separator type — Detect automatically usually works, but you can force comma or semicolon.
4. Import.

Sheets reads UTF-8 well, so it's a good fallback when Excel mangles special characters.

Option 3: Open a CSV in a text editor

Sometimes you just want to see the raw lines — to check the delimiter, count rows, or confirm the header. Any text editor opens a CSV instantly: Notepad, TextEdit, VS Code, Sublime, or even your browser (drag the file into a tab). This is the fastest way to diagnose a problem file, because you see exactly what's in it without a spreadsheet's interpretation getting in the way.

Fixing the two classic CSV problems

Everything lands in one column

This means the separator doesn't match what your app expects. Many European locales export with semicolons (;) instead of commas, because the comma is used as a decimal point. The fix is to tell the import dialog the correct delimiter (Excel's From Text/CSV, or Sheets' separator option). Don't rely on double-clicking — use the import flow where you can set it.

Accented characters show up as gibberish

Names like José turning into José is an encoding mismatch. The file was almost certainly saved as UTF-8, but your app opened it assuming a different encoding. The fix is to specify UTF-8 when importing — Excel's File Origin setting, or simply using Google Sheets, which defaults to UTF-8. If you're saving a CSV yourself, save it as UTF-8 so the next person doesn't hit the same wall.

Convert a CSV to Excel or JSON with Toolmingo

Viewing is one thing; sometimes you need the data in a different format — a proper Excel file to share, or JSON to feed an application. Toolmingo does this free, entirely in your browser, with no upload, so a CSV full of customer names or emails never leaves your machine.

To turn a CSV into an Excel spreadsheet:

1. Open the Spreadsheet Converter.
2. Drop in your CSV file (or paste the data).
3. Choose Excel as the output format.
4. Download the .xlsx file.

The same Spreadsheet Converter also converts between CSV, Excel, and JSON, so if a program needs your spreadsheet data as JSON, you can produce it in the same place — no software to install and nothing sent to a server.

A quick decision guide

• Just need to read it? Text editor for raw lines, or Google Sheets for a clean table.
• Need to sort, filter, or chart? Import into Excel or Sheets with the correct delimiter and UTF-8 encoding.
• Need it in another format? Convert to Excel or JSON with the Spreadsheet Converter.

FAQ

Why does my CSV open all in one column in Excel?

Because the delimiter Excel expects doesn't match the one in the file — often the file uses semicolons while Excel expects commas (or vice versa, depending on your regional settings). Open Excel first, use Data → From Text/CSV, and set the correct delimiter in the preview instead of double-clicking the file.

How do I fix garbled or weird characters in a CSV?

Those are caused by an encoding mismatch. The file is usually UTF-8 but is being read with a different encoding. When importing into Excel, set File Origin to UTF-8; or open the file in Google Sheets, which defaults to UTF-8. When you save a CSV yourself, save it as UTF-8.

How do I convert a CSV to Excel or JSON without installing software?

Use the Spreadsheet Converter. It runs entirely in your browser, so you can convert CSV to Excel or JSON without installing anything, and your file is never uploaded to a server — safe for data with personal or business details.