Mass importing a contact list, step by step

How do I mass import a contact list into my database via a spreadsheet?

This is the illustrated walkthrough of a mass import, screen by screen. For the full reference, including what every column does and how duplicate profiles are handled, see How do I mass import profiles into my database?

Info
Prepare the file first. Getting the columns and formats right before you upload saves the most time. See How should I format my fields to successfully upload them to my database?

1. Open the mass importer

In the left-hand navigation click Database, then open the Create profiles button and choose Mass import.

2. Upload your file

Choose a .csv or .xlsx file. One row is one person, and you can import up to 10,000 rows per upload. First Name, Last Name and Email are required, and a row with no email address cannot be imported. Add anyone without an email with Single profile instead, selecting This profile does not have an email address.

Caution
One sheet per workbook. An Excel workbook containing more than one sheet will fail to upload. If your file has several tabs, save the one you want as its own file first.


3. Map your fields

Every column in your file has to be pointed at a Vome field before you can continue, so delete the columns you do not want to bring over rather than leaving them in.
If your column titles already match the field names in Vome, they are matched for you automatically and you only adjust the rest.


4. Check file errors

Vome validates the file and lists anything that will not import, with the row number. Nothing is imported until those are gone. Fix them in your spreadsheet and upload the corrected file from that same step, keeping the column titles identical between the two versions.

5. Customize & Assign

This step decides what happens to profiles that already exist, sets default values for fields your file has no column for, and applies bulk assignments to everyone in the import.
You can assign the whole file to:
  • Opportunities. Worth doing. People who are approved for an opportunity can start reserving shifts as soon as they claim their account. Without one, someone claiming their account lands on your organization page instead, because Vome assumes they still have to find something to sign up for.
  • Profile tags. For your own filtering and grouping. Users never see the tags on their profile, which makes them ideal for marking an imported cohort, for example a corporate or school group.
  • Shifts. Puts people straight onto a one-time or recurring set of shifts. This also approves them for whatever opportunity those shifts belong to, and they see the reservations as soon as they claim their account.
  • Sequences. Useful when the people you are importing are mid-onboarding.
  • Groups and Sites.

Info
Everything here applies to the whole file. If half your list should be assigned one way and half another, that is two imports. See Should I segment profile lists before mass importing them into my database?

6. Review & Save

The last step shows the summary and decides whether anyone is contacted.
Leave Invite all profiles to claim their Vome account off and the profiles simply appear in your database with nobody emailed. Turn it on and everyone in the file is emailed an invitation from noreply@vomenotifications.com to claim their account. You can add a custom welcome message and set whether those emails go out in English or French.

Caution
Invitations cannot be recalled. On a first migration, import quietly, check the data landed the way you expected, and invite people from the database afterwards.

    • Related Articles

    • How do I prepare my spreadsheet to import into my database?

      Most import problems are decided before you upload anything. This page covers what the file should look like. For the upload itself, see How do I mass import a contact list into my database via a spreadsheet? Decide what this file is for before you ...
    • How do I upload my spreadsheet into my database?

      This page has moved. Uploading a spreadsheet into your database is now covered in one place, with screenshots of each step. Read this instead: How do I mass import a contact list into my database via a spreadsheet? Two related articles, depending on ...
    • How do I create offline profiles in my database?

      Overview An offline profile is a record you create and maintain yourself, for somebody who does not have a Vome account. You can assign them opportunities and shifts and record their hours exactly as you would anybody else. They exist because plenty ...
    • How do I mass import profiles into my database?

      Overview The Database is where every person your organization works with lives. If you are moving to Vome from another system, or from a pile of spreadsheets, the mass importer brings that whole list in at once: you upload a file, tell Vome what each ...
    • What does the People metric represent?

      Overview The People card counts every profile in your database. This metric was previously labelled Volunteers, and then Profiles. If you are looking for either of those, People is the same card. 1. Does it only count people who are actively ...