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.

 

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, Geofencing If you want the job to require a Geo-Fence, You will need to enter Yes in Column C, Enter a no otherwise. Column B is the radius of the Geo-Fence in meters, This must be a number between 100 and 2500
Columns D,E,F,G and H, Address If you are using a Geo-Fence these fields must be filled out. If you are not using a Geo-Fence then these 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 if you want to override a user's rate when they are clocked into a job.
Column K, Job Code Enter a Job code here if you need to, This is optional.

 

job-csv-template

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.

 

If you are using CSVs to input non-ASCII characters, you will be required to select Unicode encoding. Otherwise, any invalid characters will be marked with a ?.

For example, in Microsoft Excel:
  1. Click Save as...
  2. Click the drop-down menu next to File format
  3. Select CSV UTF-8 (Comma delimited) (.csv) from the drop-down menu
  4. Click Save
When editing your spreadsheet in Google Sheets, downloading the file to a .csv will automatically have the UTF-8 form.