What is a CSV analyzer?
A CSV analyzer, or data profiler, reads a comma-separated file and summarises every column before you use it. Analysts run one before building a report, developers before importing into a database, and anyone receiving an export who wants to know whether it's complete.
Paste or open a file to see rows, columns, missing cells and exact duplicate rows at the top, then a card per column: its type, a bar showing how full it is, distinct values and the most common ones. Number columns add minimum, median, maximum, mean, standard deviation and outliers; text columns show the shortest and longest values.
How to use the CSV analyzer
1.Paste or open a CSV
Exports from Excel, Google Sheets, databases or apps, up to 50 MB.
2.Read the column cards
Type, filled and missing counts, and stats for number columns.
3.Download the profile
Keep a one-row-per-column summary as CSV.
Example: seven online orders
An export with order_id, customer, city, amount, paid and order_date:
- Missing cells
- 2 of 42: one blank amount, one city written N/A
- amount
- min 720, median 1,175, max 15,999, mean 3,536.42
- Outliers in amount
- 1 (the 15,999 order)
- paid
- yes / no, 2 distinct values
Two gaps to fill and one order worth double-checking before the totals go into a report.
How columns are read
Each column's type is the one most of its values share: whole numbers, decimals, dates, yes/no values or text. Thousands separators, currency symbols and percent signs are understood, so ₹1,250 counts as a number. Cells that are blank or say N/A, null, none or a dash count as missing.
Outliers use the interquartile rule: a value more than one and a half times the middle spread beyond the quartiles is flagged. It's a prompt to look, not proof of an error; a single big order is often real.
Frequently asked questions
Why is a number column shown as text?
Most of its values aren't numbers, perhaps because of units like "12 kg". Clean them first with the CSV cleaner.
Does it handle semicolon or tab files?
Yes. The delimiter is detected, or pick it yourself.
How big a file can it analyse?
Up to 50 MB, roughly half a million rows, depending on your device.
Is my data uploaded?
No. It stays in this tab.
Related tools
CSV cleaner
Trim spaces, drop empty rows, rename, split and merge columns in a CSV.
CSV validator
Check a CSV for broken quotes, uneven rows and header problems.
CSV chart maker
Turn CSV columns into a bar, line, scatter, histogram or share chart.
Remove duplicate rows
Find and remove duplicate rows in a CSV, matching on all or chosen columns.
CSV sort and filter
Filter CSV rows by conditions and sort by one or two columns.
JSON Formatter & Validator
Pretty-print, minify, sort and validate JSON with line-numbered errors.
More Developer tools
JSON & data
Network & system
Web & API
Git & releases
Encoding & security
- Base64 encode & decode
- URL encode & decode
- JWT decoder
- Hash generator
- HTML entity encoder
- Text to binary
- Morse code translator
- Caesar cipher & ROT13
- Random string generator
- Secret key generator
- 2FA code generator (TOTP)
- Encrypt & decrypt text
- Encrypt & decrypt files
- SSH key generator
- Base32 encoder and decoder
- Unicode escape converter
- Nano ID generator
- JWT generator
Text & code
- Regex tester
- Text diff checker
- Cron expression explainer
- Lorem ipsum generator
- Markdown previewer
- Slug generator
- Strip HTML tags
- Unicode character inspector
- URL parser
- Markdown TOC generator
- cURL converter
- Whitespace visualizer
- Markdown link extractor
- Regex escape
- Regex match extractor
- Split text by regex
- HTML, CSS and JS playground
- Mock data generator
- Keyboard event tester
- ASCII table