--- title: How to Bulk Upload Job Items description: Bulk upload Job Items in Timecloud using CSV or Excel, validate your data before import, and review the required column format for linked jobs and geofences. --- [Skip to content](https://help.jointimecloud.com/how-to-bulk-upload-job-items#main-content) [Contact us](https://help.jointimecloud.com/kb-tickets/new?hsLang=en) [![Timecloud-Logo-600-2](https://help.jointimecloud.com/hs-fs/hubfs/Timecloud-Logo-600-2.png?width=200&height=40&name=Timecloud-Logo-600-2.png)](https://help.jointimecloud.com/?hsLang=en) Open main navigation Close main navigation - [Contact us](https://help.jointimecloud.com/kb-tickets/new) - [Go to app.jointimecloud.com](https://app.jointimecloud.com/) [Go to app.jointimecloud.com](https://app.jointimecloud.com/) Got questions? Ask away - There are no suggestions because the search field is empty. 1. [Service Portal](https://help.jointimecloud.com/?hsLang=en) 2. [Job Tracking](https://help.jointimecloud.com/job-tracking?hsLang=en) # How to Bulk Upload Job Items ## If you have many job items to add at once, the Bulk Upload feature lets you import them from a CSV or Excel file in just a few steps. --- #### **Before You Start** - You must have at least one **Job Layer** created before you can upload items. If no layers exist, the **Upload Jobs** button will be disabled. - Download your existing active jobs first (via **Download Active Jobs**) to see the expected file format. --- #### **How to Bulk Upload** 1. Navigate to **Job Tracking** from the left sidebar. ![Image 16-04-2026 at 11.46 AM](https://help.jointimecloud.com/hs-fs/hubfs/Image%2016-04-2026%20at%2011.46%20AM.jpeg?width=644&height=349&name=Image%2016-04-2026%20at%2011.46%20AM.jpeg) 2. Click the **Upload Jobs** button.   ![](blob:https://jointimecloud.atlassian.net/a63fdccb-dd54-4a0e-a23d-283eea1158f2#media-blob-url=true&id=6af4fccf-3e7a-4091-83f9-f5ca4ddf1d78&collection=contentId-1073840191&contextId=1073840191&width=1280&height=633&alt=&clientId=dcc85285-7586-445f-adb8-0dc0a5a71bd1) ### Step 1 — File Upload 1. Drag and drop your file onto the upload area, or click to browse for a file. 2. Accepted formats: **CSV** and **Excel**. Other file types will show an error. 3. If you need a template, click **Import Template** to download one with the correct columns. ![Image 16-04-2026 at 12.05 PM](https://help.jointimecloud.com/hs-fs/hubfs/Image%2016-04-2026%20at%2012.05%20PM.jpeg?width=670&height=363&name=Image%2016-04-2026%20at%2012.05%20PM.jpeg) ### Step 2 — Review 1. Timecloud validates your data and displays the results in a table. 2. Valid rows appear with a green indicator. Invalid rows show a red indicator with **error icons** — hover over an icon to see the specific issue. 3. You can toggle between viewing **valid rows**... ![Image 16-04-2026 at 12.21 PM](https://help.jointimecloud.com/hs-fs/hubfs/Image%2016-04-2026%20at%2012.21%20PM.jpeg?width=570&height=309&name=Image%2016-04-2026%20at%2012.21%20PM.jpeg) ...and **invalid rows** to focus your review. ![Image 16-04-2026 at 12.22 PM](https://help.jointimecloud.com/hs-fs/hubfs/Image%2016-04-2026%20at%2012.22%20PM.jpeg?width=570&height=309&name=Image%2016-04-2026%20at%2012.22%20PM.jpeg) 4. If some rows are invalid, you can still proceed with the valid ones by clicking **Proceed Anyway**. ![Image 16-04-2026 at 12.22 PM (1)](https://help.jointimecloud.com/hs-fs/hubfs/Image%2016-04-2026%20at%2012.22%20PM%20(1).jpeg?width=482&height=90&name=Image%2016-04-2026%20at%2012.22%20PM%20(1).jpeg) 5. Click **Confirm** to import the valid job items. ### **After Upload** A success summary shows how many items were created and whether any rows were skipped. Click **Done** to return to the Job Tracking page. --- #### **CSV Column Reference** Your file should include the following columns (in this order):   | Column | Required  | Description  | | --- | --- | --- | | **Layer Name** | Yes | The name of the job layer this item belongs to. Must match an existing layer. | | **Name** | Yes | The name of the job item. | | **Custom Code 1** | No | A reference code for internal use. | | **Custom Code 2** | No | A second reference code. | | **Expected Cost** | No | Budget amount for the job item. | | **Expected Hours** | No | Estimated hours for the job item. | | **Address** | No | Address for geofence auto-creation. | | **Parent Job Name** | No | Name of the parent job item in the layer above (for linked jobs). | | **Status (active/archive)** | No | Set to **active** or **archive**. Defaults to active if left blank. |     **Tip:** If your company uses department-based permissions or payroll integrations, additional columns may appear in the template. Download the template to see the exact format for your setup. - [Account & Security](https://help.jointimecloud.com/account-security?hsLang=en) - [Attendance & Timesheets](https://help.jointimecloud.com/attendance-timesheets?hsLang=en) - [Award Interpretation](https://help.jointimecloud.com/award-interpretation?hsLang=en) - [Biometric Scanners](https://help.jointimecloud.com/biometric-scanners?hsLang=en) - [Employees](https://help.jointimecloud.com/employees?hsLang=en) - [Forms & Checklists](https://help.jointimecloud.com/forms-checklists?hsLang=en) - [Geofencing](https://help.jointimecloud.com/geofencing?hsLang=en) - [Human Resources](https://help.jointimecloud.com/human-resources?hsLang=en) - [Integrations](https://help.jointimecloud.com/integrations?hsLang=en) - [Job Tracking](https://help.jointimecloud.com/job-tracking?hsLang=en) - [Leave Management](https://help.jointimecloud.com/leave-management?hsLang=en) - [Mobile App](https://help.jointimecloud.com/mobile-app?hsLang=en#main-content) - [Kiosk](https://help.jointimecloud.com/mobile-app?hsLang=en#kiosk) - [Payroll](https://help.jointimecloud.com/payroll?hsLang=en#main-content) - [Xero](https://help.jointimecloud.com/payroll?hsLang=en#xero) - [iPayroll](https://help.jointimecloud.com/payroll?hsLang=en#ipayroll) - [MYOB](https://help.jointimecloud.com/payroll?hsLang=en#myob) - [Smartly](https://help.jointimecloud.com/payroll?hsLang=en#smartly) - [Reporting](https://help.jointimecloud.com/reporting?hsLang=en) - [Roster](https://help.jointimecloud.com/roster?hsLang=en) - [Settings](https://help.jointimecloud.com/settings?hsLang=en) - [Shifts](https://help.jointimecloud.com/shifts?hsLang=en) - [Time Clock](https://help.jointimecloud.com/time-clock?hsLang=en) - [Dashboard](https://help.jointimecloud.com/dashboard?hsLang=en) Service Desk Copyright © 2025, Timecloud Ltd