Blog
Practical guides for messy data.
Short, specific walkthroughs for the spreadsheet cleanup problems that eat your afternoon. Every guide shows the manual method and the fast one.
- 3 min read
How to Remove Duplicate Rows in Excel and CSV Files
Four ways to remove duplicate rows — Excel's built-in tool, Google Sheets formulas, Python, and a browser tool — plus why duplicates often survive the first attempt.
Read the guide → - 3 min read
How to Fix Mixed Date Formats in a CSV
When one column contains 03/14/2024, 14 Mar 2024, and 2024-03-14 at once — how to detect the mess, resolve the 01/02 ambiguity, and convert everything to one format.
Read the guide → - 4 min read
How to Split a Full Name Column into First and Last Name
Excel formulas, Flash Fill, Google Sheets, and Python for splitting name columns — plus the middle names, suffixes, and compound surnames that break naive approaches.
Read the guide →
Skip the reading — just clean the file.
CSVTidy runs entirely in your browser. Drop a CSV or Excel file and fix it in a few clicks.
Clean a file — free →