ZapPad for Mac · Focused help guide

Clean CSV and JSON

ZapPad’s structured-data tools help inspect and transform supported CSV, TSV and JSON input while keeping text values under your review. Preview the output before applying it, especially when identifiers or decimal formatting matter.

See the complete ZapPad manual for all menus, settings and troubleshooting. These focused guides are drawn from the same current manual.

Applies to the current Direct release documentation for Apple Silicon Macs on macOS 12 or later.

How to use this feature

Tables submenu

ItemWhat it does
Extract CSV Columns…Keeps the columns you list as a JSON array of zero-based indexes, e.g. [0,2]. Columns can be reordered or repeated. Rows missing a column are rejected.
Filter CSV Rows…Keeps rows where a zero-based column equals or contains a literal value (case-sensitive). A header row is treated as data.
Group CSV Rows…Groups rows by a zero-based column into a JSON object.
JSON5 Subset to JSON…Converts a supported subset of JSON5 to strict JSON.
Python Literal Subset to JSON…Converts supported Python literals (dicts, lists, strings, numbers) to JSON.
CSV to TSV… · TSV to CSV…Converts delimiters, quoting as needed.
CSV to JSON Rows…Converts rows to a JSON array of string arrays.
JSON String Rows to CSV…Converts a JSON array of string rows to CSV.

All values are kept as strings, so IDs with leading zeros survive. Actions › Data › Table Tools… offers the conversions that fit the current text.

Pasted data detection

When you paste up to 256 KiB of JSON, CSV or TSV, ZapPad checks it in the background without changing it. A button such as JSON Detected - Tools… appears above the editor, offering Preview JSON Cleanup…, Preview CSV to JSON… or Preview TSV to CSV…. For JSON, the status line also says whether the syntax is valid or string-wrapped. Turn off View›Detect Pasted Code to stop automatic language detection on paste.

JSON tools

  • Check JSON Syntax… validates without changing text.
  • Clean Up Escaped JSON… turns "{\"name\":\"Ada\"}" into an indented object. It unwraps up to eight complete string layers, but won’t guess missing commas, fix trailing commas or decode string fields inside the object.
  • Format JSON… changes whitespace only.
  • Numbers (including large IDs and trailing zeros), key order and duplicate keys are preserved. Editable JSON is limited to 16 MiB.

Frequently asked questions

Does ZapPad preserve leading zeros in CSV identifiers?

ZapPad’s CSV tools treat fields as text unless a selected operation changes them, so values such as account numbers can retain leading zeros. Review the proposed table conversion and output before applying it; spreadsheet applications may interpret the same values differently.

Can I format JSON without losing large IDs?

ZapPad’s JSON formatter parses and reserializes valid JSON. Numeric values are handled as JSON numbers by the formatter, so preserve identifiers that must remain exact as quoted strings. Inspect the preview and verify values before applying changes.

Does ZapPad automatically change pasted CSV or JSON?

No. Pasted-data detection offers a relevant structured-data tool when input appears to be CSV, TSV or JSON. You choose the action, inspect the preview and decide whether to apply it. Detection alone does not change the pad.

For complete current feature details, open the ZapPad manual.