
In this case, the Shift Start Date was accidentally entered as 7/30, which resulted in a shift longer than 24 hours. Go to the Shifts sheet and correct the errors. Its name will end with "error".Įach line of the sheet shows the location of an error and what needs to be corrected. Open the error file from your Downloads directory. (You get to skip the next section of this article!)Ī message directing you to download an Excel error file that will help you find and fix the issues. When the import is complete you'll see one of the following:Ī message informing you that the import was successful. Select Upload file, navigate to the edited Excel file, and select Open. Go to More options at the top right of the Schedule page, and then select Import schedule. In the Shifts app, go to the page that shows the team schedule you've edited in Excel. Note: The maximum number of shifts you can import per file is 10,000. Under End date, select Generate a report compatible for import, and then select Export. Go to More options at the top right of the Schedule page, and then select Export schedule.Ĭhoose the start and end dates for the timeframe you want to work on. In the Shifts app, go to the team schedule you want to edit. This procedure creates an import-compatible Excel workbook for your edits. Export a Shifts schedule for editing in Excel If the workbook contains errors when you import it, Shifts returns it to you with the errors clearly indicated, as well as instructions for fixing them. For instructions, see "Organize shifts by group" and "Add people to the schedule" in Fill out a schedule in Shifts.

If you're starting with a blank schedule, you'll need to add people to the schedule before you export it to Excel. The exported workbook will contain the team members and their emails, and any existing shifts within the time period you choose. There are three main steps to working in Excel: export the team members and schedule from Shifts, edit the Excel workbook, and import the workbook back into Shifts. Import a Shifts schedule to the Shifts app In this articleĮxport a Shifts schedule for editing in Excel And because the members of your team are automatically added to the Excel template before you begin, assigning workers to shifts is a breeze. Entering or changing your Shifts schedule in Excel and then importing it to the Shifts app can speed your work, particularly if you manage a large team.
