π CSV to JSON Converter
Convert CSV and Excel spreadsheets into JSON arrays or export JSON back to CSV.
Converted JSON Result
Bidirectional CSV and JSON Converter
Data interchange often requires converting between flat, tabular spreadsheet representations (CSV, TSV) and nested tree structures (JSON). FixMyString bridges this gap instantly in both directions.
Why Semicolon Delimiters Matter
In Germany, France, Italy, Spain, and many Eastern European countries, Microsoft Excel defaults to semicolon delimiters (;) rather than commas. This tool natively supports semicolon-separated files, ensuring compatibility with corporate spreadsheets across global teams.
How to Paste from Excel
You do not need to save or export a file from Excel first. Simply select any range of cells in Excel, press Ctrl+C (or Cmd+C on macOS), and paste directly into the box. FixMyString recognizes clipboard tab characters and parses columns seamlessly.
Related Tools
- Excel to Markdown Table Γ’β¬β Convert spreadsheets into documentation tables.
- JSON Formatter & Validator Γ’β¬β Beautify and inspect JSON responses.
- SQL IN Clause Builder Γ’β¬β Turn column lists into database queries.
Frequently Asked Questions
How do I convert CSV to JSON?
Paste your CSV or spreadsheet table into the input area. The tool automatically detects column headers and builds an array of clean JSON objects instantly.
Can I copy and paste directly from Microsoft Excel or Google Sheets?
Yes! When you copy cells in Excel or Sheets, the clipboard contains Tab-Separated Values (TSV). Simply leave the delimiter on "Auto-detect" or choose "Tab", and your spreadsheet data will convert immediately.
Does it support semicolon (;) separated files from European Excel?
Yes! Excel in many European countries exports CSV files using semicolons (;) because commas are used as decimal separators. Select "Semicolon (;)" or let auto-detect handle it.
Can it convert JSON back to CSV?
Yes! Toggle the mode from "CSV → JSON" to "JSON → CSV" to generate a downloadable, RFC 4180 compliant CSV file from any JSON array of objects.
How are numbers and boolean values handled?
By default, "Parse numbers & booleans" is enabled, turning numeric strings like "42" into numbers and "true"/"false" into boolean values. Uncheck it if you want all fields preserved as raw strings.
Is my data secure?
Yes, 100%. No data is ever sent to any remote server or third-party service. The entire conversion happens locally in your browser memory.
Does it handle commas inside quoted fields?
Yes. The built-in parser follows standard RFC 4180 rules, correctly parsing values like "Doe, John" or multiline cells wrapped in quotation marks.