Bin Column in CSV Files Online
Bucket a numeric column in CSV files into labelled ranges — equal-width bins or custom edges. Runs entirely in your browser.
About this tool
Convert a numeric column in a CSV 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 CSV 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
Hash & Anonymise Columns in CSV Files Online
Anonymise or pseudonymise columns in CSV files by replacing values with MD5, SHA-256, or DuckDB hashes — directly in your browser. Useful for GDPR compliance and sharing data without exposing PII — no upload required.
Group Concatenate CSV Files Online
Concatenate text values within each group in CSV files directly in your browser. Group rows by a column and join the values of another column into a single delimited string — no upload required.
Truncate Dates in CSV Files Online
Truncate date and timestamp columns in CSV files to a chosen precision — year, quarter, month, week, day, hour, or minute — directly in your browser. Rounds timestamps down to the start of each period. No upload required.
Coalesce Columns in CSV Files Online
Fill null values in CSV files from other columns — return the first non-null value across up to 8 columns in priority order. Add the result as a new column. Runs entirely in your browser.
Add UUID Column to CSV Files Online
Add a UUID column to CSV files directly in your browser. Generate random UUIDv4 or time-ordered UUIDv7 identifiers for every row. Choose the column name and position — no upload required.