About the CSV to Table Viewer

CSV (Comma-Separated Values) is the simplest and most universally supported tabular data format. It is a plain text file where each line is a row and values are separated by commas (or sometimes semicolons or tabs). Every spreadsheet application, database, and data analysis tool can import and export CSV, making it the standard format for sharing structured data between systems.

CSV format rules to know

Commas in values — if a value contains a comma, wrap it in double quotes: "London, UK"
Quotes in values — a double quote inside a quoted field is escaped by doubling it: "He said ""hello"""
Header row — the first row is usually column names; some files do not have a header
Encoding — UTF-8 is standard; Excel may produce UTF-8 with BOM or Windows-1252, causing garbled special characters

CSV vs Excel vs JSON

CSV is plain text with no formulas, formatting, or multiple sheets — ideal for simple tabular data exchange. Excel (.xlsx) preserves formatting and formulas but requires software to parse. JSON is better for nested hierarchical data. For flat row-column data shared between systems, CSV remains the most interoperable choice.

CSV in data workflows

CSV is the universal format for moving tabular data between systems. Database exports (MySQL, PostgreSQL, Excel) default to CSV. Data science workflows start by loading CSVs with pandas or R. Business intelligence tools import CSV for ad-hoc analysis. Understanding CSV structure helps diagnose import errors and clean data before analysis.

Pandas (Python) — df = pd.read_csv("file.csv", encoding="utf-8")
R — df <- read.csv("file.csv", stringsAsFactors=FALSE)
SQL import — most databases support COPY or LOAD DATA INFILE for bulk CSV import
Excel Power Query — Data > Get Data > From File > From Text/CSV for reliable import with encoding control

Frequently Asked Questions

What is a CSV file?

CSV stands for Comma-Separated Values. It is a plain text format where each line is a data row and values within each row are separated by commas. The first line is usually a header with column names. CSV files can be opened in any text editor, spreadsheet application, or database tool.

Why does my CSV show garbled special characters?

This is typically a character encoding mismatch. Excel often saves CSV in Windows-1252 encoding, while most tools expect UTF-8. Open the file in a text editor, re-save as UTF-8 without BOM, then re-import. When opening in Excel, use Data > From Text/CSV and explicitly specify UTF-8 encoding.

What delimiter should I use?

Use comma for maximum compatibility — it is the universal standard. Use semicolon if your data contains many commas (common in European Excel locales). Use tab (TSV format) when both commas and semicolons appear in your data values.

Can CSV files contain multiple sheets?

No. CSV is a single flat table. For multiple tables, export each sheet as a separate CSV file, or use Excel (.xlsx), SQLite, or a JSON array of objects instead.

How do I open a CSV correctly in Excel?

Do not double-click a CSV file directly — Excel may misinterpret encoding and format leading zeros as numbers. Instead: open Excel, go to Data > Get External Data > From Text, select your file, and follow the import wizard specifying UTF-8 encoding and the correct delimiter.