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,Excel itbutton, An Excel file will download an excel template to feed holidays and upload.be downloaded template excelwhich will look like below screen shot.below.Screenshot (29).png
  3. typeEnter holiday date in the Holiday date[DD-MMM-yyyy] column of Excel.
  4. typeEnter occasion andin savethe Ocasion column of Excel. Save this file andafter it'smaking readyall to upload. for upload follow below screen shot.entries.Screenshot (27).png
  5. click on uploadUpload Holiday excelExcel. andYou followwill see below screen shot.screen.Screenshot (30).png
  6. click on chooseChoose fileFile button and chooseselect the templateExcel excel whichfile you saved recently.in step 4.
  7. After choosing template clickClick on uploadUpload button. and wait it will upload all holidays from templated and  will download one Status excel name -Update status of uploaded data for holidays template.xlsx to track failed/success upload. Right now on your SPARC-HR Leave screen all holidays will be visible like below screen shot.

    Screenshot (31).png


  8. After adding new holidays, Column holiday and Restricted Holiday will be cross. To declare it's  a holiday or Restricted holiday select either one based on location. In case if that occasion neither a Holiday or Restricted Holiday cross both of them.
  9. click on save to save changes you made.Screenshot (32).png

                                                                                                   - END -

Back to top