Prompt to extract data into a table
Documents and PDFsFree prompt
Paste the text of an invoice, a statement, a report or a list: the AI extracts the information you want and arranges it in a table to paste into Excel or Google Sheets.
Your prompt
🔒 The fields stay in your browser. The prompt is only sent to the AI service you choose to open.
How do I extract data from a PDF into a table with ChatGPT?
Get the text of the PDF, for example with the Lunyce "PDF to text" or "OCR" tools, then ask the AI for a table with the columns you want, values copied exactly, empty cells where information is missing and a list of doubtful values. Then check the totals.
How to use it
- Get the text of the document with "PDF to text", "OCR" or "Image to text".
- List the columns you want and the output format, paste the text, then copy or open the prompt.
- Paste the result into your spreadsheet and check the totals and any values flagged as doubtful.
Tips for better results
- If the PDF already contains real tables, try the "PDF to Excel" tool first: it converts them directly.
- If your spreadsheet uses a comma as the decimal separator, ask for a semicolon-separated CSV instead.
- For many pages, process the document in batches of 2 or 3 pages to avoid omissions.
Can ChatGPT make mistakes when extracting figures?
Yes, especially with badly recognised or very long text. This prompt tells it to leave illegible values empty and list doubtful ones; always compare a few rows and the totals with the original document.