Analyze CSV
Display detailed information about a CSV file. Runs entirely in your browser, so your data never leaves your device.
0 chars · 0 lines
Output
The result appears here as you type.
How to use Analyze CSV
- 1. Paste the CSV. Drop the file into the input pane. The analyzer reads the whole thing and computes structural facts: totals for rows, columns and empty cells, plus a per-column profile.
- 2. Enable header detection. Check First row is header so the profile lists real column names and the first line is excluded from data-row counts. Skip it for raw files and columns are numbered instead.
- 3. Read the report. Copy or just read the summary: row and column counts confirm the file's shape, empty-cell totals expose gaps, and each column's inferred type (text or number) hints at parsing surprises ahead.
When to use Analyze CSV
Analyze CSV gives you a structural x-ray of a file before you commit to using it. Instead of opening a mystery export and scrolling, you get the row count, column list, inferred types and empty-cell count in one glance. It is reconnaissance for any file you did not create yourself.
- Sizing up a vendor delivery. A supplier drops a data file with no documentation. The profile tells you it has 14 columns, which are numeric, and that 3 percent of cells are empty, before you write a line of ingestion code.
- Verifying an export completed. You expect roughly 10,000 customer rows from last night's job. An analysis showing 4,212 data rows flags a truncated export immediately, without loading anything into a database.
- Catching type drift between files. Last month's file profiled the amount column as number; this month it reads as text. That one-line difference in the report usually means stray currency symbols crept into the data.
Examples
Profile a file
Input
name,age Ada,36 Grace,45
Output
Rows 3 Data rows 2 Columns 2 Empty cells 0 Column profile: 1. name text 2. age number
About the Analyze CSV tool
Analyze CSV runs as plain JavaScript in your browser tab, with no server behind it. Display detailed information about a CSV file. Whatever you put in stays on your device from start to finish.
The tool is part of EditSafely's CSV Tools section, 133 single-purpose utilities built around the same idea: open the page, get the result, keep your data to yourself.
You can shape the output with the First row is header setting, and the result refreshes the moment you change it. A worked example further down the page shows exactly what the tool produces for a real input.
That local-first design has practical benefits beyond privacy. The tool keeps working on a flaky connection once the page has loaded, results are instant because nothing round-trips to a server, and it is safe to use with confidential material.
Frequently asked questions
Does Analyze CSV cost anything?
Yes, it is completely free. All 2,658 tools on EditSafely work without an account, a subscription or usage limits.
Is it safe to paste sensitive or confidential data?
No data leaves your device. The whole tool is JavaScript that runs inside your browser tab, so there is no upload, no server-side processing and no log of what you did. If you disconnect from the internet after the page loads, it keeps working.
How much text can I process at once?
There is no fixed limit. Because the work happens on your own device rather than on a shared server, the practical ceiling is your machine's memory, which comfortably handles inputs far larger than typical online tools allow.
Do I need to sign up or install anything?
Nothing to install and no account needed. Open the page in any up-to-date browser, including on a phone or tablet, and the tool is ready.
How do I use the result?
The output panel has a one-click copy button, and you can keep refining the input while you work; the result updates in place as you type.