#185 · Spreadsheet Cleanup Tool

Clean Percentage Values in Excel

Normalize percentage entries such as 25%, 0.25, and spaced text into consistent numeric percentage cells.

Office File Tool

Local browser processing
row
rows
Ad space

How to use this office tool

  1. Upload the workbook and select a sheet.
  2. Set the header row so percentage columns can be identified.
  3. Run the cleaner and review the preview.
  4. Download the new workbook; the original remains unchanged.

What this tool does

Recognizes conservative percentage patterns, converts them to decimal numeric values, and writes a new workbook with 0.00% formatting.

Recognizes conservative percentage patterns, converts them to decimal numeric values, and writes a new workbook with 0.00% formatting.

Plain numbers greater than 1 are divided by 100 only when percentage interpretation is clear from a percent sign or column header.

Supported formats

Reads XLSX, XLS, CSV, and TSV in the browser. The exact output format is shown in the tool controls.

FormatSupport
XLSX / XLSCell data; advanced objects may not be preserved
CSV / TSVUTF-8 delimited data; one table per file

Tips for better results

  • Label percentage columns with words such as percent, rate, or margin.
  • Review ambiguous values such as 1, which may mean 1% or 100%.
  • Keep identifiers and phone numbers out of percentage columns.

FAQ

How does the tool convert text such as 25%?

It removes surrounding spaces and the percent sign, parses 25 as a number, and stores 0.25 with percentage formatting.

Will 0.25 become 25 percent?

Inside a clearly labeled percentage column, decimal values from zero to one are retained and formatted as percentages.

Does it change every number in the workbook?

No. It targets cells with percent signs or cells under headers that indicate a percentage field.

What happens to invalid percentage text?

Unrecognized text is left unchanged rather than being guessed.

Are formulas recalculated after cleaning?

Formula cells are preserved where possible, but this browser tool does not promise Excel-identical recalculation.

Processing notes

AreaBehavior
PrivacyLocal browser processing
SourceNever overwritten
PreviewLimited to selected rows

Browse more office tools

Office tool hubs