Data Import: Importing Leave Data Using Our Template
If you’re looking to use our Import option and using our template (which you can download on the Import page) you can do so by using the following steps below.
There must be headers
The date and time format must match
Date Format: MM/DD/YY
Time Format: Single Digits 24 Hour Format 2PM is 14
The following information is mandatory:
The leave type name
The duration (dates from and to and/or time)
Is Half Day (Yes/No)
Email address of the User (same as in Vacation Tracker)
Email address of the Approver (same as in Vacation Tracker)
Please note, all imported leaves are auto approved. If you’re looking to import declined/pending/expired leaves as well, reach out to our Support team.
Additionally, the Is Half-Day column is mandatory, if left blank, we will auto-fill it as No.
Go to the online dashboard: app.vacationtracker.io
Once in the online dashboard, go to the Import option on the left-hand side menu (please note, you will only see this option if you are an Admin within Vacation Tracker).
Once on the Import page, the Import Type will default to Import Leaves type of import
You can then choose the Import Format (CSV or Excel)
Below you can click on the Download Template option and download our template. Once it’s been filled in with data, you can go back to the Import page following steps 1 through 4 and click on Import File
A pop-up will open that includes 4 steps:
Under step 1, Import Leaves, you can select the updated file
Once you select the file and add it, you will be taken to step 2, Select Header Row, (our system will select the first row by default, please make sure it’s correct before proceeding)
Once you click next, you’ll be taken to step 3, Match Columns, where you will be able to match the column headings from the file you imported with our necessary fields. Since you’re using our template, the columns should all match if there were no changes made in the meantime.
Once you’re happy with the match, click on Next and you’ll be taken to step 4, Validate Data, where you can check if there are any errors such as wrong email addresses or Leave Types that do not match. You can make changes right on that page or, you can exit the import, fix your file and start the Import again with the correct file.
If you’re happy with the data, click on Confirm and the Import will begin
You can continue using Vacation Tracker until the Import is completed. To check if the Import has been completed, simply check a user’s profile to see if the data has been entered (all Import data is entered at once).
For more information on the Import feature, please see the following article: How Can I Import My Leave Data into Vacation Tracker (Leave Data Import)?
For steps on using your own import file to import the data, please see the following steps: Data Import: Importing Leave Data Using Your Own File
Please keep in mind, any import file must satisfy the following rules:
There must be headers
The date and time format must match
Date Format: MM/DD/YY
Time Format: Single Digits 24 Hour Format 2PM is 14
The following information is mandatory:
The leave type name
The duration (dates from and to and/or time)
Is Half Day (Yes/No)
Email address of the User (same as in Vacation Tracker)
Email address of the Approver (same as in Vacation Tracker)
Please note, all imported leaves are auto approved. If you’re looking to import declined/pending/expired leaves as well, reach out to our Support team.
Additionally, the Is Half-Day column is mandatory, if left blank, we will auto-fill it as No.
Import Steps:
Go to the online dashboard: app.vacationtracker.io
Once in the online dashboard, go to the Import option on the left-hand side menu (please note, you will only see this option if you are an Admin within Vacation Tracker).
Once on the Import page, the Import Type will default to Import Leaves type of import
You can then choose the Import Format (CSV or Excel)
Below you can click on the Download Template option and download our template. Once it’s been filled in with data, you can go back to the Import page following steps 1 through 4 and click on Import File
A pop-up will open that includes 4 steps:
Under step 1, Import Leaves, you can select the updated file
Once you select the file and add it, you will be taken to step 2, Select Header Row, (our system will select the first row by default, please make sure it’s correct before proceeding)
Once you click next, you’ll be taken to step 3, Match Columns, where you will be able to match the column headings from the file you imported with our necessary fields. Since you’re using our template, the columns should all match if there were no changes made in the meantime.
Once you’re happy with the match, click on Next and you’ll be taken to step 4, Validate Data, where you can check if there are any errors such as wrong email addresses or Leave Types that do not match. You can make changes right on that page or, you can exit the import, fix your file and start the Import again with the correct file.
If you’re happy with the data, click on Confirm and the Import will begin
You can continue using Vacation Tracker until the Import is completed. To check if the Import has been completed, simply check a user’s profile to see if the data has been entered (all Import data is entered at once).
For more information on the Import feature, please see the following article: How Can I Import My Leave Data into Vacation Tracker (Leave Data Import)?
For steps on using your own import file to import the data, please see the following steps: Data Import: Importing Leave Data Using Your Own File
Updated on: 22/12/2023
Thank you!