CSV to JSON Online Converter Tool

Introduction

This online table format converter supports Markdown, CSV, JSON, HTML, YAML, LaTeX, SQL, and Excel. Use dedicated routes such as markdown to CSV, markdown to JSON, Excel to Markdown, CSV generator online, and JSON generator online to transform tabular data in your browser.

Supported Formats

• Markdown Table: Uses | and - characters, widely used in Markdown documents
• CSV: Comma-separated values, can be opened directly by spreadsheet software such as Excel
• TSV: Tab-separated values, often used for data exchange between spreadsheet applications
• JSON: Array of objects, two-dimensional array, etc., widely used in web applications
• HTML Table: Uses <table>, <tr>, <th>, <td> tags for structured data
• YAML: Human-readable data serialization format, commonly used in config files
• LaTeX Table: Uses tabular environment, widely used in academic papers and technical docs
• SQL INSERT: For inserting data into database tables
• Excel: Supports .xlsx / .xls import and conversion to other formats

How to Use

1. Enter your table data in the left input box, or upload a file (supports .csv, .json, .md, .xlsx, .xls, drag-and-drop)
2. Select input format (Markdown, CSV, JSON, HTML, YAML, or Excel)
3. Select desired output format (Markdown, CSV, JSON, HTML, YAML, LaTeX, SQL, or TSV)
4. The visual table preview in the middle shows parsed data
5. The right output box shows the converted result
6. You can copy the result or download as a file

Table Editor

The built-in spreadsheet editor supports: editing cell values in the visual preview; Transpose (swap rows and columns); Remove empty rows/columns; Deduplicate rows; Sort by column; Find and replace (regex supported); Case conversion (upper, lower, capitalize).

Output Options

• JSON format: Array of objects, 2D array, column array, key-value array
• JSON indent: 2/4/8 spaces or tab; JSON compact toggle
• CSV delimiter: Comma, tab, semicolon, or pipe; CSV quote optional
• UTF-8 BOM: Toggle for better Excel compatibility

Notes

• Input data must conform to the selected format syntax
• The first row of the table is treated as the header
• JSON must be valid JSON syntax
• Excel parsing is based on SheetJS

FAQ

Q: Which table formats are supported for conversion?

The tool supports conversion between a wide range of common table formats, including Markdown tables, HTML tables, CSV, TSV, JSON, LaTeX tables, and SQL INSERT statements. Paste table data in any supported format and select your desired output format. For example, you can quickly convert CSV data into a Markdown table for documentation, or turn an HTML table into JSON for programmatic use.

Q: Can I import data from Excel?

Yes. Copy a range of cells in Excel and paste it into the input area—the tool will automatically detect the tab-separated data and parse it. From there, you can convert to any target format. Note that Excel-specific features like merged cells, formulas, and cell styling are lost when copying; the tool works with plain-text tabular data only.

Q: Is the converted output guaranteed to be accurate?

In the vast majority of cases, the conversion is accurate. The tool strictly follows each format's specification for both parsing and output generation, ensuring data isn't lost or misaligned. That said, edge cases—such as cell values containing the format's own delimiter (commas in CSV, pipe characters in Markdown), multi-line cell content, or special escape sequences—may require manual review. It's a good practice to spot-check the result against the original data.

Q: Are there limits on table size?

The tool runs entirely in your browser, so no data is uploaded to a server. There's no hard limit on the number of rows or columns, but very large tables (thousands of rows) may cause the page to slow down. For typical use cases with small to medium tables (a few hundred rows), the tool converts instantly. For large-scale data transformations, consider using a dedicated command-line tool or script.

Q: How are special characters handled in table data?

The tool automatically escapes special characters for each output format. For Markdown, pipe characters (|) are escaped. For CSV, cells containing commas, newlines, or double quotes are wrapped in quotes. For HTML output, special characters are converted to their HTML entities. If you notice display issues with certain characters after conversion, you can adjust them manually or preprocess the data before converting.