Easy Tech TutsHow to Extract Data From a PDF to Google Sheets Easily 2026
By Impran M NLast checked against official docs
Retyping figures from an invoice or report is slow, and one wrong keystroke becomes a bad total three tabs later. Google Sheets can't open a PDF and read its tables by itself.
Add-ons from the Google Workspace Marketplace fill that gap, and once one is installed the job is mostly point and click. This guide installs an extraction add-on from inside Sheets, runs it against a sample PDF, and covers the cleanup that almost every extraction needs.
The add-on in the walkthrough opens a dialog titled PDF to Sheets. Others in the Marketplace work along similar lines, but their buttons, free limits and OCR support differ, so read the listing before you install.
01Install a PDF extraction add-on
Open a spreadsheet and click Extensions > Add-ons > Get add-ons. The Google Workspace Marketplace opens on top of the sheet, already filtered to apps that work with Sheets, and each card shows a rating and install count.
Search "pdf" and pick a tool that says it converts PDF tables to Sheets. A general document utility won't do the same job.
Click the add-on to read its full description, then click Install and Continue. Most add-ons ask for access to data they need, such as the spreadsheet they'll write into. Read the request, click Allow, then Done.
02Launch it from the Extensions menu
Installed add-ons don't get a menu of their own. They sit under Extensions, each with a submenu for opening it.
Before launching, decide where the data should land. A blank tab keeps the import away from anything you've already built, and it's easier to spot a misaligned column against an empty grid.
03Pick the pages and process them
After you upload the PDF, the PDF to Sheets dialog shows every page as a numbered thumbnail. Click a page to select it and it highlights in blue.
Hold Shift to select a run of consecutive pages. There are also Select All and Clear buttons.
Select only the pages that hold tables. Cover pages and running text add rows you'll just delete later, and on a page-capped free tier they use up your allowance. Then click Process Selected Pages and the add-on writes what it finds into the spreadsheet.
04Check and clean up the output
Clean tables with clear rows and columns usually come through intact. Merged cells, entries that wrap onto two lines, and uneven spacing are where things go wrong.
Scroll through before you build anything on top. Look for three things.
Numbers stored as text sit left-aligned instead of right-aligned, and SUM ignores them. Dates may arrive in an unexpected format.
Columns can split or merge if the PDF's layout wasn't a strict grid. For text that landed in one cell but belongs in several, use Data > Split text to columns.
Then set number and date formats explicitly from the Format menu instead of trusting Sheets' guess. If you pull the same kind of document every month, keep the destination tab's columns the same each time so the checks become routine.
When it doesn't work
The add-on returns nothing, or gibberish, for a scanned PDF
Why: A scanned page is an image with no text layer, so a tool without OCR has nothing to read.
Fix: Use an add-on whose listing mentions OCR for scanned PDFs. For plain text (not tables), Google Drive's own Open with > Google Docs converts PDFs of 2 MB or smaller, though Google warns tables are not likely to be detected.
The add-on no longer appears under Extensions
Why: It has been turned off for this spreadsheet.
Fix: Go to Extensions > Add-ons > Manage add-ons, open the add-on's Options (three dots) and turn on Use in this document.
Totals don't add up after import
Why: Some numbers came in as text, often because of currency symbols, stray spaces or thousands separators in the PDF.
Fix: Select the column and apply Format > Number. Any cells still left-aligned need their stray characters removed first.
Frequently asked questions
Can Google Sheets read a PDF without an add-on?
No. Sheets has no built-in PDF import. You need a Marketplace add-on, or you can convert the PDF to text in Google Drive first and paste it across, which loses the table structure.
What about scanned PDFs?
A scanned PDF is really an image, so it needs OCR. Some add-ons include it. Google Drive can also OCR a PDF via Open with > Google Docs, but only files of 2 MB or less, and Google says tables are not likely to survive.
Can I extract only certain pages of a long PDF?
Yes, in the add-on shown here. Click individual thumbnails, or hold Shift to select a consecutive range, then click Process Selected Pages.
How do I remove an add-on I no longer want?
Open Extensions > Add-ons > Manage add-ons, click Options next to the add-on, and choose Uninstall.
Sources and last check
The Marketplace screen, the PDF to Sheets dialog and its page-selection controls come from the original screen recording. The install, permission and manage/uninstall steps were re-checked against Google's Docs Editors Help, and the Drive OCR route and its 2 MB limit against Google Drive Help, in September 2026. Add-on pricing was read from one Marketplace listing on the same date; the recording doesn't show which listing its add-on came from, so treat that figure as an example. This pass also removed an unsupported claim that a repeat routine halves the time per document.
About the author
Impran M N
I've been hooked on technology for as long as I can remember — especially the new tools and AI apps that seem to land every other week. Easy Tech Tuts is where I write up whatever I've just worked out: I do the task in the real product, record the screen, and turn it into the guide I wish I'd found first.
