Analyze Data from PDF, Excel or Google Sheets
Drop in a PDF table, an Excel file, a CSV or a Google Sheets link and get a summary of every column, the key numbers and the charts that fit the data.
Paste cells or a Google Sheets link
How it works
Add your data
A table in a PDF, an Excel workbook, a CSV, a Google Sheets link, or cells pasted from a spreadsheet.
Read the summary
Rows, columns, gaps and duplicates; totals, averages, medians and ranges for every number; the most common values for every text column.
Take the charts
The charts that fit the data are drawn for you. Download any of them, or the summary as CSV or Excel.
Analyze data and chart it in one step
This data analyzer reads a table from a PDF, an Excel file, a CSV or a Google Sheet and tells you what is in it: every column's type, gaps and duplicates, totals, averages, medians and ranges, and the highest and lowest categories.
To analyze excel data or analyze pdf data, drop the file in. The charts that fit the data are drawn for you and can be downloaded, with the summary as a spreadsheet.
People also search for
- csv to chart
- pdf to excel
- csv compare
Why it matters
Private by design
Bank statements, payroll and customer lists never leave your computer: the file is read and written in your browser.
Nothing silently changed
Leading zeros, long ID numbers, commas inside quotes and line breaks inside cells come through exactly as they were.
Numbers stay numbers
Values like 1,234.50, $1,200 and 7% are recognised, so Excel and JSON get real numbers rather than text.
Questions
What does the analysis include?
For every column: its type, how many cells are filled, how many values are unique, and for numbers the sum, average, median, minimum, maximum and spread. It also flags missing values and duplicate rows, names the highest and lowest category, and the change from first to last over time.
Can it analyze a PDF?
Yes, when the PDF has tables in text (most exported reports and statements do). The tables are read out of the PDF first, then analysed.
Can it analyze a Google Sheet?
Paste the link of a sheet shared as "Anyone with the link", or copy the cells and paste them.
Is my data uploaded?
No. The whole conversion runs in your browser, so the file never leaves your computer.
Can it open a password-protected PDF or Excel file?
Yes. Drop it in and you are asked for the password; the file is unlocked in your browser and the password is never sent or saved. PDFs locked with RC4 or AES (up to AES-256, PDF 2.0) and Excel workbooks saved with Encrypt with Password both open. A PDF that only restricts copying or printing opens without asking. Without the password nothing is guessed: the file stays shut.
How big a file can it handle?
Hundreds of thousands of rows are fine on a normal laptop; the preview shows the first rows and the download has them all.