Data · 25 tools · nothing uploads

CSV to table

Convert a CSV to markdown, HTML, LaTeX, SQL INSERT statements, JSON, YAML, or Jira table markup. The first row is always the header (object keys for JSON); every format quotes its own special characters. Runs entirely on your device.

Input

Options

live

CSV to table turns one CSV into a chosen shape: pick from JSON, YAML, HTML, Jira markup, SQL INSERT statements, markdown or LaTeX. Every version reads the first row as its header, or the JSON object's keys. Each target escapes its own characters, a pipe in markdown, angle brackets in HTML, a doubled quote in SQL. Numeric-looking cells skip quoting in SQL.

Questions

What formats can I export to?

Markdown, HTML, LaTeX, SQL INSERT statements, JSON, YAML and Jira table markup.

How are quotes handled per format?

Each format escapes its own way: markdown escapes a pipe with a backslash, HTML escapes angle brackets and ampersands, SQL and CSV double an internal quote character.

How does the SQL output handle numbers?

A cell matching a plain integer or decimal pattern is written unquoted into the INSERT statement exactly as typed; everything else is a quoted string literal.

What does tableName control?

The table name used in the SQL INSERT statements, defaulting to data.

Is the first row always treated as a header?

Yes, across every format, and as the JSON object keys for the json output.

What if the CSV is empty?

The tool refuses, naming the file as empty.

Related Data tools

1→1Reorder / insert CSV columnsReorder (and drop) a CSV's columns by name, and optionally insert one new column with a constant value at a given position. Quote-aware. A record with a quoted field containing a literal newline stays one record.Takes one file1→1Map CSV column namesRename a CSV's header to a new schema ("old=new" pairs), and optionally drop every column that isn't named in the mapping. Column order and data are otherwise untouched. Quote-aware. A record with a quoted field containing a literal newline stays one record.Takes one file1→1Change CSV separatorRe-delimit a CSV (comma, semicolon, tab or pipe), auto-detecting the current separator when not told what it is. Quote-aware. A record with a quoted field containing a literal newline (including in the header) stays one record.Takes one file1→1Transpose CSVSwap a CSV's rows and columns. Column 1 becomes row 1, and so on. A ragged row (fewer cells than the widest row) is padded with empty cells rather than refused. Quote-aware. A record with a quoted field containing a literal newline stays one record, not two.Takes one file1→1Split CSV into partsCut a CSV into several smaller files of N data rows each, repeating the header in every part. Quote-aware: a record with a quoted field containing a literal newline stays one record.Takes one filen→1Merge CSV filesConcatenate several CSVs with the same header into one file, in the order given. Quote-aware. A record with a quoted field containing a literal newline stays one record.Combines the files you drop1→1Remove duplicate CSV rowsStrip repeated rows from a CSV. Compares whole records, not physical lines, so a quoted field containing a newline is one record and stays one record.Takes one file1→1Find incomplete CSV recordsReport every record whose cell count doesn't match the header: too few cells (a truncated record) or too many (an unescaped comma). Read-only: nothing is changed. Quote-aware, so a record with a quoted field containing a literal newline still counts as one record with the right cell count.Takes one file