PDF to Google Sheets Converter: Convert PDF Tables to Sheets
Google Sheets has no Import PDF button, so the reliable way in is to convert the PDF to a clean spreadsheet first. PDFXLSX reads the tables, keeps the columns lined up and the numbers numeric, and gives you an XLSX or CSV you can import into Sheets in two clicks. Drop a PDF on the right to start.
Works in any browser. Your first conversion is free and files are deleted after processing.
Drop your PDF here or click to browse
PDF files up to 50MB
PDF to XLSX or CSV, ready to import into Google Sheets. First file free.
The short answer
Google Sheets has no native PDF import, so converting a PDF to Google Sheets takes two steps. Convert the PDF to CSV or XLSX first, then in Sheets choose File, then Import, and upload the converted file. CSV gives the cleanest import because there is no formatting for Sheets to reinterpret. Scanned PDFs need OCR before any of this works, since a scan holds no text to import. Once the data lands, check that the numeric columns sum rather than concatenate.
Last updated July 2026
2 steps
Convert, then import
Columns
Tables stay aligned
Numeric
Numbers you can total
OCR
Reads scanned PDFs
Why Google Sheets cannot open a PDF on its own
There is no Import PDF button in Google Sheets, no menu item, and no function that pulls a PDF in. The reason is the file format. A PDF fixes every character at a coordinate on the page so it looks identical everywhere, but it carries no idea of which numbers form a column or a row. Sheets has nothing structured to read, so it leaves the job to you.
That is why the popular free trick, opening the PDF in Google Docs and pasting the text into Sheets, collapses your table into one column and turns every amount into text Sheets will not add. It is fine for a couple of lines and painful for a real statement, invoice, or report.
The dependable path is a short two-step: convert the PDF to a real spreadsheet first, then import that file. PDFXLSX does the hard half. It finds the table structure, keeps amounts numeric and dates as dates, runs OCR on scans, and hands you an XLSX or CSV that drops straight into Google Sheets through File then Import.
| Date | Description | Amount |
|---|---|---|
| 03/02 | Opening balance | 4,250.00 |
| 03/07 | Card payment | -180.25 |
| 03/14 | Deposit | 1,029.99 |
| 03/21 | Service fee | -12.50 |
The Amount column imports as true numbers, so a SUM works the moment the data lands in Sheets, with no cleanup of stray text values.
Ways to get a PDF into Google Sheets, compared
An honest look at each route and where it leaves you cleaning up the result.
| Method | Keeps columns? | Numbers usable? | Notes |
|---|---|---|---|
| Open in Google Docs, then paste | Rarely | No | The free trick. Text lands in one column and amounts arrive as strings. Fine for a line or two only. |
| Marketplace add-on | Sometimes | Sometimes | Stays inside Sheets, but free tiers cap pages or conversions and complex or scanned layouts still break. |
| Re-key by hand | Yes | Yes | Accurate if you are careful, but slow on long files and one transposed digit throws off a total. |
| Convert here, then File then Import | Yes | Yes | Reads tables, keeps numbers numeric, OCR on scans, and you preview before you import. |
No route is perfect on every layout, which is why the preview matters: you confirm the data before it reaches your sheet. If you only need clean grid tables, the PDF table extractor targets those directly; for everyday whole-document jobs use the PDF to Excel converter.
How to convert a PDF to Google Sheets
Two short steps: convert here, then import into Sheets.
Upload and convert the PDF
Drag the file into the box at the top. PDFXLSX reads the tables, applies OCR if the page is a scan, and builds a clean XLSX or CSV with the columns intact.
Check the preview, then download
Review the rows against your source so you know the numbers tie out, then download the file. Pick CSV if you want the lightest import, or XLSX to keep number and date types.
Import into Google Sheets
In your sheet, open File then Import, upload the file, and choose Replace or a new sheet. Your table lands with columns aligned and amounts as numbers you can total at once.
Prefer to stay hands-off on a recurring CSV link? A downloaded CSV can also be pulled in with the IMPORTDATA function, but for one-off documents the File then Import route is faster and keeps the data static.
What lands in your sheet
Not a wall of pasted text. A structured table ready to filter, pivot, and total.
Tables keep their shape
Rows and columns map to where they belong, including line items that wrap across two lines and totals at the bottom. What you uploaded is the shape that imports into Sheets.
Numbers stay numeric
Amounts with commas, currency symbols, or negatives come through as real numbers, so SUM and AVERAGE work the moment the import finishes. No hunt for cells secretly stored as text.
OCR for scanned PDFs
A scanned statement is an image, so there is no text for any add-on to read. Built-in OCR turns a scanned PDF into rows, so a photographed page imports as cleanly as a digital file.
CSV or XLSX, your call
Download a CSV for the lightest, most universal import, or an XLSX to preserve number and date types. Both open in Sheets through File then Import.
Several PDFs at once
Upload a batch and convert them together instead of one at a time. See how to convert multiple PDFs when you have a folder of statements bound for one sheet.
Private and secure
The documents you most need in a sheet are usually the most sensitive. Uploads are encrypted in transit and at rest, processed in isolation, and deleted automatically once your file is ready. Nothing is kept or reused.
Who works in Google Sheets but gets data as PDFs
If your team lives in Sheets but the source documents arrive as PDFs, this conversion is the step that eats the most time. These are the people it helps most.
-
Bookkeepers and accountants on Google Workspace who reconcile in Sheets and need statements and reports as live data. See the workflows for accountants and bookkeepers.
-
Analysts and operations teams rebuilding a vendor report or price list as a working sheet so they can filter, pivot, and chart the figures.
-
Founders and small teams running the business out of a shared Google Sheet who get a bank or card statement as a PDF and need the transactions in a tab today.
-
Anyone facing a stack of PDFs who needs the numbers in Sheets today and does not want to spend the afternoon retyping them cell by cell.
Working in Excel instead?
Excel and Google Sheets read the same files, so the converted XLSX or CSV opens in either one. For the Excel side of the workflow, the PDF to Excel converter covers it, and how to convert a PDF to Google Sheets walks through every method in detail.
For figures that must tie out to the cent, the accurate PDF to Excel converter is the place to start.
PDF to Google Sheets: common questions
Convert the PDF to a spreadsheet file first, then import it. Upload the PDF into the tool at the top of this page or the general-purpose PDF to spreadsheet converter, check the preview, and download an XLSX or CSV. In your Google Sheet, open File then Import, upload that file, and choose Replace or a new sheet. The table lands with columns aligned and numbers ready to total.
No. Google Sheets cannot open or import a PDF directly. There is no Import PDF button, no menu item, and no function that reads a PDF, because a PDF stores no table structure for Sheets to interpret. You convert the PDF to XLSX or CSV first, then import that file through File then Import.
Turn the PDF into a CSV or XLSX, then use File then Import inside Sheets. Convert the document with the tool above so the columns and numbers survive, download the file, and in your sheet pick File, Import, Upload, and the file. Choose whether to replace the current sheet or add a new one, and the data appears in clean cells.
You can attach a PDF as a link or insert it as an image in a cell, but neither makes the data editable. To work with the numbers, you have to convert the PDF to a spreadsheet and import that. Inserting the PDF only shows the page; converting it gives you rows and columns you can sort, filter, and total.
Upload the statement PDF here, let the tool read the transaction rows and run OCR if it is a scan, then download a CSV or XLSX and import it into Sheets. The dates, descriptions, and amounts land in separate columns with the figures kept numeric, so you can categorize and reconcile without retyping a single line.
Your first conversion here is free, and the Google Docs copy-paste trick costs nothing but flattens your table. The difference is the result: a real converter keeps the columns and numbers intact so the import is usable, while the free paste route leaves you rebuilding the layout by hand. For ongoing or high-volume work, a paid plan pays for itself in saved time.
For anything beyond a couple of lines, convert the PDF to XLSX or CSV with a structure-aware tool and import that file. It keeps columns and number types intact, handles multi-page and scanned files, and lets you check the data before it reaches your sheet. Copy-paste is only worth it for a tiny table you can fix by eye.
More PDF to spreadsheet options
PDF to Excel Converter: Convert PDF to Excel Online
Convert PDF to Excel online with a converter built for business. Keeps tables intact and numbers numeric, runs OCR on scans, exports clean XLSX or CSV.
FeaturesAI PDF to Excel Converter: Convert PDF to Excel With AI Accuracy
Convert PDF to Excel with an AI converter that reads tables and scanned files, keeps numbers numeric, and exports clean XLSX or CSV. First file free.
FeaturesConvert PDF to XLSX Online With Real Cell Structure
Convert PDF to XLSX online into a native Excel file with real cell structure: numbers numeric, dates as dates, tables aligned. OCR included, first file free.
FeaturesPDF Table Extractor: Extract Tables From PDF to Excel
Extract tables from PDF to Excel automatically. A PDF table extractor that keeps rows and columns aligned, handles merged and multi-page tables, and reads scans.
Convert your PDF for Google Sheets now
Drop a PDF at the top of the page, check the rows, and download a clean XLSX or CSV that imports into Google Sheets with File then Import. Your first conversion is free. For the full Excel workflow use the PDF to Excel converter, or pull only the grids with the PDF table extractor.