LoopClicker

Guides

Fill a web form from a CSV or Google Sheets

Typing fifty rows of a spreadsheet into the same web form is slow and error-prone. With a LoopClicker scenario and a data table, each row becomes one filled and submitted form.

Step by step

  1. Save your spreadsheet as a CSV file, or select the rows in Google Sheets and copy them. The first row must hold the column names.
  2. Record yourself filling the form once, or add a Fill form step and pick each field.
  3. Replace the values you typed with placeholders named after your columns, such as {{name}} and {{email}}.
  4. Import the CSV file, or paste the copied rows, into the scenario's data table. LoopClicker shows the columns and rows it found.
  5. End the scenario with a click on the form's submit button and a wait until the form is ready for the next entry.
  6. Run it: LoopClicker does one pass per row and stops after the last one.

Want to try it first? The test page has buttons, a click area, a form and more to practise on — nothing on it is sent anywhere.

An example

A spreadsheet with the columns name, email and plan:

name,email,plan
Ada Lovelace,ada@example.com,team
Alan Turing,alan@example.com,basic

In the scenario's Fill form step, the name field gets {{name}}, the e-mail field {{email}}, and the drop-down {{plan}} (the option's value or its visible text). A tick box takes yes/no, true/false or 1/0. Unknown placeholders become empty.

Google Sheets

No export needed: select the rows including the header row, copy, and paste them into the scenario's data table. Copied cells arrive separated by tabs; LoopClicker recognises that, as well as commas, quoted values, line breaks inside a cell and the byte-order mark Excel adds.

Practise on the test page

The form on the test page has text, e-mail, a drop-down, radio buttons, a tick box and a notes field. Every submit adds a row to a table underneath, so you can see each spreadsheet row arrive.

What it cannot do

Checked against LoopClicker on .