Skip to main content

Add holidays with excel

Login to SPARC and open HR Leave menu, You will see below screen. 

  1. Click on Holiday List button. You will see below screen.HrLeave.png
  2. Click on Download Template Excel button, An Excel file will be downloaded which will look like below.Screenshot (29).png
  3. Enter holiday date in the Holiday date[DD-MMM-yyyy] column of Excel.
  4. Enter occasion in the Ocasion column of Excel. Save this file after making all entries.Screenshot (27).png
  5. click on Upload Holiday Excel. You will see below screen.Screenshot (30).png
  6. click on Choose File button and select the Excel file you saved in step 4.
  7. Click on Upload button. All valid entries in the uploaded Excel file will be updated and an Excel file with name `Update status of uploaded data for holidays template.xlsx' will be downloaded to track failed/successful entries in the uploaded Excel file. All valid uploaded entries will appear in HR Leave screen like below.

    Screenshot (31).png


  8. AfterValid addingentries newin holidays,uploaded ColumnExcel holidayfile will appear with columns Holiday and Restricted Holiday willdeselected be(red cross.cross). To declare it'sa date in a location holiday or Restrictedrestricted holidayholiday, select (green tick) either one based on location.one. In case ifit that occasionis neither aleave both Holiday orand Restricted Holiday crossdeselected both(red of them.cross).
  9. clickClick on saveSave button to save changes you made.Screenshot (32).png

                                                                                                   - END -