How to auto-fill online forms from Excel data with a free Chrome extension

Open the form and note each field type: plain text inputs (name, phone, email), a date field, radio buttons (gender) and drop-down selectors. Have your Excel data ready with one row per record.

Add the Excellent Data Filler extension from the Chrome Web Store. It also installs in Microsoft Edge. Then open the page with the form you want to fill.

Right-click on the form, open the Excellent Data Filler menu and select Insert site. A new tab opens with a new site. Select Edit site to change the title and description if you want. The page URL is saved with the site.

Open the form fields editor to see every field the extension found. Disable any it created that your form does not use. In the video that means the extra month, day and year fields next to the date of birth, a postal code field and a website field. Use Edit field to confirm types: the gender field shows as radio and the drop-down as select. Save with the update button at the top.

Go to the Upload Excel tab and select Download Excel template. Open it, select Enable Editing, and paste your rows under the headers the extension created. Check that every column lines up with the right data. If the template has an extra column, go back, disable or edit that field, and download the template again. Save the file.

In the Upload Excel tab, select Choose file, pick the template you filled in, and select Update. Reload the form page: the extension fills the first row straight away. Check every field landed in the right place before you set up submitting.

Go to the Site form pages tab and open the field editor. Select the plus button to insert a new field. In the field name box, type a curly bracket to see the available inputs and choose the form field option, then save.

On the form, right-click the Submit button and choose Excellent Data Filler > Copy element XPath selector address (select Allow if asked). Paste it into the new field and set the selector type to XPath.

Open the Success settings. Submit one filled form yourself to see the success page URL, then paste it in. Under the URL match type, keep the full URL, or pick a host name match if the success URL changes with each submission.

For the success check:

• If your form shows a message, choose matching message in page, paste the XPath of the message (right-click it > Excellent Data Filler > copy XPath) and paste the message text.
• If your form shows a popup, choose checking element exists on page.

Under the action, choose redirect to page and paste the form URL so it loops back for the next row. You can also set a delay between submissions. Select Update.

Open the extension Settings. Under the form filler settings, turn on the option to show the entry status per row, and turn on the option to stop the form filler when Excel data is not found or all rows are marked as filled. That stops it at the first blank row. Select Update settings.

Open the form page. The extension starts automatically when it sees the URL, and a status bar shows progress. If a row cannot be entered, select Next to move on.

• To pause, switch to another tab. It continues when you come back.
• To stop, use the Activate/Deactivate toggle.
• The Excel data tab shows the status of every row. Finished rows are marked done and skipped next time, so you do not get duplicates. Turn a row's toggle off to enter it again, or on to skip it.