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

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

2 Likes