1. Help Center
  2. Events, Shifts & Scheduling

Importing Shifts

*Some UI may have changed since recording this instructional video, however the core functionality has remained the same.
Image assets below are current. 

The import feature allows you to save time and effort by importing a list of shifts straight into an Event. 

You can find templates for a fresh import sheet from within the Shifts view of your Event via Actions > Shift Import.

Simply select 'Create' for a new item, and select your preferred highlighted Excel or CSV file format.

Screen Shot 2022-04-19 at 11.03.32 am


File Requirements

Our importer has a specific set of validation rules that must be met to successfully complete the import of your file.

Supported file types: .xls, .xlsx, .csv (comma delimited)

Minimum fields required to import shifts

Column Name Required Data Type for Import Example Note
name Text Drink Station Enter the title of your shift in this column.

Time stamp: Must be date and time
yyyy/mm/dd hh:mm:ss am/pm

dd/mm/yyyy hh:mm:ss am/pm

2020/04/13 07:00:00 See Tip below

Time stamp: Must be date and time

yyyy/mm/dd hh:mm:ss am/pm

dd/mm/yyyy hh:mm:ss am/pm

2020/04/13 03:00:00 See Tip below
max_demand Positive number 10

Enter the number of people required to work this shift in this column.

Tip: Format all your cells in excel with the below Custom Number format to ensure they meet the required timestamp rules.

Copy the appropriate format below for when formatting your cell(s):

yyyy/mm/dd hh:mm:ss am/pm

dd/mm/yyyy hh:mm:ss am/pm


Other fields available to import*:

You can import any event shift attribute or custom event shift attribute. Simply find the attribute's code and use it as a heading in the column.  For example:

Column Name Required Data Type Example
address:street_address_1 Number or Text 123 Smith Street
address:city Text  New York City
address:postcode Number or Text 12343
address:country  2 character country code 

AU - Australia
US - United States
GB - Great Britain 

*these fields can be updated within Rosterfy at a later time if required. 

Ready to Import
When your file is ready to be imported, find your file and select CREATE only from the action list.

Training - Shift Import Steps


You will then see a sample of your file appear. Double check that your column headers are mapped correctly or chose to ignore a column. You can also select a column header to see all appropriate fields should the correct field not automatically populate.

For best results, ensure there are no blank columns on your sheet.

Screen Shot 2022-04-19 at 11.17.40 am

Once you are comfortable with the Import Mapping stage, you can select Process from the bottom left. You will see progress for the import display, as well as receive an email once complete. 

Should any error(s) occur, the emailed report will detail any errors, as well as give an indicator about what caused the error(s).

If you require further assistance with your imports, please submit a support request and include the import file if possible.