IF/ELSE Logic

Apply IF/THEN/ELSE conditional logic to CSV columns to categorize, flag, or transform values without writing code.

Free for files up to 5 MB and 10,000 rows. Files are processed in your browser — nothing is uploaded to a server. No account required.

About IF/ELSE Logic

IF, THEN and ELSE for a column, with no formula language to learn. Test whether a value is greater than, less than, equal to, or contains something, or whether the cell is empty, then write one value when the test passes and another when it fails.

Sales pipeline exports get banded this way: if amount is greater than 50000 write "enterprise", otherwise write "smb". Invoice files get flagged the same way on days_overdue. The answer can go into a new column, or replace the value in the column you tested.

Fill in the IF column, condition and value, add the THEN and ELSE values, then apply. The full result is visible before you download it.

Related tools