CSV to Firebase JSON Converter

Paste rows or drop a CSV or Excel file, pick Firebase as the output format, and paste the JSON into the Realtime Database console or a set call. The first column is used as the key of each record and the remaining columns become its fields.

Keys are made unique: a repeated value gets a numbered suffix and an empty first column falls back to a generated row name, so no record silently overwrites another. Empty cells become null, which is how the database represents a missing value.

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.

Or paste table text

How it works

  1. 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. 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. 3.Press Generate and check the result on the right.
  4. 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 paste this into the Firebase console?
Yes: the console import accepts exactly this shape, an object whose keys are the record ids. Open the database menu, choose import and pick the JSON file.
What if the first column is not unique?
The tool appends a suffix such as (2) so nothing is lost and the same key is written into the record. If the duplicates are real, clean them up before importing so your ids stay stable.

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.

Table to ActionScript Array Converter

Turn a CSV or Excel table into an ActionScript 3 array literal in your browser: numbers stay numbers, text is escaped 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.

CSV to pandas DataFrame Converter

Turn a CSV or Excel table into a pandas DataFrame literal in your browser: numeric columns stay numbers, text is escaped and empty cells become None.

CSV to R data.frame Converter

Turn a CSV or Excel table into an R data.frame in your browser: numeric columns stay numbers, text is quoted and empty cells become NA.

CSV to MATLAB Table Converter

Turn a CSV or Excel table into a MATLAB table in your browser: numeric columns as vectors, text as a string array, names in VariableNames.

Table to MediaWiki Converter

Turn a CSV or Excel table into MediaWiki table markup in your browser: the wikitable class, the header row and cell escaping are handled.

Table to reStructuredText Converter

Turn a CSV or Excel table into a reStructuredText simple table in your browser: column widths are measured and the divider rows written for you.

Table to BBCode Converter

Turn a CSV or Excel table into BBCode table markup in your browser: the table, row, header and cell tags are written with escaping.

Table to Textile Converter

Turn a CSV or Excel table into Textile table markup in your browser: the header marker, the pipes and the escaping are handled.

CSV to JSON Converter

Turn a CSV or Excel table into a JSON array in your browser: the header row becomes the keys, and empty cells become null.

CSV to TSV Converter

Turn a CSV or Excel table into tab-separated text in your browser: headers included, tabs and line breaks inside cells flattened.