Data repair guides
DataDoctor Guides
Practical tutorials for real data repair tasks: invalid JSON, CSV import failures, duplicate records, schema validation, platform CSV requirements and local-first privacy.
Guide categories
How to use these guides
- Start with the guide that matches the file failure, then open the matching tool from the guide footer.
- Use JSON guides for parser, repair and schema issues before sending payloads to APIs.
- Use CSV and import guides before editing rows manually or uploading to a platform.
- Use privacy guidance before pasting sensitive customer, product or transaction data into any tool.
All guides
Step-by-step repair and import checklists
JSON repair and API payloads
How to Fix Invalid JSON
A practical checklist for finding and repairing invalid JSON before sending it to an API or importing it into a system.
Read guideCSV cleanup and quality
Why CSV Import Fails
The most common CSV import failures and how to fix them before uploading the file.
Read guideCSV cleanup and quality
How to Remove Duplicate Emails from CSV
Find duplicate email rows, export duplicates and download a clean CSV file.
Read guideSchema validation
JSON Schema Validation Explained
A simple explanation of JSON Schema validation for APIs, imports and data pipelines.
Read guidePlatform import readiness
Shopify Product CSV Pre-Import Checklist
A checklist for validating Shopify product CSV files before import.
Read guidePlatform import readiness
HubSpot Contact CSV Import Checklist
A practical checklist for checking HubSpot contact CSV files before import.
Read guidePlatform import readiness
QuickBooks Transaction CSV Import Checklist
Check Date, Description and Amount columns before importing bank transaction CSV files into QuickBooks.
Read guidePlatform import readiness
WooCommerce Product CSV Import Checklist
Validate WooCommerce product CSV fields, SKUs, prices and image URLs before import.
Read guideLocal-first privacy
Why Local-First Data Tools Matter
Why private browser-side validation is safer for JSON, CSV and import files.
Read guide