ZapKit

CSV analyzer

Get to know a spreadsheet export in seconds: what each column holds, how much is missing, and which numbers look suspicious.

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. 1.Paste or open a CSV

    Exports from Excel, Google Sheets, databases or apps, up to 50 MB.

  2. 2.Read the column cards

    Type, filled and missing counts, and stats for number columns.

  3. 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.

More Developer tools