Command Palette

Search for a command to run...

CSV

CSV Converter

Convert CSV into Markdown tables or JSON.

Input
Headers come from the first row; empty lines are ignored.
Output
Enter CSV, pick a format, then convert.
Output format: Markdown table

What

CSV Converter definition

A CSV converter transforms comma-separated values into JSON, Markdown, TSV, HTML, or XML.

Cases

Use Cases

1

Convert CSV exports to JSON for scripts

2

Create Markdown tables for docs

3

Switch to TSV when commas appear in values

How To

How to Convert CSV

A step-by-step guide to turning CSV into JSON, Markdown, TSV, and more.

1

Paste CSV

Paste CSV text with headers into the input field.

2

Choose output

Select the target format (Markdown table, JSON array, etc.).

3

Convert and copy

Click Convert and copy the output.

Knowledge

Understanding CSV Format

What is CSV?
CSV (Comma-Separated Values) is a plain text format for tabular data. Each line represents a row, with values separated by commas. It's human-readable and widely supported by spreadsheets, databases, and programming languages.
CSV Structure Rules
Each record is one line. Fields are separated by commas. If a field contains commas, newlines, or quotes, it must be enclosed in double quotes. Double quotes within quoted fields are escaped by doubling them.
CSV vs TSV
TSV (Tab-Separated Values) uses tabs instead of commas as delimiters. TSV is useful when data contains many commas. Both formats are simple and portable, but CSV is more universally supported.
Encoding Considerations
Always use UTF-8 encoding for CSV files to support international characters. Excel may use different encodings by default, so explicitly save as 'UTF-8 CSV' when sharing files across systems.
Header Rows
Including a header row (first line with column names) makes CSV files self-documenting and easier to work with. Most tools and libraries can automatically use headers for data mapping.

FAQ

CSV converter FAQ

What is CSV best for?
Simple tabular data exchange between spreadsheets, BI tools, and databases.
How should I format input?
Use comma-separated rows with a header line; wrap values with commas in quotes.
When should I convert CSV to JSON or Markdown?
Use JSON for APIs or scripts; Markdown/HTML for docs and pull requests; TSV when values contain many commas.
How do I handle different delimiters or encodings?
Pick TSV when data is tab-delimited, and ensure UTF-8 input. If you export from Excel, choose UTF-8 CSV to avoid broken characters.
Where did CSV come from?
CSV grew out of early spreadsheet and database exports in the 1970s-80s as a simple text-based table format.
How popular is CSV today?
Despite newer formats, CSV remains one of the most exchanged data formats because it's human-readable and tool-agnostic.
What are common CSV use cases?
Bulk imports/exports between BI tools, spreadsheet sharing, quick analytics in notebooks, and migration scripts.
Any maintenance tips for CSV files?
Normalize encoding to UTF-8, keep delimiter and quote rules consistent, and include header rows for clarity.
CSV Converter