Using PDFs
Let’s explore how to convert an invoice from a PDF file into a structured table that can be used for reporting and combined with data from other invoices.
Below is the original PDF:
Our goal is to extract the data from the PDF and organize it in a usable structured format.
- Upload a PDF file
- Create a Copilot chat and choose Spreadsheet as a data source
- Ask the AI to regenerate a structured table from the text. AI can handle unstructured data (only the Generalist model can perform this task).
find order items in the document
show it as table with name of an item, rate, and amount
While the described above process is manual, it can be automated. You'll need to implement a script that automatically feeds the text files into the system.
If you need a repeatable workflow, we can set up an automated conversion script on our end.
