Guides
Clear explanations of the problems that make CSV and spreadsheet data messy, and how to fix them in any tool.
How to Remove Duplicates from a CSV File (4 Ways)
Remove duplicate rows from a CSV file in your browser, Excel, Google Sheets or Python, and avoid the pitfalls that leave duplicates behind.
3 min readRead guideWhy Excel Changes Your CSV Data (and How to Stop It)
Excel drops leading zeros, turns long numbers into 1.23E+15 and converts text to dates when it opens a CSV. Here is why it happens and how to prevent it.
3 min readRead guideGarbled Characters in CSV Files (é, ’): Causes and Fixes
Why CSV files show é instead of é or ’ instead of an apostrophe, how to repair the text, and how to save files so it never happens again.
2 min readRead guideHow to Clean an Email List Before Importing It: A Checklist
A practical checklist for cleaning an email list in CSV or Excel before importing it into Mailchimp, HubSpot or a CRM: duplicates, invalid addresses, typos and consent.
2 min readRead guideCSV Injection Explained: Why Exported Cells Get an Apostrophe
What CSV (formula) injection is, why values starting with =, +, - or @ are risky in spreadsheets, and how exports protect against it without breaking real data.
2 min readRead guide