Data & CSV

CSV category frequency table

Count exact categories and compare their shares of a selected column.

Your inputs

Your CSV data

UTF-8 CSV/TSV stays on this device. First row contains unique headings; maximum 25 MB, 50,000 rows and 200 columns. Fully empty rows are ignored.

Up to 25 MB per file, 50,000 data rows, 200 columns and 2 million data cells. Fully blank rows and columns are ignored before row, column and cell limits are checked. Individual tools may have smaller result or chart limits.

Or choose a CSV file

Column separator

Category column

Empty / whitespace-only cells

Sort categories

Results update as you type. Larger files run when you press Update result.

Processed on your device

Your result

LOCAL & PRIVATE

Your result will appear here.

Your inputs stay in this browser. Nothing is uploaded or saved.

A clear answer. Here’s how.

Counts exact cell strings in one column, with optional exclusion of whitespace-only values. Shares use the included row count as denominator. Distinct whitespace strings remain separate categories when included. Count ties retain first-seen order; percentages are descriptive and no population inference is made.

See a worked example

Worked example

A fixed demonstration, separate from the values you enter above.

Your CSV data

ID,Name,Department,Amount,Date
001,Ada,Design,120,2026-01-05
002,Sam,Writing,80,2026-01-06
003,Jo,Design,150,2026-01-07
004,Lee,Writing,,2026-01-08
005,Alex,Design,60,2026-01-09

Column separator

Comma

Category column

Department

Empty / whitespace-only cells

Exclude

Sort categories

Largest count first

Example result

Example result
Category	Count	Share (%)
Design	3	60
Writing	2	40

5 rows included; 0 blank/whitespace rows excluded.