> For the complete documentation index, see [llms.txt](https://docs.pockethrms.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.pockethrms.com/faqs/cloud-portal/attendance/import/shift-schedule-import.md).

# Shift Schedule Import

### 1. How to add multiple shifts to an employee. For example: Mon to Fri - general shift and on Sat-Half day shift?

To assign multiple shifts to an employee, use the Bulk Shift Import option. In the import Excel sheet, update the relevant rows with the required shift details before uploading.

**Path**: Cloud Portal>Attendance>Import>Shift Schedule Import>download sample>fil in details>Map the components to excel columns>select other required details>Save Setting>Import File>Upload File

**Step 1**: Log into the cloud portal, go to the ‘Attendance’ menu, click on the ‘Import’ submenu and select the ‘Shift Schedule Import’ option.

<figure><img src="https://docs.pockethrms.com/~gitbook/image?url=https%3A%2F%2F4282324958-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MXep_PEmh8mDPVWj49x%252Fuploads%252F2Pkq6iyR9kYwv3hYvwRY%252F0.png%3Falt%3Dmedia&#x26;width=768&#x26;dpr=4&#x26;quality=100&#x26;sign=e33ca1a1&#x26;sv=2" alt=""><figcaption></figcaption></figure>

**Step 2**: Download the ‘Sample Shift Schedule Import’ template from the upper right-hand corner of the screen and prepare the sheet to upload accordingly.

<figure><img src="https://docs.pockethrms.com/~gitbook/image?url=https%3A%2F%2F4282324958-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MXep_PEmh8mDPVWj49x%252Fuploads%252FZSLZxxeeVUQ2sFaQe9xQ%252F1.png%3Falt%3Dmedia&#x26;width=768&#x26;dpr=4&#x26;quality=100&#x26;sign=a6cc7e23&#x26;sv=2" alt=""><figcaption></figcaption></figure>

**Step 3**: ‘Select Setting’ or new, select ‘Starting Ending Row’ and ‘Employee Code Column Name’ from the respective fields.

<figure><img src="https://docs.pockethrms.com/~gitbook/image?url=https%3A%2F%2F4282324958-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MXep_PEmh8mDPVWj49x%252Fuploads%252Fz8FL25oTdRUtxFrdadNz%252F2.png%3Falt%3Dmedia&#x26;width=768&#x26;dpr=4&#x26;quality=100&#x26;sign=b6020615&#x26;sv=2" alt=""><figcaption></figcaption></figure>

**Step 4**: Map the ‘Component Name’ to the ‘Excel Column’ according to the sheet to be uploaded.

<figure><img src="https://docs.pockethrms.com/~gitbook/image?url=https%3A%2F%2F4282324958-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MXep_PEmh8mDPVWj49x%252Fuploads%252FiNy1ltAolpSVbolnDREC%252F3.png%3Falt%3Dmedia&#x26;width=768&#x26;dpr=4&#x26;quality=100&#x26;sign=1fa89b45&#x26;sv=2" alt=""><figcaption></figcaption></figure>

**Step 5**: ‘Save Settings’, ‘Import Template’ in the respective field and click on the ‘Upload File’ button. The shifts will be imported accordingly.

<figure><img src="https://docs.pockethrms.com/~gitbook/image?url=https%3A%2F%2F4282324958-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MXep_PEmh8mDPVWj49x%252Fuploads%252FAwyb3W22yE0080SOZAuG%252F4.png%3Falt%3Dmedia&#x26;width=768&#x26;dpr=4&#x26;quality=100&#x26;sign=d6dcbd03&#x26;sv=2" alt=""><figcaption></figcaption></figure>

**Note**: Before you upload a file for import in the Pocket HRMS, you need [to format the columns with a date to ‘Text to Column’ in Excel](https://docs.pockethrms.com/faqs/cloud-portal#id-11.-what-to-do-if-the-system-shows-error-while-uploading-excel-file-for-import) sheet.

**Link**: <https://cloud.pockethrms.com/Attendance/Settings/AttendanceImport?import=29#>

For any queries, contact <support@pockethrms.com>

### 2. How to add shift schedule?

To assign multiple shifts to an employee, use the Bulk Shift Import option. In the import Excel sheet, update the relevant rows with the required shift details before uploading.

**Path**: Cloud Portal>Attendance>Import>Shift Schedule Import>download sample>fil in details>Map the components to excel columns>select other required details>Save Setting>Import File>Upload File

**Step 1**: Log into the cloud portal, go to the ‘Attendance’ menu, click on the ‘Import’ submenu and select the ‘Shift Schedule Import’ option.

<figure><img src="https://docs.pockethrms.com/~gitbook/image?url=https%3A%2F%2F4282324958-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MXep_PEmh8mDPVWj49x%252Fuploads%252F2Pkq6iyR9kYwv3hYvwRY%252F0.png%3Falt%3Dmedia&#x26;width=768&#x26;dpr=4&#x26;quality=100&#x26;sign=e33ca1a1&#x26;sv=2" alt=""><figcaption></figcaption></figure>

**Step 2**: Download the ‘Sample Shift Schedule Import’ template from the upper right-hand corner of the screen and prepare the sheet to upload accordingly.

<figure><img src="https://docs.pockethrms.com/~gitbook/image?url=https%3A%2F%2F4282324958-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MXep_PEmh8mDPVWj49x%252Fuploads%252FZSLZxxeeVUQ2sFaQe9xQ%252F1.png%3Falt%3Dmedia&#x26;width=768&#x26;dpr=4&#x26;quality=100&#x26;sign=a6cc7e23&#x26;sv=2" alt=""><figcaption></figcaption></figure>

**Step 3**: ‘Select Setting’ or new, select ‘Starting Ending Row’ and ‘Employee Code Column Name’ from the respective fields.

<figure><img src="https://docs.pockethrms.com/~gitbook/image?url=https%3A%2F%2F4282324958-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MXep_PEmh8mDPVWj49x%252Fuploads%252Fz8FL25oTdRUtxFrdadNz%252F2.png%3Falt%3Dmedia&#x26;width=768&#x26;dpr=4&#x26;quality=100&#x26;sign=b6020615&#x26;sv=2" alt=""><figcaption></figcaption></figure>

**Step 4**: Map the ‘Component Name’ to the ‘Excel Column’ according to the sheet to be uploaded.

<figure><img src="https://docs.pockethrms.com/~gitbook/image?url=https%3A%2F%2F4282324958-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MXep_PEmh8mDPVWj49x%252Fuploads%252FiNy1ltAolpSVbolnDREC%252F3.png%3Falt%3Dmedia&#x26;width=768&#x26;dpr=4&#x26;quality=100&#x26;sign=1fa89b45&#x26;sv=2" alt=""><figcaption></figcaption></figure>

**Step 5**: ‘Save Settings’, ‘Import Template’ in the respective field and click on the ‘Upload File’ button. The shifts will be imported accordingly.

<figure><img src="https://docs.pockethrms.com/~gitbook/image?url=https%3A%2F%2F4282324958-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MXep_PEmh8mDPVWj49x%252Fuploads%252FAwyb3W22yE0080SOZAuG%252F4.png%3Falt%3Dmedia&#x26;width=768&#x26;dpr=4&#x26;quality=100&#x26;sign=d6dcbd03&#x26;sv=2" alt=""><figcaption></figcaption></figure>

**Note**: Before you upload a file for import in the Pocket HRMS, you need [to format the columns with a date to ‘Text to Column’ in Excel](https://docs.pockethrms.com/faqs/cloud-portal#id-11.-what-to-do-if-the-system-shows-error-while-uploading-excel-file-for-import) sheet.

**Link**: <https://cloud.pockethrms.com/Attendance/Settings/AttendanceImport?import=29#>

For any queries, contact <support@pockethrms.com>
