Deduplicating CSV data — strategies and pitfalls
A 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-dedupeBlog
Guides, tutorials, and tips for working with CSV, JSON, and spreadsheet data.
How to convert CSV to JSON without uploading your 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-jsonGenerating TypeScript types from JSON — a practical guide
How to infer TypeScript interfaces from JSON data, when structural inference works well, and where it breaks down.
/json-to-tsJSON Schema validation — when and how to use it
A 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-validatorCSV to Excel without Microsoft — free alternatives
A 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-excelWorking with large CSV files in the browser
How streaming parsers, web workers, and virtualized rendering make it possible to open million-row CSVs without freezing your tab — or uploading anything.
/csv-viewerWelcome to MakeMyStats
An introduction to MakeMyStats — a suite of free, browser-based CSV, JSON, and spreadsheet tools that never upload your files.
/csv-viewer