CleanMySheet guide

Map Y, 1, true → Yes in a spreadsheet

Yes/No mapping converts y, yes, true, 1 to Yes and n, no, false, 0 to No on columns whose headers look like yes/no, opt-in, consent, or active. Other values are left unchanged.

Steps

1. Identify the column header
2. Apply Standardize yes/no
3. Review Diff