Notes on clean data
Practical guides for anyone who has opened an export and wondered why nothing matches.
How to Remove Duplicate Rows from a CSV File
Learn how to remove duplicate rows from a CSV file: exact vs near duplicates, choosing key columns, keeping the first copy and checking before you delete.
Read the articleFind and Fix Hidden Whitespace in CSV Files
Hidden whitespace in CSV files breaks lookups, joins and deduplication. Learn to spot trailing, non-breaking and zero-width spaces, then fix them safely.
How to Open a CSV in Excel Without Breaking Your Data
Opening a CSV in Excel can strip leading zeros, turn long IDs into scientific notation and text into dates. Learn how to open CSV files safely in Excel.
Missing Values in CSV: Blank, Null, N/A and What to Do
Missing values in CSV files hide behind blanks, N/A, null and dashes. Learn why tools disagree, how to count them per column and when to fill or drop them.
CSV Injection Explained: What It Is and How to Prevent It
CSV injection turns exported cells into live spreadsheet formulas. Learn why =, +, - and @ matter, how exporters neutralize them and how to stay safe.