The Scenario
You ran a webinar three days ago. Eight hundred people signed up. The sign-up tool dumped them into an Excel workbook — column A is email, column B is first name, column C is the timestamp.
Your onboarding sequence in Simplero is already built and waiting. The moment someone lands on the "New Students" list, it fires automatically. All you need to do is get those 800 emails onto that list.
The bad version:
- Save the worksheet as CSV, open Simplero's import tool, drag in the file, and wait for the progress bar — which completes with "12 rows skipped" and no explanation of which 12 or why.
- Go back to the workbook, try to identify the bad rows, fix them, re-export, re-import the corrected subset.
- Cross your fingers that the duplicate handling works the way you think, because the importer doesn't confirm either way.
You didn't build the webinar so you could spend the next two hours matching skipped-row counts to an exported CSV. The onboarding sequence is already late.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your data and talks to Simplero directly — no CSV export, no file drag-and-drop, no mystery skip count. Open the sidebar and ask.
Bulk-import all rows from this Excel table into Simplero list named "New Students" using the Email column as the identifier — skip blank rows
What You Get
- Status fills in as subscriptions complete — "done" for each successful row.
- Rows that fail get a distinct note (malformed email, contact already subscribed, etc.) instead of disappearing into a skip count.
- The Simplero onboarding sequence fires for each newly subscribed contact as soon as it lands on the list.
- No second import pass needed.
What If the Data Is Not Quite Ready
Some emails have extra spaces or mixed case
Subscribe every email in column A to Simplero list named "New Students" — trim whitespace and lowercase each address before the API call — write "done" or the error in column B
First name is missing for some rows
Subscribe everyone in column A to the "New Students" list and set the first name from column B where it is not blank — skip empty rows in column A, write the result to column C
The workbook has duplicate emails
Deduplicate column A by email keeping the first occurrence, then subscribe each unique address to Simplero list named "New Students" and write the status to column B
The full job: clean, dedup, subscribe, and summarize
Trim and lowercase column A, remove duplicates, subscribe each remaining email to the "New Students" Simplero list, write "done" or the error to column B, and put a count of successes versus failures in cell D1
One prompt handles cleanup and action together.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook with your webinar sign-ups. Ask SheetXAI to subscribe column A to your Simplero onboarding list and watch the status column fill in. See also: Bulk Add a Tag to Simplero Contacts and the Simplero integration overview.