Importing shifts into your schedule

How do I import shifts into my schedule?

Overview

Importing shifts adds them to your schedule in bulk from a spreadsheet, instead of creating them one at a time. One row becomes one shift.
One file can hold shifts for one opportunity or many. Opportunities, categories and locations in your file that do not exist yet can be created during the import, so a whole season can go in at once.
You can also put people on the shifts straight from the file, and keep your schedule in step with another system by giving each shift its own Shift ID.

Info
Plan required: putting people on shifts with the Attendees column needs the Pro plan or higher, and the Site column is on the Enterprise and Ultimate plans. On other plans those columns are left out and the shifts still import.

1. Where do I find the shift importer?

Go to your Schedule, open Actions in the top right, and choose Import shifts.
It opens as a full-page wizard. Any admin whose role lets them manage opportunities can import shifts into the opportunities they manage.

2. What are the steps?

  • Instructions. What the file needs, and the template download.
  • Upload file. Your spreadsheet.
  • Match your file. Where each opportunity, category and location in your file goes, and who each attendee is.
  • Edit details & settings. The settings every shift in the import shares.
  • Review & save. What the import will do, a preview, and the Publish button.

3. What does my spreadsheet need to look like?

Upload a .xlsx or .csv file of up to 10,000 rows. The first row is your column titles, and every row after that is one shift.
Four columns are required:
  • Date
  • Start time
  • End time
  • Number of spots (Spots works too)
The rest are optional:
  • Opportunity, and Category when two opportunities share a name.
  • Title and Description, per shift.
  • Location, Address, Unit, Meeting place and Location ID, for where the shift happens.
  • Minimum time, which makes the shift a flexible time slot.
  • Timezone, an IANA name such as America/Toronto.
  • Attendees, the people to put on the shift.
  • Shift ID and Status, to update or cancel shifts you imported before.
  • Site, to link what the import creates to one of your sites.
Column titles can be in English or in French (Heure de début, Lieu, Fuseau horaire and so on), and the order does not matter. The template on the Instructions step is the easiest way to get them right, but your own Excel or CSV file works as long as the four required columns are there.
If your workbook has several sheets, Vome uses the first one whose header row has all four required columns.

4. Which formats can I use?

  • Dates. YYYY-MM-DD is the safest. Slash dates, written-out months such as March 4, 2026, and Excel date cells are also read.
  • Times. Either 09:00 or 9:00 AM.
  • Number of spots. A number, so 6 rather than six.
  • Minimum time. Minutes (15, 30.5) or a duration (00:15, 1:00).
  • Timezone. Set per row, so one file can hold shifts in several timezones. A row without one uses your own timezone.

Caution
Check your slash dates. Vome reads the whole Date column to work out whether 03/04/2026 means 3 April or 4 March, and a single date such as 25/04/2026 settles it. If every date in the file could be read either way, they are read month first and the Upload step tells you so. If yours are written day first, rewrite the column as YYYY-MM-DD and upload again.

5. Can one file hold shifts for several opportunities?

Yes. Add an Opportunity column with the opportunity's name on each row.
On Match your file, every name Vome is sure of is matched for you. For the others you choose: match it to an opportunity you have, create it, or send its shifts to the default opportunity with Use default.
If two of your opportunities share a name, add a Category column so Vome can tell them apart.
No Opportunity column? Then you pick one Default opportunity on Match your file, and every shift goes there.

6. What happens to the opportunities and categories the import creates?

  • Each new opportunity goes in the category named on its rows. A category you do not have yet can be created too, or sent to a Default category.
  • You choose a Coordinator for the new opportunities.
  • They start private, with chat off and applications closed, at the address of their first shift. Change any of it on the opportunity afterwards, one at a time or several at once.
  • Publish the new opportunities is on by default, so users can see them as soon as the import ends. Turn it off to save them as drafts.
  • Creating 100 or more opportunities or categories in one import asks you to confirm first.

7. How do locations work?

Give each shift its place with a Location column (the name of a saved location), an Address column, or both. Unit and Meeting place add detail to an address, and Location ID points at one saved location exactly.
On Match your file, saved locations are matched for you, and new addresses are checked with Google and saved as new shift locations. For anything Vome cannot place, choose a saved location, add one with New location, or use the opportunity's address.
A row with no location uses the Location you pick on Edit details & settings, or the opportunity's address.

8. What about overnight shifts?

They work, and you do not have to do anything special. If the end time is earlier than the start time, for example 22:00 to 02:00, Vome reads it as an overnight shift that ends the next day.

9. How do I put people on shifts from my file?

Add an Attendees column and list the people for each shift by email, or by first and last name, separated by commas or semicolons. Numbered columns such as Attendee 1 and Attendee 2 work too.
On Match your file, each person is matched to a profile in your Database. Matches Vome is sure of are set for you. A close spelling comes up as a Did you mean suggestion, a name shared by several profiles asks you to choose one, and anyone not found can be searched for or left off.
A person is left off, and the shift still imports, when:
  • the row names more people than the shift has spots (whoever does not fit is left off),
  • the shift is full or they have time off then,
  • the shift belongs to a new opportunity saved as a draft. Turn on Publish the new opportunities to assign them.
After the import, a message tells you how many people were left off, so you can open those shifts and add them by hand.
Notify users about their upcoming reservations, on the Review & save step, emails the people from your file about their new reservations, with your own message if you add one. It is off by default.

10. How do I keep my schedule in step with another system?

Give each shift your own ID in a Shift ID column (Drive ID, External ID and Reference ID are read the same way). Then import the file again whenever the other system changes:
  • A Shift ID already on your schedule updates that shift to match the row: date, times, location, number of spots, title and description. People booked on it keep their place, and their reminders follow the new time.
  • A shift that already matches its row is left as it is.
  • A Shift ID you have not imported before creates a new shift.
Updating is controlled by Update shifts that already exist on the Review & save step. It is on by default. Turn it off to leave your existing shifts alone and only add new ones.
Good to know:
  • A Shift ID can be on one row only. Repeats are left out and listed.
  • IDs match whatever their capital letters, up to 100 characters.
  • A column titled just ID, Ref or Reference is not read as a Shift ID, because files often number their rows that way.
  • The first time you import IDs, a shift already on your schedule with the same opportunity, date, times, location and title takes the row's ID instead of being created twice.
  • Leave Title or Description blank to keep what the shift already has. The fallback title and description on Edit details & settings never fill a row with a Shift ID.
  • A row with a Minimum time makes the shift flexible with that minimum. A row without one never changes the shift's type.
  • A row cannot lower a shift's spots below the number of people booked on it, and cannot move a shift whose ID is already used in another opportunity. Those rows are left out and named on the Review & save step.

11. How do I cancel a shift from my file?

Add a Status column and write Cancelled on the row. When you import, the shift with that row's Shift ID is cancelled. Any other Status value imports the shift as active, so a file that already has a Status column of its own keeps working.
A Cancelled row needs its Shift ID, or it is left out. A Cancelled row that matches no shift on your schedule changes nothing, and the Review & save step counts it. If that Shift ID later comes back on an active row, a new shift is created.

Caution
Cancelling tells people. Everyone booked on a shift you cancel this way is told it was cancelled. Check the number of cancellations on the Review & save step before you publish.

12. How do sites work in an import?

Add a Site column with the name of one of your sites. The opportunities and categories the import creates are linked to that site. A name that is not one of your organization's sites is left off, and the Upload file step lists it.
If you are a site admin, everything the import creates is linked to your own sites, so it stays visible to you. Sites in your file that are not yours are left off, and your own sites are used instead.

13. What comes from my file, and what applies to the whole import?

These come from each row:
  • Date, start time and end time.
  • Number of spots.
  • Opportunity, title, description and location, where you filled them in.
  • Minimum time.
  • Attendees, Shift ID, Status and Site.
These are set once on Edit details & settings and apply to every shift in the import. Load shift template fills them from a saved template.
  • Coordinators and watchers.
  • Shift tags.
  • Waitlist policy and notification policy.
  • Group reservation policy and form submission policy.
  • Reservation restrictions using profile tags.
The title, description and location on that step are a fallback, not an override. They only fill the shifts whose rows left them blank, so the detail in your spreadsheet is never overwritten. Rows with a Shift ID keep their own title and description.

14. What if my file repeats a shift I already have?

Skip rows already on your schedule or repeated in the file is on by default. A row repeats another when it has the same opportunity, date, times, location and title, so importing the same file twice does not double your schedule. Turn it off only to create identical shifts on purpose.
Rows with a Shift ID follow the Shift ID rules above instead.

15. What does the review step show me?

This import will lists everything that is about to happen: shifts, opportunities, categories and locations to create, shifts to update or cancel, shifts already up to date, spots reserved for people in your file, rows skipped as repeats, and rows left out.
Below it, Admin view and End user view preview the shifts the way they will appear. It is worth checking a few dates there against your file before you publish.

16. Do users get notified about the new shifts?

Only if you turn it on. The toggle is Notify eligible users about newly published upcoming shifts, it starts off, and it covers upcoming shifts only, so filling in a past schedule never emails anyone.
People you put on shifts from the Attendees column are emailed only if you turn on Notify users about their upcoming reservations. People booked on a shift your file cancels are always told.

17. What happens with a large file?

A file with more than 300 shifts, or more than 50 locations, runs in the background. You can leave the page, and you get an email when it is done.

18. Why will my file, or some of its rows, not import?

  • The file could not be read. It is not a real .csv or .xlsx, or it is password protected. Save it again and retry.
  • Missing required columns. Date, Start time, End time or Number of spots is not there. Check the spelling in the first row.
  • More than 10,000 rows. Split the file and import the parts one at a time.
  • The Date column mixes day-first and month-first dates. Rewrite it as YYYY-MM-DD.
  • Rows that cannot be read (a missing date or time, spots that are not a number, an unknown timezone) are left out and listed by row number on the Upload file step. The rest of the file still imports.
  • Rows left out for their Shift ID or Status (an ID on two rows, a Cancelled row with no ID) and rows that cannot be applied are listed by row number on the Review & save step. After the import, a warning says how many rows were not applied.
  • The import stopped. Fix the rows it lists and import again. Anything already created is reused, not duplicated.
If the attendees could not be added after your shifts were imported, import the same file again to add them.
Still stuck? Submit a ticket, or email support@vomevolunteer.zohodesk.com with your file attached.

Summary

  • Schedule, Actions, then Import shifts.
  • One row per shift, up to 10,000 rows, in .xlsx or .csv, with column titles in English or French.
  • Required: Date, Start time, End time, Number of spots.
  • One file can cover many opportunities, and missing opportunities, categories and locations can be created along the way.
  • Write dates as YYYY-MM-DD when in doubt.
  • Rows already on your schedule are skipped, so importing the same file twice is safe.
  • Attendees puts people on shifts (Pro plan or higher). Site links what you create to a site (Enterprise and Ultimate).
  • A Shift ID keeps your schedule in step with another system: the same ID again updates the shift, and a Status of Cancelled cancels it and tells the people booked on it.
  • Nobody is notified about new shifts unless you turn the toggle on.