Skip to main content

What Is a CSV File, and How Do You Open One?

Updated 4 November 2026 · 2 min read

CSV files turn up everywhere: bank statement downloads, contact exports, school results, product lists. They open in Excel, but sometimes the numbers look wrong or the letters come out garbled. Here is what a CSV file really is, and how to open and create one properly.

Free toolCSV to JSON ConverterOpen

What is a CSV file?

CSV stands for comma-separated values. It is a plain text file that holds a table: each line is one row, and the cells in that row are separated by commas. The first line is usually the header with the column names. There is no formatting, no formulas and only one sheet, which is why almost every program can read it.

A small CSV file, as plain text
name,city,amount
Asha,Pune,1200
Ravi,"Delhi, NCR",850

A cell that contains a comma, like Delhi, NCR above, is wrapped in double quotes so the comma is not read as a new column. Some files use a semicolon or a tab instead of a comma, especially in Europe, where the comma is used for decimals.

How to open a CSV file

  • In Excel: double-click the file, or use File > Open. Each column lands in its own cell.
  • In Google Sheets: choose File > Import, upload the CSV and pick Replace spreadsheet or Insert new sheet.
  • On a Mac: open it in Numbers, which comes with macOS, or in Excel.
  • To see the raw text: open it with Notepad on Windows or TextEdit on a Mac. This is the quickest way to check the separator and the quotes.

When Excel opens a CSV wrongly

  • Leading zeros disappear (a PIN code 011023 becomes 11023) or long numbers turn into 1.23E+15: Excel guesses the column is a number. Use Data > From Text/CSV instead of double-clicking, and set that column to Text before you load it.
  • Accented or Hindi letters look garbled: the file is in UTF-8 but was opened as an older encoding. In Data > From Text/CSV, choose 65001: Unicode (UTF-8) as the file origin.
  • Everything lands in one column: the file uses semicolons or tabs. Choose the right delimiter in the import window.

How to create a CSV file

  1. Put your table in Excel or Google Sheets, with the column names in the first row.
  2. In Excel, choose File > Save As and pick CSV UTF-8 (Comma delimited). In Google Sheets, choose File > Download > Comma-separated values (.csv).
  3. Only the sheet you are on is saved, and formatting and formulas are dropped; the values stay.

You can also write a CSV by hand in any text editor: type the rows with commas between cells, then save the file with a .csv ending.

Turning a CSV into JSON

If you need the data for a website, an app or an API, paste the CSV into the CSV to JSON Converter. It reads quoted cells, semicolons and tabs, keeps codes like PIN codes as text, and runs in your browser, so the file is not uploaded.

Try it now: CSV to JSON Converter

Paste CSV or open a .csv file and get clean JSON at once: one object per row, with the header row as keys.

Open CSV to JSON Converter