Add Conditional Column to Excel Files Online
Add a new column to Excel files based on an if/else condition directly in your browser. Set a value for rows that match and a different value for rows that don't — no upload required.
About this tool
Add a new column to a Excel file whose value is determined by conditions you define — like an Excel IF statement or SQL CASE WHEN. Set as many rules as you need, choose a value for each matching condition and a fallback for everything else, then download the updated file. All processing runs locally in your browser.
Frequently Asked Questions
What is a conditional column in a Excel file?
A conditional column adds a new column whose value is determined by rules you define — equivalent to SQL CASE WHEN. For example: if score > 90 then "A", if score > 80 then "B", else "C". Each row gets the label from the first condition it satisfies.
Can I add multiple conditions when creating a conditional column in a Excel file?
Yes. Add as many WHEN conditions as you need. Conditions are evaluated top to bottom and the first match wins. The final ELSE clause sets the value for any row that matches none of the conditions.
What data types can I use in conditional column expressions for Excel files?
Text, numeric, and date comparisons are all supported. Operators include equals, not equals, greater than, less than, contains, starts with, ends with, is null, and is not null.
Is my data private?
Yes — completely. Your file is never uploaded to any server. Everything runs locally in your browser using WebAssembly — processing happens entirely inside your tab. Once you close the tab, nothing is retained.
What is the maximum file size?
The free limit is 50 MB. For larger files, performance depends on your device's available memory — most modern machines handle 500 MB to 1 GB comfortably.
Related Tools
Shuffle Excel Files Online
Randomly shuffle the row order of Excel files directly in your browser. Useful for randomising data before sampling or ML train/test splits.
Bin Column in Excel Files Online
Bucket a numeric column in Excel files into labelled ranges — equal-width bins or custom edges. Runs entirely in your browser.
Add Calculated Column to Excel Files Online
Add a new column to Excel files computed from an arithmetic expression over existing columns. No formulas, no code — just point and click.
Extract JSON Column from Excel Files Online
Extract values from a JSON-encoded column in Excel files into a new flat column using a JSON path expression. Runs in your browser.
Calculate Date Difference in Excel Files Online
Calculate the difference between two date or timestamp columns in Excel files directly in your browser. Output in days, months, years, hours, minutes, or seconds — no upload required.