How to Prepare an Excel or CSV File for Form Autofill

Last updated 2026-11-17

A form filler that matches by header names is only as good as the file you give it. Most "it did not fill that field" problems come from headers that do not match the page. This guide shows how to lay out an Excel or CSV file for File Form Filler (Classic). If you would rather not think about names at all, skip to the last section.

1. Put header names in the first row or the first column

The header names can go either in the first row, with one record per row below, or in the first column, with one record per column to the right. Pick the layout that suits your data and tell the extension which one you use (Row or Column mode).

2. Make headers match the field names on the page

Each header should match what identifies the field on the page: its placeholder, its label, its aria-label or the text near it. If the form asks for "Email address", a header called "Email address" works better than "contact". Same or similar names are matched, but the closer they are, the more reliable the result.

3. Keep it simple

  • One header per field, with no merged cells.
  • Put the data directly below (or beside) the headers, with no empty rows in between.
  • Use the same spelling and language as the form.
  • If you save as CSV, use UTF-8 so accented characters survive.

4. Fill several records with one file

To fill many forms from many records, put one record per row (or column) and use the "Index to fill" setting. It tells the extension which record to use next, increases automatically after each fill and is stored locally in your browser, so you do not have to upload the file again.

5. Fields that appear more than once

The Repeat option decides what happens when several fields on the page have the same name. With Repeat on, every such field gets the same value (every "phone" field gets the same phone number). With it off, each field is filled once in order, so the second phone field receives the next phone value from your file.

6. Tables and row-based forms

For forms that are tables, such as order rows or inventory lists, use Table Form mode: the first row of the file holds the column names and each row after it is one table row. The Order section lets you change the order, remove fields or add an empty column.

7. Checkboxes, radio buttons and dropdowns

In template mode the extension generates a file from the form for you. In it, write x in the position of a checkbox or radio button you want selected, leave a cell empty to leave the field empty, write the exact value from the list for a dropdown, and separate several values with a comma.

Or skip the matching altogether

If your headers will never line up with the form, or your data is in a PDF or a Word file, an AI tool such as Formly finds the matching fields itself, so the file does not need any preparation. The trade-off is that the file is sent to an AI provider to process the request. The local vs AI comparison helps you decide, and the step-by-step guide shows each mode in detail.

Frequently asked questions

Where do the header names go?

In the first row of the file (one record per row below) or in the first column (one record per column to the right).

What if a header does not match any field?

That value is not filled. Rename the header to match the field label or placeholder, or use an AI tool that matches by meaning.

Can I use a CSV file instead of Excel?

Yes. File Form Filler reads both Excel and CSV files, and you can also paste the data into its text area.

Try it on your next form

Free: 10 fills per month. Paid plans for more.

Prefer 100% local? See Classic & Automation