Two ways to "insert" a PDF in Google Sheets
Depending on what you actually need, the right approach differs:
-
1You want the PDF's data inside the Sheet (most common)Use PDF2Sheets โ AI extracts every table, row, and number from your PDF and creates a live Google Sheet in your Drive. Works on any PDF including scanned documents.
-
2You want to link to the PDF from a cell (for reference)Upload the PDF to Google Drive, copy the shareable link, then use
=HYPERLINK("url", "View PDF")in a cell. Clicking opens the PDF โ but the data stays locked inside the PDF.
Frequently asked questions
Can I embed a PDF as an image inside a Google Sheets cell?
No. Unlike Word or PowerPoint, Google Sheets doesn't support embedding a PDF as a visual object inside a cell. The practical workarounds are linking to the PDF (Method 2 above) or extracting its data into the Sheet using PDF2Sheets.
How do I insert a PDF table into Google Sheets?
PDF2Sheets. Copy-pasting from a PDF collapses all columns into one โ the AI in PDF2Sheets reads the visual structure of your table and maps every column correctly. Upload, preview, and your table appears in a Google Sheet as proper rows and columns.
Does this work with scanned PDFs?
Yes. PDF2Sheets uses AI vision โ not just text extraction โ so it reads printed tables from scanned and image-based PDFs just as effectively as digital PDFs.