# Import and Export Holiday Schedules with Excel - Admin Panel
> Source URL for below info: https://api1.simboconnect.com/helpb/books/simboconnect-ai-phone-copilot/page/import-and-export-holiday-schedules-with-excel-admin-panel

**Purpose:** Use Excel to add many closures at once, or to back up and share your schedule outside Phone Copilot.

### Access

<span class="s2">Open </span>**Admin**<span class="s2"> &gt; </span>**Holiday/Off-Hour Schedule**<span class="s2">.</span>

### Export the current schedule

1. <span class="s1">Select </span>**Export Holiday Schedule (Excel)**<span class="s1">.</span>
2. Save the file. It contains your existing entries.

### Prepare a file for bulk upload

1. Open the exported Excel file or your internal template.
2. Add or edit rows with the following fields:
    
    
    - <span class="s1">**Name**</span> of the holiday or off-hour.
    - **From Date Time**<span class="s1">.</span>
    - **To Date Time**<span class="s1">.</span>
3. Use the date and time format shown in your account. Keep start before end. Do not include notes in extra columns.

### Upload a holiday schedule

1. <span class="s1">Select </span>**Upload Holiday Schedule**<span class="s1">.</span>
2. Choose your Excel file.
3. Confirm the upload and wait for the success message.

<span class="s3">**Result:**</span> New rows are added. Rows that match existing items by identifier or exact values are updated, depending on your configuration.

### Maintain the schedule over time

- Use <span class="s1">**Add New**</span> for quick one-off changes.
- Use <span class="s1">**Export**</span>, edit in Excel, and <span class="s1">**Upload**</span> for many changes at once or for annual planning.

### Troubleshooting

- If the upload fails, check column headers and date formats.
- Remove blank rows and hidden sheets before uploading.
- If duplicates appear, remove the extra row in Excel and upload again, or delete the item in the table.

### Tips and good practices

- Always export before a large update so you have a backup.
- Keep a master Excel file for the year and refresh it after each change.
- Use consistent names for recurring holidays to make searches easy.
- Validate dates for national holidays once per year, then upload the full list in one step.
- After a bulk upload, scan the table for time windows that overlap by mistake.
> Source URL for above info: https://api1.simboconnect.com/helpb/books/simboconnect-ai-phone-copilot/page/import-and-export-holiday-schedules-with-excel-admin-panel