Guides, tutorials, and tips for working with CSV, JSON, and spreadsheet data.
Why server-side CSV-to-JSON converters are a privacy and performance problem, how browser-native conversion works under the hood, and a walkthrough of MakeMyStats's client-side converter.
/csv-to-jsonA practical guide to finding and removing duplicate rows in CSV files: exact match vs fuzzy, column selection, keep modes, and the gotchas that trip people up.
/csv-dedupeHow to infer TypeScript interfaces from JSON data, when structural inference works well, and where it breaks down.
/json-to-tsAn introduction to MakeMyStats — a suite of free, browser-based CSV, JSON, and spreadsheet tools that never upload your files.
/csv-viewerA comparison of free ways to convert CSV files to XLSX format, from desktop apps to browser-based tools, with trade-offs for each approach.
/csv-to-excelA practical guide to JSON Schema: what it solves, how to write schemas for real data, common pitfalls, and a worked example you can try in your browser.
/json-schema-validatorHow streaming parsers, web workers, and virtualized rendering make it possible to open million-row CSVs without freezing your tab — or uploading anything.
/csv-viewer