#161 · Spreadsheet Cleanup Tool

Standardize Boolean Values

Standardize TRUE/FALSE values across a chosen sheet while keeping blanks and unrelated cells intact.

Office File Tool

Standardize booleans
row
rows
Ad space

How to use this office tool

  1. Choose the worksheet that contains inconsistent boolean entries.
  2. Set the header row and process the file.
  3. Review the changed-cell count and preview.
  4. Download the cleaned workbook as a new file.

What this tool does

Values such as yes/no, y/n, 1/0, on/off, and true/false are normalized to TRUE or FALSE. Other content is left alone.

recognized boolean token → TRUE or FALSE

The exported file is newly generated in your browser. The uploaded source remains unchanged.

Supported formats

XLSX, XLS, CSV, and TSV are accepted. Browser rewriting does not guarantee preservation of macros, charts, pivots, external links, or every advanced Excel feature.

FormatUse
XLSX / XLSWorkbook input; XLSX output
CSV / TSVDelimited table input

Tips for better results

  • Check whether 1 and 0 are identifiers before processing.
  • Keep a copy of the source workbook.
  • Review uncommon labels manually.

FAQ

Which boolean spellings are recognized?

The tool recognizes true, false, yes, no, y, n, on, off, 1, and 0 without regard to letter case.

Will the tool change ordinary numbers?

Only cells whose complete value matches a recognized token are changed, so numbers other than 1 and 0 remain untouched.

What spreadsheet formats can Standardize Boolean Values read?

It accepts XLSX, XLS, CSV, and TSV files. Advanced workbook objects may not be preserved when a new workbook is written.

Are uploaded files sent to a server?

No. Parsing and output generation run locally in the browser; the page does not upload cell data.

How should I protect IDs and leading zeros?

Keep identifier columns formatted as text and enable text protection when available. Always check the preview before exporting.

Processing safeguards

CheckBehavior
PrivacyLocal browser processing
PreviewLimited to 5–100 rows

Browse more office tools

Office tool hubs