What is dot-notation unflattening?

Dot-notation unflattening transforms flat spreadsheet headers like `user.profile.age` into nested JSON structures like `{"user": {"profile": {"age": 30}}}`.

Can I convert heterogeneous JSON arrays with mismatched keys?

Yes! The flattener traverses all objects in the array, computes the union of all unique keys, and aligns missing properties with empty cells automatically.

How does the auto-delimiter sniffer work?

The sniffer analyzes character distribution across the first 10 rows outside of quoted strings to score and select the true delimiter (comma, semicolon, tab, or pipe).

Is it safe to process confidential customer or financial CSV files?

Yes, 100%. All processing runs locally within your browser sandbox. No data ever leaves your computer.

What is dot-notation unflattening?

Dot-notation unflattening transforms flat spreadsheet headers like `user.profile.age` into nested JSON structures like `{"user": {"profile": {"age": 30}}}`.

Can I convert heterogeneous JSON arrays with mismatched keys?

Yes! The flattener traverses all objects in the array, computes the union of all unique keys, and aligns missing properties with empty cells automatically.

How does the auto-delimiter sniffer work?

The sniffer analyzes character distribution across the first 10 rows outside of quoted strings to score and select the true delimiter (comma, semicolon, tab, or pipe).

Is it safe to process confidential customer or financial CSV files?

Yes, 100%. All processing runs locally within your browser sandbox. No data ever leaves your computer.

All developer tools

developer Utility Updated: Current (RFC 4180 & Multi-Target Synthesizer Engine)

CSV ↔ JSON & Table Data Studio

Convert bidirectionally between CSV, TSV, JSON, YAML, Markdown Tables, and SQL INSERT queries with auto-delimiter sniffing, dot-notation unflattening, and an interactive virtual data grid.

#Developers#CSV#JSON#Database#SQL#DataEngineering

Delimiter:

Rows: 4Columns: 8Active Delimiter: ","

100% In-Browser Memory (Zero Server Transmissions)

Raw CSV / TSV Source

5 lines • 400 charsDrag & drop file upload

Showing 4 of 4 rows

#	order_id string	customer.name string	customer.email string	shipping.city string	shipping.country string	total_usd number	is_paid boolean	items_count number
1	ORD-9901	Sarah Jenkins	sarah.j@example.com	San Francisco	USA	249.99	true	3
2	ORD-9902	Marcus Chen	mchen@enterprise.io	Singapore	Singapore	1200.5	true	12
3	ORD-9903	Elena Rostova	elena.r@berlin.de	Berlin	Germany	89	false	1
4	ORD-9904	Liam O'Connor	liam.oc@dublin.ie	Dublin	Ireland	450.25	true	4

100% Client-Side In-Browser Data Processing Guarantee

100% In-Browser Local

All CSV parsing, JSON object transformations, dot-notation expansion, and multi-format syntheses execute entirely in your local browser memory. Zero rows, sensitive database dumps, customer records, or financial spreadsheets are ever uploaded or transmitted across the network.

Technical & Statutory Standard: Strictly compliant with RFC 4180 specification for escaped quotes, irregular line endings, and delimiter detection.

Comprehensive Technical Guide & Reference

4 Topics

Convert, inspect, and edit tabular datasets between CSV, TSV, JSON, YAML, Markdown, and SQL. Use the interactive data grid to search, sort, and edit cells inline with zero latency.

11. RFC 4180 Quoting & Escaping Rules

RFC 4180 mandates that any field containing commas, line breaks, or double quotes must be wrapped in double quotes. Embedded double quotes must be escaped with a preceding double quote (`""`).

Formula / Standard Reference

Escaped Field: "Hello, ""World""!"

•Comma inside text: "San Francisco, CA" is parsed as a single string cell.
•Quotes inside text: "Say ""Hi""" is parsed as: Say "Hi".
•Multiline cells: Quoted cells with line breaks are preserved across rows.

22. Dot-Notation & Array Unflattening

Dot-notation column headers are automatically unpacked into deep nested JSON objects and arrays during conversion.

Formula / Standard Reference

Header: user.address.city → Output: { user: { address: { city: '...' } } }

•Nested Objects: `customer.name`, `customer.email` → `{ customer: { name, email } }`.
•Array Indices: `tags[0]`, `tags[1]` → `{ tags: ['first', 'second'] }`.

33. Multiple JSON Output Formats

Switch seamlessly between standard Array of Objects (`[ { id, name } ]`), Columnar Object of Arrays (`{ id: [...], name: [...] }`), and Key-Value Maps keyed by primary identifier.

44. SQL INSERT & Markdown Table Generation

Generate production-grade parameterized SQL `INSERT INTO table_name (...) VALUES (...)` statements and clean GitHub-flavored Markdown tables for documentation.

Frequently Asked Questions

Our tokenizer strictly complies with RFC 4180 by tracking quote state machine boundaries. Any comma enclosed within quotation marks is treated as cell text rather than a delimiter.

Related & Recommended Tools

developer

JSON to Multi-Language Schema Studio

Convert JSON payloads into strongly-typed models for Python Pydantic V2/V1, Dataclasses, TypedDict, TypeScript, Rust Serde, Go Structs, and SQL DDL.

Launch Tool

developer

Text & Code Diff Studio

Compare text and source code side-by-side or unified with intra-line word/character highlights, change navigation, patch generation, and zero server uploads.

Launch Tool

developer

Universal Base64, URL & Hex Converter Studio

Encode and decode Base64 strings, Image data URIs, URL query components, Hexadecimal memory dumps, Binary bits, and HTML entities with 100% in-browser privacy.

Launch Tool