CSV & JSON tools for checking data
11 toolsInspect an export before importing it, clean headers and cells, or match records by a stable key. JSON helpers support syntax checks, formatting and conversion. Review data types, spreadsheet interpretation and each tool’s limits.
Compare two CSV exportsMatch unique identifiers across exports and review added, removed and changed records with per-field differences.Validate & format JSONCheck JSON syntax and create readable or compact output without rounding numeric identifiers.Clean a CSV for importReview a CSV, tidy its cells and headers, and remove exact duplicate rows without converting identifiers.
Supporting tools & optional helpers (8)
Choose a helper for a specific step, then review its supported formats, limits and output before using the result.
CSV file previewExperimental helperPreview the header and first records of a CSV using quoted-field parsing.CSV column selectorExperimental helperKeep selected CSV columns and arrange them in the order you specify.CSV row filterExperimental helperKeep CSV rows whose chosen column contains a search string.Merge compatible CSV filesExperimental helperAppend the records of a second CSV to a first file with the same headers.Split CSV into filesExperimental helperSplit a CSV into smaller files by row count and download them together in a ZIP.CSV to JSONExperimental helperTurn CSV records into a JSON array using the first row as property names.JSON diffExperimental helperCompare two JSON objects and show changed values grouped by top-level key.JSON to CSVConvert a JSON array of objects into a CSV with columns from their combined keys.
Practical guides
- Compare Two CSV Exports Using a Unique Key
Match CSV records by a stable identifier and distinguish added, removed and changed rows from simple row-order differences.
- Clean a CSV While Preserving Leading-zero Identifiers
Trim cells and headers, remove exact duplicate rows and inspect identifiers before importing a cleaned CSV into a spreadsheet.