> For the complete documentation index, see [llms.txt](https://docs.empowergpt.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.empowergpt.ai/workflows/workflow-usecases/excel-template-filler.md).

# 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.

<figure><img src="https://2192711725-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fc2KRGWrkyRO0iZN5Lyeg%2Fuploads%2FfUB9Vs8xsU1y39JpjekY%2Fimage.png?alt=media&amp;token=2063da63-02fa-4f35-a7c1-4b349ddd8f29" alt=""><figcaption></figcaption></figure>

### 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:

1. Go to **Workflows** and select **Smart Template Filler**.
2. Click **Run**.
3. Upload the predefined **Excel Template**.
4. Upload the **PDF files** containing the information that should be added to the template.
5. Submit the form.
6. The workflow processes the PDF files and fills the corresponding information into the Excel template.
7. 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.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.empowergpt.ai/workflows/workflow-usecases/excel-template-filler.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
