Data conversion guides

Inspect nested JSON records and sort their exact IDs

·

Use a typed table to review API or log records before sharing a subset. Check the projected column names and numeric order, then choose JSON when original types and nesting matter.

JSON to Table

Sort two large IDs that differ by one

Load the example and render it with Expand nested object fields checked. Search for Oslo. Two records match through the profile.city column. Click eventId once to sort ascending. Expect West at 9007199254740992, followed by North at 9007199254740993.

Download JSON rows and check the same order and exact digits. The profile object is still nested. Download CSV to see the projected profile.city column. Import the eventId field as text in a spreadsheet if you need all the digits.

RFC 8259 on JSON objects, values and interoperabilityRFC 4180 on common CSV quoting rules

Distinguish a nested path from a key that contains a dot

Clear the search and inspect East. The profile.city column contains Kyoto, while the column labeled ["profile.city"] contains literal key. A real key containing a dot gets bracket notation so the two columns remain separate.

West has an explicit null in note, East lacks the note key, and South has an empty string. The table labels their types. In CSV an empty string and a missing field both become blank cells, while JSON preserves the three cases.

RFC 8259 on JSON objects, values and interoperability

Open a record array within an API envelope

Paste {"data":{"items":[{"id":12},{"id":7}]}} and enter /data/items in Record pointer. Rendering produces two rows with one id column. A slash inside a key is written as ~1 in the pointer. A tilde is written as ~0.

Choose NDJSON records when each nonblank line is a separate JSON object. The tool reports the source line if a record is malformed. Duplicate keys are rejected so a later value cannot silently replace an earlier one.

RFC 6901 on JSON Pointer paths and escapingRFC 8259 on JSON objects, values and interoperability

Common questions

How do I export the selected subset when there are several pages?

Apply the search, type and sort controls and download either format. The export gathers all matching rows across every page.

How are formulas handled when I save CSV?

The default CSV setting prefixes formula-like text with an apostrophe. For an exact copy of the original JSON values and types, export JSON.

Sources

Put it into practice.

Related guides