snaptxt.app

Convert CSV to JSON (and back)

Convert CSV or TSV to JSON, or JSON back to CSV. Auto-types numbers, handles quoted fields with commas and newlines, custom delimiters. Free, in your browser.

CSV5 lines · 185 B
JSON

Your spreadsheet stays on your device.

Parsing uses Papa Parse running in your browser. No upload, no server — safe for customer data, exports, and anything else you wouldn’t paste into a random site.

How to use it

  1. 1Pick a direction — CSV → JSON or JSON → CSV.
  2. 2Set the delimiter (comma, tab, semicolon, pipe, or a custom string). Toggle whether the first row is a header.
  3. 3Paste your data on the left. The output appears on the right and updates as you type.
  4. 4Click Download to save the result as a .json or .csv file, or Copy to send it to the clipboard.

Common use cases

  • Lift a spreadsheet export into JSON to feed an API or a data pipeline.
  • Convert a JSON array of objects (e.g. from a webhook log) into a CSV you can open in Excel or Numbers.
  • Migrate data between systems that prefer different formats — most B2B exports are CSV, most modern APIs are JSON.
  • Inspect a tab-separated SQL export by converting it to a readable JSON shape.
  • Clean up an inconsistently-quoted CSV from someone else's pipeline — the parser handles quoted commas and embedded newlines.

Frequently asked questions

Is my data sent to a server?
No. The conversion runs entirely in your browser using Papa Parse. Important when the input is a customer list, sales export, or anything else with personal data — it stays on your machine.
Does it handle CSV fields with commas, quotes, or newlines?
Yes. The parser follows RFC 4180 — fields wrapped in double quotes can contain commas, newlines, and escaped quotes (""). The sample input demonstrates a row with a comma inside a quoted field.
What's TSV?
Tab-Separated Values — the same shape as CSV but with tabs between fields instead of commas. Pick Tab as the delimiter and paste your TSV input.
Will numbers stay as numbers?
Yes. CSV → JSON auto-detects numeric and boolean values ("42" becomes 42, "true" becomes true). If you'd prefer everything as strings, paste the JSON back through with the toggle and edit by hand.
Can I round-trip a file?
Yes — convert CSV → JSON, then hit Swap. The result goes back through as JSON → CSV. Useful for sanity-checking that the parser read your delimiter and quotes correctly.
What about CSV without headers?
Uncheck 'First row is header'. CSV → JSON returns an array of arrays (raw rows); JSON → CSV expects an array of arrays as input.

Related tools

Base64 Encode / Decode
Encode and decode text and files to and from Base64.
HTML Live Preview
Write HTML, CSS, and JavaScript and see the result instantly.
JSON Formatter
Format, validate, minify, diff, and explore JSON — with optional on-device AI that summarizes any payload in plain English.
JWT Decoder
Inspect the header, payload, and expiry of any JSON Web Token — with optional on-device AI that explains what the token grants in plain English.
SQL Formatter
Beautify, format, and minify SQL queries for any dialect — with optional on-device AI that explains what a query does in plain English.
Unix Timestamp Converter
Convert Unix timestamps to dates and back, in any timezone.
Hash Generator
Generate MD5, SHA-1, SHA-256, and SHA-512 hashes in your browser.
JSON to TypeScript
Generate TypeScript interfaces or type aliases from JSON.
Markdown to PDF
Convert Markdown to a beautifully styled PDF in your browser.
QR Code Generator
Make QR codes for websites, Wi-Fi passwords, contact cards, social handles, email, SMS, and more. Download as PNG or SVG — or as a ZIP with one branded QR per social platform.
Password Generator
Generate strong, secure passwords in your browser. Nothing is sent or saved to any server.
Text Diff
Compare two pieces of text and see line-by-line, word-by-word, or character-by-character what changed.
UUID / ULID Generator
Generate UUID v4, UUID v7, or ULID identifiers in bulk, instantly in your browser.
SVG to PNG / JPEG / WebP
Convert SVG to PNG, JPEG, or WebP at any size — quality slider, transparent or colored background, copy to clipboard. Free, in your browser.
URL Encoder / Decoder
Encode or decode URLs and query parameters with component-vs-full-URI scope, plus a query-string breakdown. Free, in your browser.
Regex Tester
Test JavaScript regular expressions with live highlighting and a capture-group inspector — plus an AI regex generator that turns plain-English descriptions into regex (on-device Gemini Nano).
Color Converter
Convert colors between HEX, RGB, HSL, HSV, and OKLCH, and generate tint, shade, and harmony palettes. Free, in your browser.
HTML ↔ Markdown Converter
Convert HTML to Markdown or Markdown to HTML with a live preview. GFM tables, fenced code blocks, inline formatting. Free, in your browser.
Cron Builder
Build cron expressions visually or describe the schedule in plain English and let on-device AI write it for you. Plain-English explanation, next 5 runs, presets.
YAML ↔ JSON Converter
Bidirectional YAML / JSON conversion with multi-document support and indentation control. Free, in your browser.
Word & Character Counter
Live word, character, sentence, and paragraph counts with reading and speaking time. Free, in your browser.
Lorem Ipsum Generator
Generate placeholder text — paragraphs, sentences, words, or HTML-wrapped output. Free, in your browser.
JWT Generator
Sign JSON Web Tokens with HS256/384/512, RS256/384/512, or ES256/384. In-browser key generation, no server.
Image Compressor
Compress PNG, JPEG, and WebP images with a live quality slider and side-by-side preview. Free, in your browser.
Favicon Generator
Generate the full favicon set — ICO, PNGs at every size, apple-touch-icon, and PWA manifest — from one image. Free, in your browser.
AI Code Explainer
Paste code, get a plain-English explanation from on-device Gemini Nano — no upload, no API key, no signup.
CSS Gradient Generator
Build linear, radial, and conic CSS gradients visually with color stops, presets, and one-click copy. Free, in your browser.
Box Shadow Generator
Build CSS box-shadows visually with offset, blur, spread, opacity, and inset across stacked layers. Live preview, copy-ready CSS.
Mermaid Live Editor
Render Mermaid diagrams live — flowcharts, sequence, class, state, ER, gantt, pie, and mindmap. Export SVG or PNG.
X.509 Certificate Decoder
Paste a PEM-encoded X.509 certificate — inspect subject, issuer, validity, SANs, key usage, and SHA fingerprints. Free, in your browser.
Australian Medicare Number Generator
Generate and validate Australian Medicare card numbers instantly in your browser. Uses the official check-digit algorithm — perfect for testing and development.
Australian ABN Generator & Validator
Generate and validate Australian Business Numbers (ABN) using the official weighted checksum algorithm. Perfect for testing and development — runs entirely in your browser.
Australian ACN Generator & Validator
Generate and validate Australian Company Numbers (ACN) using the official check-digit algorithm. For testing and development — runs entirely in your browser.
Australian Tax File Number (TFN) Validator
Validate Australian Tax File Numbers (TFN) — checks format and the official check-digit algorithm. No TFN generation to protect against misuse. Runs entirely in your browser.
Australian BSB Number Validator
Validate Australian Bank State Branch (BSB) numbers — checks the 6-digit format and identifies the bank from the first two digits.
New Zealand IRD Number Generator
Generate and validate New Zealand IRD (Inland Revenue Department) numbers for testing and development. Uses the official check-digit algorithm.
New Zealand Business Number (NZBN) Generator
Generate and validate New Zealand Business Numbers (NZBN) — 13-digit GS1 identifiers used by NZ companies. For testing and development.
New Zealand Bank Account Number Validator
Validate New Zealand bank account numbers — checks the BB-BBBB-AAAAAAA-SS format, bank code, and overall structure.
Text Case Converter
Convert text between camelCase, PascalCase, snake_case, kebab-case, SCREAMING_SNAKE, Title Case and more — instantly in your browser.
Number Base Converter
Convert numbers between binary, octal, decimal, and hexadecimal — type in any field and the rest update live.
XML Formatter & Validator
Format, validate, and minify XML documents with custom indentation — uses the browser's native DOMParser, nothing uploaded.
CSS & JS Minifier
Minify CSS and JavaScript online — strip comments, collapse whitespace, and see byte-size savings. Runs entirely in your browser.