Short answer: Use PDF2XLS to turn a PDF into a Google Sheets‑ready .xlsx, then import it in Sheets. It’s free for 3 files/day with no signup, up to 10 MB each. GPT‑5 vision handles scans and photos. Tables, rows, columns, and numbers survive; fonts, colors, logos, images, and formulas don’t.
- Free tier: 3 files/day, no signup
- Max size: 10 MB per file, one at a time
- Output: .xlsx that opens in Google Sheets, Excel, Numbers, LibreOffice
- Scanned PDFs: Yes — handled by GPT‑5 vision (no OCR toggle)
- Privacy: Processed server‑side via OpenAI API; files auto‑deleted
- Works on: Any browser — Windows, macOS, Linux, iPhone, iPad, Android
Can Google Sheets open a PDF directly?
Google Sheets can’t import a PDF as a spreadsheet. In Google Drive you can right‑click a PDF and choose Open with → Google Docs, but that tries to turn pages into flowing text. Tables usually lose their grid, numbers become text, and scans/photos fare poorly.
What’s the fastest way to get a PDF table into Google Sheets?
Convert the PDF to .xlsx here, then import that file in Sheets.
- Upload the PDF above and download the .xlsx result.
- Open Google Sheets → File → Import → Upload → Select the .xlsx.
- Pick “Insert new sheet(s)” (keeps your current sheet) or “Replace spreadsheet.”
- Click Import data. Sum a numeric column to confirm numbers, not text.
This preserves the table grid (rows, columns, cell values) so the sheet is ready to filter, sort, and chart.
Why convert first instead of using Google Docs?
Docs aims for readable paragraphs, not spreadsheets. Our converter outputs a true .xlsx, which Google Sheets opens natively. GPT‑5 vision also reads scans and photos in the same run, so receipts, statements, or camera shots become structured rows, not a wall of text.
Common import gotchas in Google Sheets (and quick fixes)
If numbers show as text: apply Format → Number → Automatic, then try =SUM on the column. If still text, set File → Settings → Locale to match your decimal separator, then reimport.
If dates look wrong: set Format → Number → Date (or a custom date), or change the Locale/Time zone before importing.
If headers look stacked or too tall: unmerge via Format → Merge cells → Unmerge, and turn on Wrap via Format → Wrapping → Wrap.
If columns feel narrow: select all (Ctrl/Cmd+A) → double‑click any column boundary to auto‑fit.
Remember: fonts, colors, logos, page headers/footers, and formulas don’t carry over from the PDF.
Need CSV for an app import?
If your target system wants CSV, first convert the PDF here to .xlsx, then export from Sheets as CSV (File → Download → Comma‑separated values). For tips on delimiters and UTF‑8, see
PDF to CSV Online.
Does this work with scans and phone photos?
Yes. Scanned PDFs and photos go through GPT‑5 vision automatically — no extra steps. For best results, use a straight, well‑lit image without shadows. If the camera shot is rotated, rotate it before uploading. For edge cases and checks, see
OCR for scanned PDFs.
What if I’m not tied to Sheets specifically?
You’re still converting to a standard .xlsx that opens anywhere. If you just need clean tables regardless of app, read our
PDF extractor for tables overview.
Ready to turn your file into a spreadsheet? Upload it now and
convert your PDF.