Turn the tables in a PDF report into an Excel sheet
Drop a PDF report and get its main table as Excel rows and columns. Figures, percentages and recommendations stay as written.
This preview shows the first 25 rows and does not keep your file.
Need a different result? Turn anything into anything: drop any file, pick what you want out of it.Try it →Reports keep their numbers in layout: a table that runs across pages, a figure stated in the summary and again in a findings section. Copying them into a spreadsheet by hand is slow, and it is easy to shift a decimal or drop a row. This page pulls the main table out of your report into rows and columns, keeping the figures, percentages and recommendations as the report words them.
What you get
Main table as rows and columns
The tool finds the main table in the report and lays it out as an Excel-style grid of up to 8 columns, with the header row kept as the column names.
Figures kept as written
Numbers, percentages and currency values are copied as the report shows them, so 6.2% stays 6.2% and 3.41 stays 3.41. Nothing is rounded or recalculated.
Gaps left empty
If the report does not give a value for a cell, that cell is left blank rather than filled with a guess. A missing Q2 figure shows as an empty cell.
How it works
- Step 1
Paste the report text into the box, or drop the PDF, Word or text file onto it.
- Step 2
Read the preview: it shows the first rows and columns of the main table, taken from up to 5 pages or about 6,000 characters.
- Step 3
With a free account you get every row of a long report, a download as .xlsx, OCR for scanned pages, batches of files and the option to edit the table by asking.
Who uses it
Analysts comparing figures across reports
Turn the results table from several quarterly reports into sheets you can line up side by side, with each figure as written in its source.
Managers checking a report before a meeting
Get the key table into a spreadsheet quickly to sort or filter it, then compare against the recommendations section of the report.
Students and researchers collecting data
Pull the tables from published reports into a sheet for your own notes, keeping the original wording and any gaps the authors left.
Questions
What does the free preview show?
The preview reads up to 5 pages of a PDF (2 MB) or about 6,000 characters of text, and shows the main table as rows and columns. A free account gives you the whole table, every row, and a download as .xlsx.
Will the figures match the report exactly?
The tool keeps figures, percentages and recommendations as written and leaves a cell empty when the report does not give a value. Results can still contain mistakes, so check the Excel table against the original report whenever the numbers matter.
Can it read a scanned report?
Scanned pages need OCR, which is included with a free account. Without an account, the preview works on PDFs that contain selectable text.
What if the report table has more than 8 columns?
Tables are built with at most 8 columns. For a wider table, check the Excel output against the original and add any missing columns by hand or by asking for an edit with a free account.
Is my report stored after the preview?
The preview does not keep your file. Accounts handle whole documents, so if you sign up to process a full report, the account is what covers the full result.
Related tools
See it on real examples
Three actual runs of this tool. Open one to see the input and the whole result.