Imports bring data from a spreadsheet or another event platform into a Soventro event. Use them to keep a past event's history, or to rebuild an event's setup so you can run it again next year.
Imports never email, charge, refund, invoice, book rooms, call webhooks or update your CRM.
Open Setup → Imports. Owners, Admins and Event managers can import. Payment and invoice files also need a role that can record payments, such as Owner, Admin or Finance.
Choose what the import is for
Under New import, choose What is it for?:
- Historical archive: a past event's people, registrations with their status and answers, and payment history kept as a record. Nothing can be charged, refunded or emailed from it. This is only available for an event that has ended. Create the past event with its real dates first, then import into it.
- Rebuild the setup: attendee types with their prices, and sessions with their speakers, as editable setup you can check and use again.
Upload the files
- Give the import a Name for this import.
- Choose Where the files come from: Spreadsheet or other platform, Cvent export or Swoogo export. The Cvent and Swoogo choices fill in suggested column matches for you to check.
- Add your files, as described below.
- Select Upload and review.
For a Historical archive:
- Registrations (required): one row per registration with email, name, status and attendee type, plus any answers.
- People: names, companies and titles, matched to registrations by email or person ID.
- Payments and refunds, Check-ins, Hotel stays and Invoices: all kept as history only.
To Rebuild the setup:
- Registrations: optional, used only for attendee types and their prices. No people or registrations are created.
- Sessions: title, start and end, with room, track, format and speakers.
Files can be CSV (comma, semicolon or tab separated) or Excel (.xlsx), with column names in the first row. From a workbook only the first worksheet is read. Each file can be up to 10 MB and 20,000 rows, and 25 MB in all. Formulas are never run. Old .xls files, password-protected workbooks and workbooks with macros aren't accepted.
Nothing is saved to the event yet.
Match columns and values
For each file, you see each column with sample values. Choose the Soventro field it goes into, or Keep, don't import into a field to keep it with the record without using it. Select Save mapping.
To reuse your choices next time, enter a name under Save this mapping for next time and select Save mapping as. Saved mappings are shared with your team, and you can pick one under Use a saved mapping.
Then, under Values and choices:
- Statuses: for each status word in the file, choose what it becomes in Soventro.
- Attendee types: use one of this event's types, or create one. Created types start switched off, with an empty form.
- Dates like 03/04/2025 mean: Month first or Day first.
- Someone already registered here in Soventro: Leave theirs alone and list it as a conflict, or Fill in blanks only, and keep their status. An import never adds a second registration for the same person.
Select Save choices.
Check, then import
- Under Check before importing, select Check without importing. The dry run reads every row against your existing people and registrations and saves nothing. It lists problems and duplicates.
- Fix what you need, and select Check again if anything changed.
- Select Import [number] rows.
The import runs in the background in batches. You can leave the page; if it stops, it carries on from where it was, or you can select Retry. When it's done, Imported shows what was created, with links.
Imported registrations keep their status and answers. Payments, check-ins, hotel stays and invoices are kept as history on each registration, marked as imported. They don't count in Reconciliation, and nothing is charged or refunded.
Roll back an import
On a finished import, the Roll back card lists what it would remove and which earlier values it would put back. Type ROLL BACK and select Roll back this import.
A rollback removes everything the import created and restores records it only updated. People who already existed stay.
If something now depends on the imported records, the card says Can't be rolled back now with the reasons, for example a later import changed them, imported people have since signed in, or records were edited in Soventro.
Next year's event
After an import, the Next year's event card offers Create next year's event from this import. You see what carries over exactly and what's only a suggestion, then preview and create a draft, as with cloning.