Google Sheets cannot open a PDF. That single fact is behind every frustrating half-hour anyone has spent on this: File → Import accepts .xls, .xlsx, .xlsm, .xlt, .xltx, .xltm, .ods, .csv, .txt, .tsv and .tab — and no PDF format at all. So every method below is really a way of turning the PDF into something on that list, or of skipping the file entirely and writing rows into a sheet directly. Here are the four that work, and how to tell which one you need.
Why Google Sheets can’t open a PDF
Sheets imports spreadsheet and delimited-text formats, because those describe cells: a value, and which row and column it belongs to. A PDF describes a page — characters placed at coordinates so the layout prints identically everywhere. The table you can see in a PDF isn't stored as a table; it's text that happens to line up. There is nothing for Sheets to map onto cells, which is why the PDF never appears in the import dialog rather than appearing and failing.
Worth ruling out two things people reasonably try. IMPORTDATA fetches a .csv or .tsv from a URL, so it will not read a PDF even if the PDF is online. IMPORTHTML pulls tables out of web pages, not documents. Neither is a route in, and neither will tell you why.
Method 1: Open it with Google Docs
Upload the PDF to Google Drive, right-click it, and choose Open with → Google Docs. Drive converts the file, running OCR if it's a scan, and you get the text in a document.
For prose, this is genuinely useful. For tables, it is the method that disappoints most people: the conversion preserves text but routinely flattens table structure, so columns arrive as runs of text and you're back to splitting by hand. It's worth trying when your PDF holds one small, clearly bordered table, and worth skipping when it holds a statement with fifty rows.
Method 2: Convert to CSV or XLSX first
The reliable free route is a two-step: turn the PDF into a format Sheets accepts, then import that. Any PDF-to-Excel converter produces an .xlsx you can bring in via File → Import → Upload, and Sheets will ask whether to create a new spreadsheet, insert sheets, or replace the current one.
If you have Excel, Power Query does the conversion step well for text-based PDFs and can be refreshed later. If you don't, a converter gets you an .xlsx in one pass. The limitation is inherited rather than added: whatever mangles the table during conversion is still mangled when it reaches Sheets, so a messy source produces a messy sheet. The advantage is that this route costs nothing and works on any platform.
Method 3: Workspace add-ons
The Google Workspace Marketplace has add-ons that convert PDFs into sheets from inside Sheets itself, and Chrome extensions that push a table from an open PDF into a new spreadsheet. Installed once, they cut the round-trip through a converter and a download.
Two things to weigh. Add-ons ask for access to your spreadsheets, so it's worth reading exactly what scope one requests before installing — some ask for far more than the job needs. And the extraction quality is the same problem as everywhere else: an add-on reconstructs the grid heuristically, so it does well on bordered tables and poorly on wrapped cells and merged headers.
Method 4: Parse straight into Sheets
Automatic parsing skips the file conversion. Instead of asking "where was the grid", it applies a schema for the document type, reads the values, and writes them into a sheet — so there is no .xlsx in the middle and no import step.
That's how ParseForMe's Google Sheets export works: upload the document, review the confidence-scored fields, then create a new sheet or append rows to an existing one by pasting its link. The Google connection uses the restricted drive.file scope, which limits access to files ParseForMe creates or that you explicitly pick — not your whole Drive. Because it reads the page as an image, it also handles scans and phone photos, which every method above rejects.
The trade-offs, stated plainly: it's a paid step beyond small volumes, and being schema-driven it is strongest on recognised document types like bank statements and invoices, and least differentiated on an arbitrary table in an arbitrary report.
Which method fits your PDF
| Method | Handles scans | Steps | Cost | Best for | | --- | --- | --- | --- | --- | | Open with Google Docs | Yes (OCR) | 2 | Free | Text, or one small bordered table | | Convert to CSV/XLSX | No | 3 | Free | Text PDFs, any platform | | Workspace add-on | Varies | 2 | Free tiers vary | Repeat conversions inside Sheets | | Parse into Sheets | Yes | 1 | Paid beyond small volumes | Scans, volume, recognised document types |
The question that decides it is the same one that decides every PDF extraction: does the file have a text layer? Try selecting a word in your PDF viewer. If nothing highlights, it's an image, and only the OCR rows of that table are open to you — a converter will hand back an empty sheet without explaining why.
Getting the sheet right
A few habits save the rework. On import, check which option you picked — replace spreadsheet overwrites the sheet you were looking at, and it's an easy misclick. Set the locale before importing (File → Settings), because it decides whether 03/04 is March or April and whether a comma is a decimal point or a thousands separator; getting this wrong silently corrupts every number. Watch for values arriving as text — a column of right-aligned numbers is numeric, left-aligned usually means Sheets read them as strings, which breaks SUM without an error message. And verify one known total against the source before you build anything on top of the data.
If the document is financial, the destination is worth a thought too: parsed data can go to Excel in your own template, to Google Sheets, or straight to QuickBooks and Xero. And if you're wrestling with the table itself rather than the destination, how to extract a table from a PDF covers the general case including the open-source tools.