SOURCE:    Vacation Tracker
TITLE:     How Do I Import Users Profile Data?
URL:       https://vacationtracker.io/knowledge-base/how-do-i-import-users-profile-data/
LANG:      en
PUBLISHED: 2025-08-19
UPDATED:   2026-02-13
READING:   1 min
SUMMARY:   This guide shows how Admins can import user profile data in Vacation Tracker. While basic info is auto-synced from your workspace, details like department, location, and start date can be added via a CSV/Excel template. Importing in bulk is faster and more accurate than editing each profile individually.

# How Do I Import Users Profile Data?

# How Do I Import Users Profile Data?

Bulk-update User profiles in Vacation Tracker — Department, Location, Start/End dates, Employee ID, and Birthday — by uploading a spreadsheet, instead of clicking through profiles one by one.

## What Gets Imported

Vacation Tracker pulls basic info from your workspace directory: first name, last name, and avatar. The User Profile Data import handles everything else — fields the directory doesn't carry, or fields you want to populate at scale:

- Department assignment

- Location assignment

- Employment Start Date

- Employment End Date

- Employee ID (for integration with other systems)

- Birthday

It's much faster than editing each User profile by hand — especially right after onboarding, after a reorg, or when you're cleaning up old data.

Active users only

The import page itself shows the warning "This import will only apply to active users." — inactive or deleted Users are skipped silently.

## Before You Start

You need Admin access in Vacation Tracker. Approvers and Users won't see the Bulk Uploads option in the menu.

## Steps

- Sign in at app.vacationtracker.io (https://app.vacationtracker.io/signin) as an Admin.

- In the left menu, expand Workspace Settings and click Bulk Uploads.

- On the Bulk Uploads page, click View on the User Profile Data card.

- Click Download Template to grab a file with the correct headers.

- Open the template, fill in one row per User you want to update, and save.

- Back on the User Profile Data page, click Start Import.

- Walk through the wizard: drop or select your file → Select header row → Match Columns → Validate data → Confirm.

![User Profile Data import page showing the Download Template and Start Import buttons and the warning that the import will apply only to active users](https://cms.vacationtracker.io/uploads/helpdesk_artikal_how_do_i_import_users_profile_data_first_image_place_2cb1bd03df.png)

## Fields in the Template

FieldRequiredNotes

EmailMandatoryThe match key — must match the email on file in Vacation Tracker.

DepartmentOptionalMust match an existing Department name exactly.

LocationOptionalMust match an existing Location name exactly.

Start DateOptionalEmployment start date.

End DateOptionalEmployment end date — leave blank for active Users.

Employee IDOptionalFree-text. Used for integration with other systems. If using Excel, format the cell as Text so leading zeros aren't truncated.

BirthdayOptionalFormat: YYYY-MM-DD

## The 4-Step Wizard

- User Profile Data — drop your file or click Select file. Accepts .xlsx, .xls, .csv.

- Select header row — confirm the first row of your file is the header.

- Match Columns — map your file's headers to Vacation Tracker fields. With our template, columns match automatically.

- Validate data — fix any rows the wizard flags in red, then click Confirm.

Updates only existing Users

This import does not create new Users. Existing Users matched by email get their profile fields updated — that's it. To add Users, see How Do I Add and Import Users (https://vacationtracker.io/knowledge-base/how-do-i-add-import-users/).

Excel cell formatting

If you're using Excel and your Employee IDs start with zeros, format those cells as Text before pasting in the values — otherwise Excel silently strips the leading zeros.

Run it any time

You can re-run this import as often as you want. It overwrites the listed fields with whatever's in the spreadsheet for the matching Users.

### What's Next?

Import Leave Data (https://vacationtracker.io/knowledge-base/how-can-i-import-my-leave-data-into-vacation-tracker-leave-data-import/)
Import Brought Forward Balances (https://vacationtracker.io/knowledge-base/how-do-i-import-users-initial-brought-forward-balances/)
Import TOIL (https://vacationtracker.io/knowledge-base/how-do-i-import-time-off-in-lieu-balances/)

Need help?

Contact our Support team via email (mailto:hello@vacationtracker.io) or chat (#), Monday to Friday, 9 AM – 5 PM EST.