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.
About this tool
Convert a numeric column in a Excel file into labelled categorical ranges. Choose equal-width bins (specify how many) or define your own breakpoints. The tool adds a new column with the bin label for each row — ready for grouping, filtering, or charting. Everything runs locally in your browser.
Frequently Asked Questions
What is the difference between equal-width and custom bins?
Equal-width bins divide the full range of values into N intervals of identical size — for example, 0–20, 20–40, 40–60. Custom bins let you specify exact breakpoints that match your domain — for example, age groups 0–18, 18–35, 35–65, 65+.
What happens to null values in the column I am binning?
Null values are not matched by any CASE WHEN condition and result in a null in the bin column. You can fill nulls before binning using the Fill Empty Values tool if you need every row to have a bin label.
Can I bin a Excel file column with negative numbers?
Yes. Equal-width bins handle negative numbers correctly — the range spans from the minimum to the maximum value in the column regardless of sign. For custom edges, include negative values in your comma-separated edge list.
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
Validate Email Addresses in Excel Files Online
Validate email addresses in Excel files directly in your browser. Add a boolean column flagging valid and invalid emails, or filter to show only invalid rows — no upload required.
Add Moving Average to Excel Files Online
Add a moving average, rolling sum, rolling min, or rolling max column to Excel files directly in your browser. Choose window size, order-by column, and optional partitioning — no upload required.
Search Text in Excel Files Online
Search for text across all string columns in Excel files directly in your browser. Filter rows to only those containing your search term and download the results — no upload required.
Get Top N Rows from Excel Files Online
Extract the top N rows per group from Excel files directly in your browser. Get the top 5 products per category, highest scores per team, or any ranked subset — no upload required.
Add Percent of Total to Excel Files Online
Add a percentage-of-total column to Excel files directly in your browser. Show each row's share of the grand total, or the share within each group — no upload required.