--- 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. 2. Click the **Upload Jobs** button. ![](https://media-cdn.atlassian.com/file/6af4fccf-3e7a-4091-83f9-f5ca4ddf1d78/image/cdn?allowAnimated=true&client=dcc85285-7586-445f-adb8-0dc0a5a71bd1&collection=contentId-1073840191&height=125&max-age=2592000&mode=full-fit&source=mediaCard&token=eyJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJkY2M4NTI4NS03NTg2LTQ0NWYtYWRiOC0wZGMwYTVhNzFiZDEiLCJhY2Nlc3MiOnsidXJuOmZpbGVzdG9yZTpjb2xsZWN0aW9uOmNvbnRlbnRJZC0xMDczODQwMTkxIjpbInJlYWQiXX0sImV4cCI6MTc5MzgzMjU2OCwibmJmIjoxNzkzODI5Njg4LCJhYUlkIjoiNjQwMTQzNzg0MzA3ZTQ2YWQxNDRlZGEyIiwiaHR0cHM6Ly9pZC5hdGxhc3NpYW4uY29tL2FwcEFjY3JlZGl0ZWQiOmZhbHNlLCJhdXRoVHlwZSI6InNlc3Npb24ifQ.lNOEvUR8N2nV-a_lsFIINraFfV5Fb-j9F9owwi6FIWA&width=900#media-blob-url=true&id=6af4fccf-3e7a-4091-83f9-f5ca4ddf1d78&clientId=dcc85285-7586-445f-adb8-0dc0a5a71bd1&contextId=contentId-1073840191&collection=contentId-1073840191) ### 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. ### 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** and **invalid rows** to focus your review. 4. If some rows are invalid, you can still proceed with the valid ones by clicking **Proceed Anyway**. 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 | | --- | --- | --- |   | 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. | | **Managers** | No | Comma-separated email addresses of admins to link as managers (Layer 1 rows only). Linked managers receive **Unapproved Time Notifications** for this project. Each email must belong to an active Company Admin or Admin. If used on a non-Layer 1 row, the row will show a validation error. |       **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#main-content) - [Organisation View](https://help.jointimecloud.com/human-resources?hsLang=en#organisation-view) - [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) - [Mobile App](https://help.jointimecloud.com/mobile-app?hsLang=en#mobile-app) - [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