Excel Template Filler
Problem Statement
Consider a purchasing professional who already has a predefined Excel template for collecting information.
The Excel file contains the required fields in the first row and their corresponding descriptions in the second row.
The user now needs to extract information from multiple PDF documents and populate the existing Excel template. Each PDF should represent a new row in the Excel file.
Without automation, the user would need to open each PDF individually, identify the relevant information, and manually enter it into the appropriate columns of the Excel template.
As the number of documents increases, this becomes a repetitive and time-consuming process.

Solution Using Workflows
The Smart Template Filler automates the process of extracting information from PDF files and populating an existing Excel template.
The workflow understands the fields defined in the provided template, processes the uploaded PDFs, and fills the corresponding information into the Excel file.
Each PDF represents a new row in the completed Excel file.
Using Smart Template Filler
The Smart Template Filler requires no additional workflow configuration from the user.
To use it:
Go to Workflows and select Smart Template Filler.
Click Run.
Upload the predefined Excel Template.
Upload the PDF files containing the information that should be added to the template.
Submit the form.
The workflow processes the PDF files and fills the corresponding information into the Excel template.
Once the workflow completes, download the completed Excel file from the Output Block.
How It Works
The overall process is:
Upload Excel Template + PDF Files → Read Template Fields → Process PDFs → Extract Relevant Information → Populate Excel Template
For example, suppose the Excel template contains:
Vendor Name
Invoice Number
Invoice Date
Total Amount
Name of the vendor
Unique invoice number
Date shown on invoice
Final invoice amount
If 20 invoice PDFs are uploaded, the workflow processes the documents and adds the extracted information to the Excel template, with each PDF represented as a new row.
Result
The user receives the same Excel template populated with information extracted from the uploaded PDF files.
This allows organizations to continue using their existing Excel formats while automating the repetitive task of transferring information from documents into those templates.
Last updated
Was this helpful?
