1. Help Center
  2. Getting Started

Importing Jobs with a CSV

This article will assist you with learning how to import Jobs as a CSV.

job-csv-template

 

When importing a CSV file, please note certain fields are case-sensitive and should match template 

 

Column A, Name

The name for the job you want to appear in Timeero. Required for importing.

Columns B & C, Geofence

If you want the job to require a Geofence you will need to enter a Yes in column C, enter a No otherwise. Column B is the radius of the Geofence in meters, this must be a number between 100 and 2500.

Columns D, E, F, G and H, Address

If you are using a Geofence, these fields must be filled out. Otherwise, they are optional.

Column I, Description

Enter a description if you want users to see it, this is optional.

Column J, Rate

Enter an hourly rate here if you want it to override a user's rate when they are clocked into this job.

Column K, Job Code

Enter a job code here if you need to, this is optional.

 

Once you have filled out as many jobs as you want to import, save the CSV and then click the Upload CSV button on the sidebar. You will then be prompted to match your CSV columns with the correlating field in Timeero. You can click the Map Common Fields button and it will try to match columns that have exact name matches, otherwise pick from the drop down menu. Fields marked with an * symbol are required fields. 

map-job-import

Once done, click on Start Import. Depending on how many rows you filled out, it may take a little bit of time for all of the jobs to import to your account. 

 

By default, track mileage will be turned on. You can turn it off after import if it is not required.