Clean a file
What needs fixing in your spreadsheet?
Choose a focused tool, sign in and review the changes before keeping a new copy. Your original file stays unchanged.
Repeated records
Remove Duplicates
Review repeated rows and choose which records to keep. Conflicting values stay visible.
Open Remove DuplicatesSeveral values in one column
Split and Parse Column
Mark the pieces on actual records, then review every row that does not fit.
Open Split and Parse ColumnTwo lists that disagree
Compare Files
Find added, absent and changed records in a separate comparison report.
Open Compare FilesOne file per region or category
Split Workbook
Split XLSX or CSV by column value. Preview group counts, then download separate files or one workbook with a sheet per group.
Open Split WorkbookNeed to bring columns across?
Match & Merge connects sheets by a shared ID. Review missing and duplicate keys, then add only the fields you choose.
Open Match & MergeFixing numbers, spaces or mixed formats?
Find the native Excel method that fits your data, with checks for IDs, formulas and values that need closer attention.
Find an Excel method →