How to convert data with DataSwitch Pro
Updated
- Choose the formats. Pick the source under From and the result under To. Pasting JSON, XML, SQL, HTML or Markdown switches the source automatically.
- Add your data. Paste text, drag a file onto the input box, or click Upload. Excel workbooks, CSV, JSON and every other supported file type are recognised by their extension.
- Adjust the options. Delimiters, JSON indentation, SQL dialect, table name and NULL handling are under Options and are remembered for your next visit.
- Copy or download. The result updates as you type. CSV downloads open correctly in Excel, and Excel output is a real .xlsx workbook.
All converters
Every format converts to every other, right here on this page. These dedicated pages explain the most popular conversions in detail, with examples and code:
Supported formats
Excel, CSV & TSV
Read any sheet of an .xlsx workbook or write a new one with typed cells. CSV parsing follows RFC 4180, detects comma, semicolon, tab and pipe delimiters, and decodes UTF-8, UTF-16 and Windows-1252 files.
JSON & JSON Lines
Format, validate and minify JSON, flatten nested objects into columns, and convert to or from newline-delimited JSON for logs, BigQuery and AI datasets.
XML
Well-formedness checks with line numbers, attributes kept as @name keys, repeated elements as arrays, and correctly escaped XML output.
YAML & TOML
YAML 1.2 and TOML 1.0 for configuration files — Kubernetes, Docker Compose, GitHub Actions, pyproject.toml, Cargo.toml and more.
SQL
Read multi-row INSERT statements from dumps, or generate INSERTs and CREATE TABLE for MySQL, PostgreSQL, SQLite and SQL Server.
Markdown & HTML tables
Generate tables for READMEs, documentation, websites and emails — or extract data from existing tables.
What the converter takes care of
- Safe type detection — numbers and booleans are typed, but leading-zero codes and long IDs stay as text.
- Inconsistent records — when JSON objects have different keys, every key becomes a column.
- Duplicate or empty headers — renamed to
name_2orcolumn_3instead of silently overwriting data. - Database-ready SQL — quoted identifiers, escaped strings, optional
CREATE TABLEand batches of 1,000 rows per statement. - Clear errors — invalid JSON, YAML, TOML or XML is reported with its position.
Private by design
Spreadsheets, customer lists and configuration files often contain information that should never be pasted into a tool that uploads it. DataSwitch Pro does all of the work in your browser, so the data you convert never reaches our server. The page itself is served from our host and displays ads from Google AdSense; the Privacy Policy explains exactly what that involves.
Frequently asked questions
Is my data uploaded to a server?
No. Parsing and conversion run in JavaScript inside your browser tab. The text you paste and the files you open — including Excel workbooks — are never sent to DataSwitch Pro. After the page loads, the converter keeps working even offline.
Can I convert Excel files directly?
Yes. Choose Excel as the source and upload an .xlsx workbook; pick the sheet if there are several. Choose Excel as the target to download a real .xlsx file with typed cells and a frozen header row.
Why does my CSV end up in a single column?
The file probably uses a semicolon or tab instead of a comma — Excel does this in many European and North-African locales. The input delimiter is auto-detected, but you can force comma, semicolon, tab or pipe under Options.
Will ZIP codes or IDs with leading zeros be changed?
No. Values such as 02134, and numbers longer than 15 digits, are kept as text so nothing is rounded or truncated. Turn off Detect numbers & booleans to keep every value as text.
How are nested JSON objects converted to CSV or Excel?
With Flatten nested JSON enabled, {"address":{"city":"Rabat"}} becomes a column named address.city. Arrays are written as JSON text in one cell so no data is lost.
Is there a file size limit?
There is no server limit because nothing is uploaded. Large inputs are processed in a background thread; files up to tens of megabytes usually convert in seconds.