Back

Extract text and tables from a PDF into a doc or sheet

Clean text or table data from a PDF or scan, ready in a Google Doc or Sheet

EAsOpsAnalystsEveryone
Prompt

Open [PDF, screenshot, or web page with the file, e.g. a report PDF in my Drive] and extract [what I need, e.g. all the text, the tables on pages 3 to 5, or everything about pricing and deadlines]. Put the result in [destination, e.g. a new Google Doc, a Google Sheet, or markdown]. For text, keep the original headings, lists, and paragraph breaks. Drop page numbers, running headers, and footers. For tables, make one row per record and keep [columns, e.g. all of them, or just name, date, and score]. Write numbers as plain numbers and dates as YYYY-MM-DD. If the file is scanned or an image, read it carefully. Mark anything you can't read as UNCLEAR instead of guessing. If the file won't open or needs a password, stop and ask me. When done, give me the link plus a short note: pages covered, sections or tables extracted, and anything flagged UNCLEAR.

Works withdocs.google.com