Auto filling form using randomly fields (not lines) picked from CSV

Hello, I am very new to this. I need to fill a website form from a CSV file.
the CSV file contains data with the same order as the form
I need to pick RANDOM fields data each time i play the macro (not a random line)
(for example)
CSV format is: First Name, Last Name, Job title, salary
Michael, Berry, Analyst, 2800
Daniel, Brown, Sales Manager, 4100
John, Doe, IT Specialist, 3500

What i need is that, each time run the macro “Filling form”, it will pick a random First name (Let’s say John), a random Last Name (for example, Berry), a Random job tile (Analyst) and a random Salary (4100)

Any Ideas? Thanks in advance

This will be easy. I can create such a macro for you.

Just to clarify: Do you want to

  • pick just a random row (e. g. John, Doe, IT Specialist, 3500)
  • or randomly mix values from all rows in the CSV, e. g. John, Berry, Sales Manager, 2800?

Alternatively if you just need random values of any kind you can use the LLM command aiPrompt with a prompt like

Generate a genuinely random person profile with the following details:
* First name (avoid common examples like John/Jane)
* Last name (avoid common examples like Doe/Smith)
* Job title (avoid defaults like Software Engineer but only reasonable titles)
* Monthly salary in USD (numerical value only, between 2,000-15,000)
Format as a single comma-separated line with no explanations or additional text

Result is for example

Lucinda,Trevino,Urban Sustainability Coordinator,8240

1 Like