How to clean spreadsheets
Pick the cleaner that matches the file. CSV & TSV Cleaner repairs delimited-file structure, removes eligible empty rows or columns, and lets you review the result. Excel Cleaner works with selected workbook sheets, trims text whitespace, removes listed import noise, and previews each sheet.
Choose a cleaner by file type
Use CSV & TSV Cleaner for delimited text files. Its parsing and output settings affect how rows and fields are read and written. Use Excel Cleaner for workbooks when you need to select sheets and inspect cleaned output per sheet.
- CSV & TSV Cleaner repairs CSV and TSV structure, removes empty rows or columns, and can clean field text before you export the result.
- Excel Cleaner cleans selected Excel sheets by trimming text whitespace, repairing listed import noise, and removing eligible blank or separator rows and columns.
What CSV & TSV Cleaner changes
Use CSV & TSV Cleaner when a delimited file needs structural repair before another tool or spreadsheet program reads it. Choose parsing and output settings for how the file is interpreted and written. You can also remove empty rows or columns and clean text inside fields before reviewing and exporting the result.
Input: [empty row]
Output: [row removed]The text-cleaning option changes field text before review and export. Empty rows or columns are removed only when they qualify for removal.
What Excel Cleaner changes
Use Excel Cleaner when the source is an Excel workbook and only some sheets need cleanup. Select the sheets, trim text whitespace, repair the listed import noise, and remove eligible blank or separator rows and columns. The output is previewed per sheet, so you can inspect each cleaned sheet before using it.
Input: [separator row]
Output: [separator row removed]Excel Cleaner applies the cleanup choices named in its interface. Choose a conversion page in Spreadsheet Tools when the file format itself needs to change.
Examples of spreadsheet cleanup
If a CSV has empty rows between data blocks, CSV & TSV Cleaner can remove eligible empty rows before you review and export the result.
If a tab-separated file needs different parsing or output settings, adjust those settings in CSV & TSV Cleaner before reviewing the repaired file.
If an Excel workbook has several sheets and only some need cleanup, select those sheets in Excel Cleaner, then inspect the output for each selected sheet.
If an imported workbook contains the listed import noise, Excel Cleaner can repair it while it cleans the selected sheets.
Frequently asked questions
How do I clean a spreadsheet?
Choose the cleaner that matches the file type. Use CSV & TSV Cleaner for delimited files. Use Excel Cleaner for selected sheets in an Excel workbook.
Can I remove empty rows and columns from a CSV?
Yes. CSV & TSV Cleaner removes empty rows or columns that qualify for removal, then lets you review and export the result.
How do I clean whitespace in an Excel file?
Use Excel Cleaner, select the sheets to clean, and trim text whitespace. The cleaned output is previewed per sheet.
What is the difference between CSV & TSV Cleaner and Excel Cleaner?
CSV & TSV Cleaner handles delimited-file parsing, structure, and output settings. Excel Cleaner handles selected workbook sheets, text whitespace, listed import noise, and eligible blank or separator rows and columns.