How do I prepare my spreadsheet to import into my database?
First off, it is important to understand that for each import, you can perform Bulk Actions on volunteers listed in the spreadsheet.
If you want to assign your volunteer list to different opportunities, tags or shifts during the import process, you must perform separate imports. Each import should contain the list of volunteers who will be assigned to the same list of opportunities, shifts or tags.
We recommend using our template to upload your list of volunteers so that we identify potential errors before uploading the file!
Option 1: Use template (*Recommended)
1. Download the template (see attachments to this FAQ)
2. Add profile information about your volunteers. The first name, last name and email are required. All other fields are optional.
3. To help you identify any issues on the file before uploading it, the template provides conditional formatting for both the email and date of birth columns. Therefore, if any of those two field are inputted in an incorrect format, it will highlight the cell in red! Please note that for conditional formatting to show, you must use the correct paste option when copying and pasting information on the file. How do I properly use conditional formatting during the import process?
4. There is a maximum of 500 records (rows) per import
Option 2: Build a custom file
- The first row is a header and will not be counted
- There is a maximum of 500 records (rows) per import
- You must use the same order and format of columns as shown below:
- Email *mandatory (must use 'something@domain.com' format)
- First Name* *mandatory
- Last Name *mandatory
- Phone Number
- Date of Birth (Must use 'yyyy-mm-dd' format)
- Gender (Must be digits such as 0=Male, 1=Female, 2=Other, 3=Rather not say)
Ready to import your file? Read How do I upload my spreadsheet into my database?
Need help with the import process? Contact us and we'll help you format your document for the upload!
Related Articles
How do I a mass import a contact list into my database via a spreadsheet?
If you have not yet prepared your spreadsheet, read this article Steps to import your spreadsheet into your database: 1. Login to Vome and using the left-hand side navigation, click Database 2. On the top-right of the page, click Create profiles 3. ...How do I import profile pictures for users in my database?
Using Vome's import process, you will see that you can import profile images for users in bulk. It is important to note that this feature was designed to help organizations mass import profile images from another software. As such, the way you import ...Do I need to segment my user profile list before uploading it to my database?
First off, it is important to understand that for each import, you can perform Bulk Actions on user profiles listed in the spreadsheet. If you want to assign user profiles different tags, opportunities, sequences or shifts during the import process, ...How do I invite volunteers to join Vome once I have an Offline record in my database?
1. Select volunteer records from your database 2. Click on Invite volunteers 3. Click Send the invitation to selected offline volunteers or those within my filtered list. Once the volunteer signs up and accepts your invitation, they will be prompted ...How do I use a Custom ID field to find and match profiles during the import process?
*Please note this feature is only available for customers using the Enterprise Plan By default, we find and match profiles using the user's email address. In other words, it is the primary field on Vome. Here is an example to illustrate this. For ...