Standardize boolean flags into uniform True/False, Yes/No, or 1/0
Normalize inconsistent boolean flags across your dataset into standard True/False, Yes/No, or 1/0 formats.
🛡️ Your rows never leave your browser.
Why Onfyt: Processes standardize yes/no values entirely in-browser with dedicated Web Workers so your rows never leave your machine.
Interactive Sample Data
| user_id | full_name | email_opt_in | sms_opt_in | active_flag |
|---|---|---|---|---|
| USR-01 | Grace Mutua | Y | 1 | true |
| USR-02 | Peter Otieno | no | 0 | False |
| USR-03 | Alice Chebet | Yes | true | Y |
| USR-04 | David Mwangi | N | false | 0 |
How this tool works
When merging customer datasets, survey responses, or marketing consent logs from multiple platforms, boolean flags inevitably end up in a chaotic mixture of conventions:
- "Y" / "N"
- "Yes" / "No"
- "TRUE" / "FALSE" / "true" / "false"
- "1" / "0"
- "checked" / "unchecked"
- "on" / "off"
This inconsistency breaks data analysis:
- Relational databases (PostgreSQL, MySQL, SQL Server) require strict boolean literals (TRUE, FALSE) or bit values (1, 0).
- Spreadsheet filters create six different categories for what should be a simple binary flag.
- Privacy compliance audits (GDPR, Kenya Data Protection Act) require unambiguous consent records.
This tool recognizes all common truthy representations (Y, Yes, True, 1, On, Checked) and falsy representations (N, No, False, 0, Off, Unchecked), normalizing them into your chosen standard:
- Human-readable "Yes" / "No"
- Technical "true" / "false"
- Database binary "1" / "0"
- Single-letter "Y" / "N"
All processing executes locally in your browser sandbox via Web Workers. Your customer records and consent logs remain completely confidential on your device.
From a database normalization perspective, boolean flags entered in inconsistent formats ("Y/N", "true/false", "1/0", "Yes/No", "checked") prevent accurate filtering and break relational boolean constraints. DataFix recognizes all common truthy and falsy representations, standardizing them into your chosen format: human-readable Yes/No, technical true/false, or binary 1/0.
From a regulatory compliance standpoint, consent records (GDPR, marketing opt-ins) represent legally sensitive audit data. Transmitting subscriber consent matrices to public online converters introduces severe compliance liabilities. DataFix normalizes all boolean flags locally within your browser sandbox via Web Workers, ensuring complete privacy, zero latency, and total data protection.
In marketing consent tracking, regulatory compliance audits, and boolean database modeling, unambiguous boolean indicators are essential. Under data protection regulations (GDPR, CCPA, Kenya DPA), privacy auditors require unambiguous records of whether a user consented to communications. Standardizing chaotic inputs ("Y", "1", "true", "checked") into uniform "Yes" and "No" values ensures clear audit trails, reliable database booleans, and foolproof compliance documentation.
Additionally, our engine allows users to map ambiguous cell values (such as "N/A", "Unknown", or blank entries) to explicit fallback states, ensuring total consistency across privacy compliance audits and database boolean columns.
Things that usually go wrong
- Ambiguous Values (Maybe, N/A): Values that are neither truthy nor falsy are flagged or left as empty nulls rather than guessed.
- Case Sensitivity Differences: "yes", "YES", and "Yes" must all be recognized. DataFix performs case-insensitive matching.
- Treating Blank Cells as False: Empty cells might mean "unknown" rather than "no". You can choose whether blank cells become False or remain empty.
Edge cases we tested
🧪 Empty cells or missing values
Safely handled without schema corruption.
🧪 Leading or trailing cell whitespace
Sanitized prior to processing.
🧪 Large files with 25,000+ rows
Streamed via client-side Web Worker without tab freezing.
Frequently Asked Questions
Which values are recognized as "True"?
Y, Yes, True, 1, On, Checked, and T (case-insensitive) are mapped to True.
Which values are recognized as "False"?
N, No, False, 0, Off, Unchecked, and F (case-insensitive) are mapped to False.
Can I output binary 1 and 0 for SQL databases?
Yes! Select the "Binary 1 / 0" chip to format flags for SQL bit/tinyint columns.
Is my data private?
Completely. All data processing occurs locally within your browser sandbox via Web Workers.
Related tools
Clean
Change Text Case
Transform column text into UPPERCASE, lowercase, Title Case, Sentence case, or camelCase across your spreadsheet.
Open Tool →
Clean
Trim Whitespace
Clean up accidental leading, trailing, and duplicate spaces across all columns in your spreadsheet.
Open Tool →
Clean
Remove Duplicate Rows
Eliminate duplicate rows across your entire dataset or based on specific unique key columns.
Open Tool →