Convert PDF to Google Sheets without leaving your spreadsheet
PDF to Sheets is a Google Sheets add-on that reads the tables inside a PDF and lays them out as rows and columns. Send the result to Google Sheets, Excel or CSV. It reads scanned pages too.
4.5 out of 5 on the Google Workspace Marketplace
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| 03/01 | Opening balance | 8,412.60 | ||
| 03/02 | Northside Hardware | 184.25 | 8,228.35 | |
| 03/04 | Client payment 1047 | 2,300.00 | 10,528.35 | |
| 03/05 | City Water Utility | 96.40 | 10,431.95 | |
| 03/09 | Payroll | 3,150.00 | 7,281.95 | |
| 03/12 | Client payment 1052 | 1,875.00 | 9,156.95 |
- Marketplace rating
- 4.5
- Installs
- 60K+
- Free to try
- 5 pages
How to convert a PDF to Google Sheets
Four steps, all inside the spreadsheet you already have open.
Add PDF to Sheets to Google Sheets
Install it from the Google Workspace Marketplace. It takes one click and adds nothing to your computer.
Open it from the Extensions menu
In any spreadsheet, go to Extensions, choose PDF to Sheets and open the converter in the sidebar.
Upload your PDF and pick an output
Choose the file, then choose where the data should go: the current Google Sheet, an Excel file, CSV or XLS.
Convert and check the totals
The tables land as rows and columns. Compare one total against the PDF before you build on the data.
PDFs it turns into spreadsheets
Anything laid out in rows and columns converts. Pick a document for a walkthrough and sample output.
- Bank statementsTurn a PDF bank statement into Google Sheets, Excel or CSV rows with date, description, debit, credit and balance columns. Works on scanned statements.
- InvoicesPull line items, quantities, unit prices and totals out of PDF invoices into Google Sheets, Excel or CSV. No retyping, and scanned invoices work too.
- Scanned PDFs (OCR)Convert scanned PDFs and photographed pages to Google Sheets, Excel or CSV. OCR reads the page, then tables are rebuilt as rows and columns you can edit.
- Purchase orders
- Receipts
- Credit card statements
- Tax forms
- Price lists
- Inventory lists
- Shipping manifests
- Research tables
- Billing reports
- Application forms
What the converter does
Finds the tables for you
It detects tables, columns and structured data on each page, so you do not draw boxes or set up a template first.
Keeps rows and columns in place
Each line of the PDF becomes a row and each column stays a column, which is the part copy and paste gets wrong.
Reads scanned pages
Scans and photographed pages go through OCR, so a printed statement that was scanned to PDF still converts.
Handles long, multi-table files
Multi-page PDFs and pages with more than one table are processed in a single conversion.
Outputs four formats
Send the data to Google Sheets, Excel (.xlsx), CSV or XLS. Pick the one your next step needs.
Lives inside Google Sheets
It runs from the Extensions menu on desktop, Chromebook and tablet. There is no separate site to sign in to.
PDF to Sheets for your line of work
The documents, the columns you get back and the checks worth doing, by industry.
- Accountants and bookkeepersConvert client bank statements, invoices and financial reports from PDF to Google Sheets, Excel or CSV. Less retyping at month end and tax time.
- ProcurementConvert supplier quotes, price lists and purchase orders from PDF to Google Sheets, Excel or CSV and compare vendors side by side without retyping.
- Real estateConvert rent rolls, T12 operating statements and closing statements from PDF to Google Sheets, Excel or CSV so you can underwrite instead of retyping.
Reviews
What people who installed the add-on rated it.
4.5 out of 5
Pricing
Your first 5 pages are free, which is enough to test it on a real document before paying for anything.
Paid plans cover higher monthly volumes. Plan options are shown inside the add-on after you install it, and you can cancel a subscription when you no longer need it.
Convert 5 pages freePermissions and privacy
The add-on only works in spreadsheets where you have installed it. Google shows you the full permission list before you install, and you can remove the add-on at any time from Extensions > Add-ons > Manage add-ons.
Read the privacy policy and the terms of service, or see the documentation for setup help.
Questions about converting PDF to Google Sheets
How do I convert a PDF to Google Sheets?
Install PDF to Sheets from the Google Workspace Marketplace, open a spreadsheet, and start the add-on from the Extensions menu. Upload the PDF, choose Google Sheets as the output and convert. The tables in the PDF arrive as rows and columns in your sheet.
Can Google Sheets open a PDF on its own?
No. File > Import in Google Sheets accepts spreadsheet and text formats such as XLSX, CSV and TSV, but not PDF. Opening a PDF with Google Docs turns it into text and usually flattens tables into loose lines, so you still have to rebuild the columns by hand. An add-on that reads table structure is the direct route.
Is PDF to Sheets free?
You can convert up to 5 pages at no cost. Paid plans cover higher volumes, and you can see the plan options inside the add-on once it is installed.
Does it work with scanned PDFs?
Yes. Scanned pages and photos of documents go through OCR first, so the text is read from the image and then placed into rows and columns. Clear, straight scans give the best results.
Can I export to Excel or CSV instead of Google Sheets?
Yes. Choose Excel (.xlsx), CSV or XLS as the output when you convert. The conversion still happens from inside Google Sheets.
Where do I find the add-on after installing it?
Open any Google Sheets file and look in the Extensions menu at the top. PDF to Sheets appears there. If you do not see it, reload the spreadsheet tab once.
What access does the add-on ask for?
It asks to view and manage the spreadsheets it is installed in, to show a sidebar inside Google Sheets, to connect to an external service that does the conversion, and to see your Google account email address. The full list is on the Permissions tab of the Marketplace listing.
Stop retyping PDFs into spreadsheets
Add PDF to Sheets to Google Sheets and convert your first 5 pages free.