Using AI to Pull Data from PDFs into Spreadsheets
Details
If you've ever tried copying a table from a PDF into Excel, you know how it goes — the columns collapse into a single mess of text, numbers pick up random spaces, and headers vanish. Multiply that by dozens or hundreds of documents and it becomes a real bottleneck.
In this session, we'll use AI to extract structured data from PDFs and get it cleanly into spreadsheets — no manual re-entry required.We'll look at common real-world scenarios:
Invoices and receipts — pull line items, totals, and dates straight into your accounting workflow
Bank and credit card statements — convert monthly statements into clean spreadsheet rows
Product catalogs and price lists — extract tables from vendor PDFs into your inventory system
Scanned documents — handle OCR challenges when the PDF is just an image
If time allows, we'll also explore batch processing — feeding a folder of PDFs through an AI pipeline and getting a single consolidated spreadsheet out the other end.Who is this for?
Anyone who regularly deals with data locked in PDFs. No coding experience needed — we'll walk through everything live.