How to normalise status column values across a csv
- Step 1Audit the status column values — Check which variants appear in the column and what the target canonical value should be.
- Step 2Drop the CSV into Find & Replace — Select the status column.
- Step 3Add pairs for each variant — Find 'Y', replace with 'active'; find 'Yes', replace with 'active'; find 'TRUE', replace with 'active'.
- Step 4Download the normalised CSV — Import into your database or BI tool.
Frequently asked questions
Can I normalise multiple status columns in one run?+
Yes. Select all relevant status columns and the replacements apply to all selected columns.
What if the same value appears in a non-status column?+
Limit the replacement to the specific status column by selecting only that column.
Does this work for binary 0/1 to false/true conversion?+
Yes. Find '0', replace with 'false'; find '1', replace with 'true'. Make sure the column is selected narrowly to avoid replacing ID numbers.
Privacy first
Processing runs locally in your browser with PapaParse. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.