DEV Community

File Filler
File Filler

Posted on

How to Auto‑Fill Web Forms from Excel or CSV Using a Chrome Extension

Manually copying data from Excel into web forms is one of those tasks everyone hates but still ends up doing.
Copy → switch tab → paste → repeat.
If the form has 20 fields, you repeat the cycle 20 times. If you have 50 rows, you repeat it 50×.

I wanted something simpler.
No flows.
No scripts.
No mapping.
Just: upload file → fill form.

So I built a Chrome/Edge extension that does exactly that.

👉 https://exceltoform.com

Below is a breakdown of how it works and the logic behind it.

🔍 How the Extension Finds the Right Fields
When you upload an Excel/CSV/TXT file, the extension reads the header names (e.g., First Name, Email, Address) and searches the entire webpage for matching text.

It looks for matches in:

labels

placeholders

input names

nearby text around the field

If it finds a match, it fills the value automatically.

No configuration.
No selectors.
No XPath.
Just smart matching.

🟦 Mode 1: Simple Form Filling
This mode is for classic forms where each field appears once.

You only choose where your headers are:

first row

or first column

That’s the only setup.

How it works
The extension takes your header names

Scans the page

Finds matching fields

Fills them

Repeated fields
You can choose how duplicates behave:

Repeat ON → same value goes into all matching fields

Repeat OFF → values are filled in order (useful when your file contains multiple entries for the same field)

🟩 Mode 2: Table Form Filling
This mode is for data organized in rows (like a customer list, product list, etc.).

Example:

Row 1 → column headers

Column 1 → field names used for matching

Each row → one complete record

The extension ignores the rest of row 1 — it only uses the first column for matching.

Why?
Because the user defines the order directly inside the extension (Order section).
The column order in the file doesn’t matter.

This makes the system flexible and avoids strict file structures.

🟧 Mode 3: Template File
This is the fastest mode when you want full control.

The extension generates a template file containing all fields it found on the webpage.
Each field is represented by a number.

You simply:

Generate the template

Fill in the values

Upload it back

If a cell is empty, the extension skips that field.

No rules.
No mapping.
Just fill → upload → done.

🎯 Why I Built It
Most automation tools are powerful but require too much setup:

mapping fields

configuring flows

adjusting selectors

debugging when the page changes

For simple form filling, it’s overkill.

I wanted something that works the way people actually work:

upload a file

choose header orientation

decide how repeated fields behave

fill the form

That’s it.

If it saves someone from the repetitive Excel → browser → Excel → browser loop, then it did its job.

🔗 Try the Extension
Chrome & Edge:
https://exceltoform.com

Top comments (0)