Can I use this with a typed collection?

The literal is a plain Array, so convert it to Vector or map each row yourself when you need typed collections. The column order matches the header, which usually makes that a one-liner.

Is the header part of the data?

With the header switch on, the first inner array holds the header labels; switch it off and only data rows are written, so the array starts at your first record.

Table to ActionScript Array Converter

Paste rows or drop a CSV or Excel file, pick ActionScript as the output format, and paste the variable into your .as file. You get a nested Array of Arrays, ready to iterate or feed into a data grid.

Numbers are written without quotes; text is wrapped in double quotes with backslashes, quotes and line breaks escaped the C way, so nothing breaks the literal. A blank cell becomes null, which keeps missing values out of your totals.

Table to Markdown

Turn a table into text you can paste: Markdown, HTML, TSV, SQL inserts, JSON, XML, YAML, LaTeX, INI, TOML, JSON Lines or an ASCII table. Nothing is uploaded.

Your data never leaves this browser

The file is parsed, previewed and charted on your own device. Nothing is uploaded — not even a sample. Close the tab and the data is gone.

Drop a file here, or click to chooseExcel (.xlsx), CSV, TSV or JSON

Or paste table text

How it works

1.Import the table (Excel, CSV, TSV or JSON, or paste), then pick the output format: Markdown, HTML, SQL INSERT, JSON, XML, YAML, LaTeX, vCard, iCal, pandas and more.
2.For SQL, set the table name; for vCard and iCal, map which column holds which field — a field you leave empty is simply not written out.
3.Press Generate and check the result on the right.
4.Copy it or download it. Rows that cannot become a usable contact or event are skipped rather than written out half-empty.

Frequently asked questions

Can I use this with a typed collection?: The literal is a plain Array, so convert it to Vector or map each row yourself when you need typed collections. The column order matches the header, which usually makes that a one-liner.
Is the header part of the data?: With the header switch on, the first inner array holds the header labels; switch it off and only data rows are written, so the array starts at your first record.

Related tools

Table to SQL INSERT Generator

Turn a CSV or Excel table into SQL INSERT statements in your browser: the header row becomes the column list, quotes are escaped, blanks become NULL.

CSV to Markdown Table Converter

Turn a CSV, Excel or JSON table into a Markdown table for a README, a Notion page or a pull request. Pipes and line breaks are escaped in the browser.

CSV to XML Converter

Turn a CSV, Excel or JSON table into well-formed XML in your browser: column names become element names, special characters are escaped, blanks stay empty elements.

CSV to YAML Converter

Turn a CSV, Excel or JSON table into a clean YAML list, with values quoted whenever they would otherwise be read back as numbers, booleans or null.

CSV to LaTeX Table Converter

Turn a CSV or Excel table into a ready-to-paste LaTeX tabular environment, with ampersands, percent signs, underscores and backslashes escaped.

CSV to JSON Lines (JSONL) Converter

Turn a CSV or Excel table into JSON Lines: one JSON object per line, ready for jq, log pipelines and bulk imports.

CSV to INI Converter

Turn a CSV or Excel table into INI sections: one numbered block per row with key=value lines, ready for legacy config files and importers.

CSV to TOML Converter

Turn a CSV or Excel table into TOML using an array of tables, with numbers kept numeric, blank cells written as empty strings and non-Latin keys quoted.

CSV to ASCII Table Converter

Turn a CSV or Excel table into an ASCII box table for logs, code comments and plain-text docs, with CJK characters aligned to double width.

Table to PHP Array Converter

Turn a CSV or Excel table into a PHP array in your browser: the header row becomes the first entry, numbers stay numbers and blank cells become null.

Table to Ruby Array Converter

Turn a CSV or Excel table into a Ruby array in your browser: the header row becomes the first entry, numbers stay numbers and blank cells become nil.

Table to AsciiDoc Converter

Turn a CSV or Excel table into an AsciiDoc table in your browser: the header row gets the header option, and pipes inside cells are escaped.

Table to Trac Wiki Converter

Turn a CSV or Excel table into a Trac wiki table in your browser: one line per row, pipe-separated cells and a bold header row.

Table to Avro Schema Converter

Turn a CSV or Excel table into an Avro record schema in your browser: one field per column, numeric columns as double, every field nullable.

Table to Protobuf Message Converter

Turn a CSV or Excel table into a Protobuf message definition in your browser: one field per column, numbers as double, everything else as string.

Table to RDF Turtle Converter

Turn a CSV or Excel table into RDF triples in your browser: the first column becomes the subject, every other column one statement about it.

Table to DAX DATATABLE Converter

Turn a CSV or Excel table into a Power BI DATATABLE expression in your browser: column types are inferred and text is quoted for you.

Table to Qlik LOAD INLINE Converter

Turn a CSV or Excel table into a Qlik LOAD INLINE statement in your browser: field names, text quoting and the load script are done for you.

Table to ASP VBScript Array Converter

Turn a CSV or Excel table into a VBScript nested array in your browser: numbers stay numbers, text is quoted and blank cells become Null.

CSV to HTML Table Converter

Turn a CSV or Excel table into an HTML table in your browser: header cells, borders and escaping are handled, ready to paste into a page.

CSV to Jira Table Converter

Turn a CSV or Excel table into Jira wiki table markup in your browser: the header row, cell escaping and the syntax are done for you.