Choose text cleaning or blank-row removal below. Each mode processes your original file locally in the browser.
For example, select the Order ID column and enable Trim edge spaces. The fictional text value below changes only at its edges; the leading zeros remain. Review the changes before downloading. Numbers, dates, and formulas are not cleaned as text. The new workbook contains the current sheet using saved values, without the source fonts, colors, or layout.
| Before | After | Rule |
|---|---|---|
| " 00123 " | "00123" | Trim edge spaces |
This mode reads the original XLSX independently. It removes rows with no saved values or text. It keeps spaces, empty strings, hidden characters, 0, and false. Supported plain XLSX value workbooks retain other content, all worksheets, and static formatting; complex structures are blocked with an explanation. It does not provide this format-preserving operation for XLS files.
| Stored value in a row | Result |
|---|---|
| No saved values or text | Remove the row |
| A space, 0, or false | Keep the row |
Clean text: clean plain text in selected columns. Numbers, dates and formulas are not cleaned; saved formula values are exported. The download contains the current sheet, without fonts, colors or layout. Remove blank rows: remove only rows with no saved values or text, retaining other content, static formatting and all worksheets. Spaces, empty strings, hidden characters, 0 and false are kept; complex structures prevent downloading, with a reason shown. Each mode reads your original file independently. The source file stays unchanged.
Clean text supports XLSX and standard XLS: 10 MiB, 10,000 rows, A–AX (50 columns), and 8,000,000 UTF-16 text units. Removing blank rows supports XLSX only: 10 MiB, up to 10,000 data rows, with content within A–AX (50 columns).
Files and results stay in this browser session and are never uploaded. Refreshing or leaving clears the session.
Privacy details