ESC

Data Format Converter

No data
Conversion Options

Usage Examples

E-commerce Product Data

Convert CSV product list to JSON format for API usage.

CSV JSON
Database Import

Transform JSON API data into SQL INSERT statements.

JSON SQL
Configuration File

Convert Excel settings table to YAML configuration.

Excel YAML

Sample Data

📊 Sample CSV Data
📋 Sample JSON Data
🏷️ Sample XML Data
📝 Sample YAML Data

Features

8 Format Support

CSV, JSON, XML, SQL, YAML, Excel, TSV and HTML formats

📁

File Upload

Upload files or drag and drop

Customizable

Delimiters, table names and other options

Fast & Secure

Browser processing, data not sent to servers

How to Use?

1

Select Format

Choose input and output formats

2

Enter Data

Enter, paste your data or upload file

3

Configure Options

Set delimiters and other options as needed

4

Convert

Click convert button and get the result

Frequently Asked Questions

CSV, JSON, XML, SQL (INSERT statements), YAML, Excel (XLSX), TSV, and HTML tables — in any direction between all 8 formats. For example: CSV to JSON, JSON to XML, XML to YAML, Excel to CSV, SQL to JSON, and so on. Each conversion preserves all columns and rows from the source.

Yes. Click the Upload File button or drag a file directly into the input area. Supported file extensions: .csv, .json, .xml, .yaml, .yml, .tsv, .xlsx, and .html. Excel files (.xlsx) are automatically parsed from binary format — no need to save as CSV first. Once uploaded, the content appears in the input field and conversion runs automatically.

Comma (,), semicolon (;), tab (\t), and pipe (|). When converting from CSV, select the delimiter that matches your file — European CSV exports often use semicolons. When converting to CSV, choose the delimiter your target system expects. The tool also handles quoted fields and embedded newlines in CSV values.

Upload an .xlsx file and the tool reads the first sheet automatically using a JavaScript XLSX parser running entirely in your browser. The first row is treated as column headers. Multiple sheets are not supported — if you need data from a non-first sheet, export that sheet as CSV first. XLSX files up to ~5MB work reliably; larger files may slow down due to browser memory constraints.

SQL output generates INSERT INTO statements for every row. The Table Name option (default: "data") sets the table name in the statement. Example: INSERT INTO data (name, age, city) VALUES ('Alice', 30, 'Paris'); — one statement per row. Column names are inferred from the first row of the source data. The output works with MySQL, PostgreSQL, SQLite and most other SQL databases.

Both represent the same data structures. JSON uses braces, quotes, and commas, making it compact but harder to read for humans. YAML uses indentation and no quotes on simple values, making it more readable for config files. YAML is a superset of JSON — all valid JSON is valid YAML. Use YAML for config files meant to be edited by hand; use JSON for API payloads, storage, and machine-to-machine communication.

No hard limit, but files under 10MB work smoothly since all processing happens in your browser. Very large files (50MB+) may cause the browser tab to run out of memory. For large datasets, consider splitting into smaller chunks or using a command-line tool like jq, csvkit, or xmlstarlet instead.

No. All conversion happens locally in your browser via JavaScript. Your data — even sensitive spreadsheets or database exports — never leaves your device and is not uploaded to any server.

What Is Data Format Converter?

Got a CSV that needs to be JSON? An XML dump that should be SQL INSERTs? This tool converts between 8 common data formats -- CSV, JSON, XML, SQL, YAML, Excel, TSV, and HTML tables. Paste your data or upload a file and get the output in one click.

Supported Formats

CSV with custom delimiters, JSON (pretty or minified), XML, SQL INSERT statements, YAML, Excel (XLSX), TSV, and HTML tables. Drag and drop files directly into the tool.

Common Use Cases

Converting API responses for spreadsheet analysis, preparing database imports, transforming exports between systems, or just switching formats because a colleague sent the data in the wrong one.

Tips

Files under 10MB work best since everything processes in the browser. For CSV you can switch between comma, semicolon, tab, and pipe delimiters. Excel files are auto-parsed on upload.

Privacy

All conversion happens in your browser. Your data never touches a server -- nothing is uploaded, stored, or logged.

Security and Privacy

Your data security is our priority

Local Processing

All processing happens in your browser

No Data Transfer

Your data is not sent to our servers

No Data Storage

No data is stored or shared

SSL Encryption

SSL encryption for secure connection

Also on MoreOnlineTools