First, identify your PDF type
Business PDFs fall into two distinct groups:
• Digital PDF: generated directly by software (like QuickBooks, Stripe, or Google Docs). You can highlight and select the text with your cursor. This is the easiest case.
• Scanned PDF: a photograph or flat scan of a printed page. You cannot highlight individual words with your cursor. It requires optical character recognition (OCR) or an AI vision model to recognize letters and numbers.
To test your file, open it in any browser or PDF reader and try to highlight a single word. If it highlights cleanly, it is a digital PDF. If you can only drag a selection box over the page, it is a scan.
Method 1: Copy and paste (best for short lists)
If you only have a single digital table with 5 to 10 rows, select the text in your PDF viewer, press Ctrl+C (Cmd+C), and paste it into Excel.
If all values paste into a single column, select the column and click Data → Text to Columns in Excel. Choose "Delimited", check "Space" or "Tab", and click Finish.
Limits: Works reasonably well on clean text lines. It frequently scrambles multi-column financial tables, merges adjacent numbers, or loses column headers.
Method 2: Excel’s PDF import (Microsoft 365)
If you use a modern Microsoft 365 subscription on Windows or Mac, Excel includes a native PDF connector:
1. In Excel, go to the Data tab on the ribbon.
2. Select Get Data → From File → From PDF.
3. Choose your PDF file. Excel scans the document and opens the Navigator window listing every detected table.
4. Select the table you want, click Load, and Excel places it into a structured worksheet.
Limits: Handles clean vector tables with gridlines well. It fails completely on scanned documents and smartphone photos because it lacks OCR capabilities.
Method 3: Google Drive & Google Docs OCR (free scanned text)
If you have a scanned page and do not want to install software, upload the PDF to Google Drive. Right-click the file and choose Open with → Google Docs.
Google runs free OCR and renders the document as editable text beneath the original scan. You can then copy the text into Google Sheets or Excel.
Limits: Google Docs OCR captures paragraph text decently, but it almost always destroys tabular structures, leaving cell values stacked in one long vertical list.
Method 4: AI extraction with Siftspindle (best for tables & mixed layouts)
When you have multi-page invoices, receipts, borderless tables, or scanned documents, AI extraction reads the layout semantically rather than relying on strict line grids.
1. Sign in at siftspindle.com. Free accounts get 10 extractions each calendar month with no credit card required.
2. In the prompt instructions box, specify the target columns (for example: Vendor, Invoice Number, Date, Line Items, Quantity, Rate, Total).
3. Upload your PDF, photo, or document (supports PDF, PNG, JPG up to 25 MB).
4. Review the extracted table preview and download your clean Excel (.xlsx) file or copy the structured JSON.
Privacy guarantee
Uploaded documents are processed in private environments and automatically purged from Siftspindle servers after approximately 24 hours.
What to check before using your data
Never import extracted data directly into your bookkeeping software without checking these four items:
• Sanity check totals: In Excel, write a quick formula (=SUM) to confirm that Subtotal + Tax matches the extracted Grand Total.
• Check similar digits: On scans or faded receipts, check numbers that look alike (3 vs 8, 1 vs 7, 0 vs O).
• Verify decimal places: Ensure currency amounts did not drop decimals (e.g., $14.50 misread as $1450).
• Align column headers: Confirm that descriptions did not spill over into adjacent quantity or price columns.