Skip to content

Import, export & backup

The app can move data in and out in a few ways. Export, Print, and Download backup are available to everyone (including viewers). Importing and Restoring change data, so they're for editors/admins.

Schedule — Excel (.xlsx)

On the Schedule screen:

  • Export downloads the year as an Excel file that keeps the original sheet's behavior (dropdowns and the auto-filled phone/email columns).
  • Import replaces a year's schedule from an Excel file you upload. Holiday weeks are recognized from the Holidays settings on import, so the exact way the file marks them doesn't matter.
  • Print produces a clean printable view of the schedule.

Warning

Importing a schedule replaces that entire year. The app saves a snapshot first, so you can Restore from History if needed.

Holidays & Time Off — CSV

On the Holidays and Time Off screens:

  • Export downloads the current list as a CSV (opens in Excel or Google Sheets).
  • Import loads a CSV. When data already exists, you'll be asked how to handle it:
    • Overwrite everything — replace the whole list with the file, or
    • Add new & update changed — keep what's there, add new rows, update changed ones, and skip identical rows.

Time Off CSV uses names

The Time Off CSV matches people by name. Any name that doesn't match someone in the Roster is reported and skipped, so check the summary after importing.

Full backup & restore (JSON)

On the Schedule screen:

  • Download backup saves everything — roster, holidays, time off, and every year's full schedule — into a single JSON file. Keep these somewhere safe; it's your safety net.
  • Restore backup loads such a file back in.

Restore overwrites

Restoring a backup overwrites each year's schedule (and the other data) with what's in the file. Only restore a backup you trust, and consider downloading a fresh backup first.

A good routine

A simple habit that prevents most "oh no" moments: download a full backup before any big change (a fresh Generate, a large import, or a restore). It takes seconds and the file is your undo of last resort.