Guide · Office and email
How to add your work schedule to Google Calendar or iPhone Calendar (shifts from a rota, a photo or a spreadsheet)
By Blink Brief · Updated · How pages are made
If your work app gives you a calendar link (When I Work calls it Calendar Sync), subscribe to it once and the shifts stay up to date. If the rota is a list, a spreadsheet or a printout, paste the shifts into the free CSV to ICS converter, check the preview (a night shift ends the next morning), press Download .ics, and import that file into Google Calendar on a computer or into Calendar on a Mac, which syncs to your iPhone. A photo or PDF of the rota goes through an AI chat first, to turn it into a table.
Short answer
- A calendar link: Google Calendar › Other calendars › From URL. iPhone: Calendar › Calendars › Add Calendar › Add Subscription Calendar.
- A list or a sheet: paste it into CSV to ICS › check › Download .ics › import it.
- A photo or PDF: ask an AI chat for a table, then CSV to ICS.
- Import into a “Work shifts” calendar, so next month you delete it and import the new rota.
If your work app has a calendar link
Many scheduling apps can publish your shifts as an iCalendar link, a web address that ends up as a calendar of its own. Look in your app’s schedule or settings for a calendar sync or export option. When I Work’s help is one example: on a computer, open My Schedule, click Calendar Sync at the top right, and copy the My Schedule link. When I Work says its link carries published shifts up to one year ahead, and that its Android app has no calendar sync.
- Google Calendar, on a computer: next to Other calendars, click Add other calendars › From URL, paste the link and click Add calendar. Google’s page says this works for a public calendar’s address, and that you can’t subscribe in the Google Calendar app on a phone.
- iPhone: in Calendar, tap the Calendars button, then Add Calendar › Add Subscription Calendar, enter the link and tap Find (Apple, iOS 27). In When I Work’s iPhone app the route is More › Calendar Sync, tap your schedule, then Subscribe.
A subscribed calendar is read-only and follows the app: When I Work says calendar apps refresh its link every few minutes to several hours, so check the app itself for a last-minute change. Treat the link like a password; anyone who has it sees your shifts. Each calendar’s steps for a link, and why a subscribed calendar can lag: add an .ics link to Google Calendar. No link? The next section makes a file from the rota.
A rota as a list or a sheet: CSV to ICS
Put one shift per row with a header row, in Excel, Google Sheets, or typed by hand. A shift calendar needs these columns (Location is optional):
| Subject | Date | Start | End | Location |
|---|---|---|---|---|
| Shift | 2026-11-16 | 07:00 | 15:00 | Store 12 |
| Shift | 2026-11-18 | 22:00 | 06:00 | Store 12 |
| Shift | 2026-11-21 | 9:00 AM | 5:30 PM | Store 12 |
- Select the cells with the header row and copy them.
- Open CSV to ICS and paste them into Paste rows from Excel, Google Sheets or an AI chat, or press Choose a .csv file.
- Check each shift in the preview: day, start and end, place. Set Time zone to where you work if this device is set to another zone.
- Press Download .ics. One file holds every shift.
Dates can be 2026-11-16, 11/16/2026 or 16.11.2026 (pick Date order if the converter can’t tell), and times 7:00, 07:00 or 7:00 AM. Headers may be in English, German, Spanish, French, Italian or Japanese. A standing shift every Monday needs one row with a Repeat weekly until column holding the last date. The rows are read in the browser tab and never uploaded; close the tab and they’re gone.
A photo or PDF of the rota: let an AI chat make the table
Google Calendar imports .ics and .csv files, not a photo or a PDF. If your rota is a printout on the staff-room wall or a PDF from your manager, give the photo or the file to an AI chat (ChatGPT, Claude or Gemini) and ask for a table with the columns above, one row per shift. Paste the table it writes into CSV to ICS: it reads a chat’s Markdown table and skips the sentences around it.
An AI can misread a date, a time or a name on a crowded rota. Compare every row of the preview with the photo before you download. The prompt to copy and the checks are in PDF or screenshot schedule to calendar.
Night shifts that end the next day
Write a night shift on the date it starts, with its real end time: 2026-11-18, 22:00, 06:00. CSV to ICS reads an end before the start as the next day, and the preview says “ends the next day” on that row. The .ics then holds a shift from 22:00 on Wednesday to 06:00 on Thursday, which your calendar shows across midnight.
A shift that runs past the next day needs an End date column: give it the day the shift ends. Tested here: the three shifts above pasted into CSV to ICS in Chromium and WebKit, the night shift written as 22:00 to 06:00 the next day, and the .ics opened in the ICS viewer with three events. The imports below weren’t tested: no Google or Apple account was signed in here.
Google Calendar: a “Work shifts” calendar
Import the shifts into a calendar of their own. Then they get their own color, you can hide them, and next month you replace them all at once. Google’s steps, in a browser on a computer (Google says new calendars can only be made there):
- Open Google Calendar. On the left, next to Other calendars, click Add other calendars › Create new calendar, name it “Work shifts” and click Create calendar.
- Click Settings at the top right, then Import & export on the left.
- Click Select file from your computer, choose the .ics file, pick “Work shifts” as the calendar, and click Import.
The shifts then show in the Google Calendar app on your phone too. The app can’t import the file itself: on a phone only, open the .ics in the ICS viewer and press Add to Google Calendar on each shift, one shift per button. More on sheets and Google: import an Excel schedule into Google Calendar.
iPhone Calendar
Apple documents a file import on a Mac, not on the iPhone. The routes that get the .ics into the iPhone’s Calendar:
- With a Mac: in Calendar on the Mac, create an iCloud calendar for the shifts, then choose File › Import, select the .ics and click Import, then choose the shifts calendar and click OK (Apple, macOS 27). An iCloud calendar syncs to the iPhone.
- With a Google account on the iPhone: import into Google Calendar on any computer, as above. The iPhone’s Calendar shows that account’s calendars.
- On the iPhone alone: open the file in the ICS viewer in Safari and add the shifts one by one with Add to Google Calendar or Add to Outlook, into an account the iPhone shows.
To make an iCloud calendar on the iPhone itself, Apple’s iOS 27 steps are: in Calendar, tap the Calendars button, then Add Calendar, and give it a name and a color. The iPhone .ics guide has each route in full, and what users report about tapping an .ics file on the phone.
Next month’s rota: delete and import again
An imported file doesn’t follow the rota: it is a copy of the shifts on the day you made it. When a new rota comes out, or a shift moves:
- Add the new shifts to the sheet, or replace the old ones, and make a new .ics with CSV to ICS.
- Delete the old calendar. In Google Calendar: Settings, click the calendar’s name on the left, then Remove calendar › Delete › Delete permanently.
- Create “Work shifts” again and import the new file.
CSV to ICS gives every event a new ID each time, so importing the new file without deleting the old calendar adds each unchanged shift a second time. Only one shift changed? Edit that event in the calendar instead. If your work app has a calendar link, that is the one route that follows changes by itself.
Questions
Can you add your work schedule to Google Calendar?
Yes. If your scheduling app gives you a calendar link, add it on a computer in Google Calendar with Other calendars › Add other calendars › From URL. If you have the rota as a list, a sheet or a photo, put the shifts into the free CSV to ICS converter, press Download .ics and import the file in Google Calendar › Settings › Import & export, on a computer.
How do I add my work schedule to my iPhone calendar?
With a calendar link from your work app, subscribe to it: in Calendar, tap the Calendars button, then Add Calendar › Add Subscription Calendar, enter the link and tap Find (Apple, iOS 27). With a file from CSV to ICS, import it on a Mac (Calendar › File › Import) into an iCloud calendar, or into Google Calendar on a computer if that Google account is on your iPhone. On the phone alone, open the file in the ICS viewer and add the shifts one by one.
Will the calendar update when my schedule changes?
A calendar link does: the calendar app checks it again from time to time (When I Work says the wait varies from several minutes to several hours by app). An imported file doesn’t: when the rota changes, delete the shifts calendar and import the new file.
Sources
- Google Calendar Help: Import events to Google Calendar: ICS and CSV files, on a computer; Settings › Import & export. Read on 10 November 2026.
- Google Calendar Help: Create a new calendar: only from a browser. Read on 10 November 2026.
- Google Calendar Help: Subscribe to someone else's calendar: From URL, for a public calendar; on a computer. Read on 10 November 2026.
- Google Calendar Help: Delete or unsubscribe from a calendar: Remove calendar › Delete › Delete permanently. Read on 10 November 2026.
- When I Work Help: Syncing your schedule to a calendar app: Calendar Sync, an iCalendar link; updated January 8, 2026. Read on 10 November 2026.
- Apple: Use multiple calendars on iPhone (iOS 27): Add Calendar, Add Subscription Calendar. Read on 10 November 2026.
- Apple: Import or export calendars on Mac (macOS 27): File › Import. Read on 10 November 2026.