---
title: Data Import Services In ServiceBox
description: Overview of file types, requirements, and steps for importing external client data into ServiceBox.
---

[Skip to content](https://learn.getservicebox.com/data-import-services-in-servicebox#main-content)

English

Show submenu for translations

[![ServiceBox Workmark OrangeGradient](https://learn.getservicebox.com/hs-fs/hubfs/ServiceBox%20Workmark%20OrangeGradient.png?width=225&height=57&name=ServiceBox%20Workmark%20OrangeGradient.png)](https://learn.getservicebox.com/knowledge-base?hsLang=en)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations

 How can we help you?

- There are no suggestions because the search field is empty.

1. [ServiceBox Support Knowledge Base](https://learn.getservicebox.com/?hsLang=en)
2. [Data Services](https://learn.getservicebox.com/data-services?hsLang=en)
3. [FAQ](https://learn.getservicebox.com/data-services?hsLang=en#faq)

# Data Import Services In ServiceBox

## Overview of file types, requirements, and steps for importing external client data into ServiceBox.

### Understanding Data Import Services

Data import refers to the process of transferring information from external sources into a system or software application for various purposes such as analysis, storage, or manipulation. This involves extracting, transforming, and loading data from different formats or repositories into a central location to facilitate data-driven processes like analytics and integration.

ServiceBox provides many options for importing data, including self-service tools such as accounting connectors and spreadsheet uploads.

We offer the ability to import client data via Excel or CSV files. The following datasets can be imported:

- Customer Data
- Jobsites linked to Customers
- Historical Work Orders with associated Customer and Jobsite data
- Inventory Items
- Non-Inventory Items
- Unit Import

We also offer a **data import service**, where our team works directly with your files to evaluate and process the data. We'll provide a quote based on the complexity, and once approved, we’ll complete the import on your behalf.

### What's Needed for the Data Import Process?

We require files in Excel or CSV format to evaluate your data and determine complexity. Don’t worry about duplicates—ServiceBox automatically eliminates them. All files go through processing steps such as **deduplication, analysis, correction, and cleansing** before being integrated into ServiceBox.

Here’s what we need:

- **Customer File:** Includes customer details like Name, Display Name, Address, Phone, Email, etc.
- **Jobsite File:** Contains data about jobsites linked to customers. It’s important that each jobsite can be connected to a customer.
- **Work Order Data File:** Includes historical work orders and their associated information.
- **Inventory File:** Product data such as names, quantities, and prices.
- **Non-Inventory File:** Information about service-type items (used in quotes), including descriptions and pricing.
- **Unit Export File:** Contains data related to technicians, equipment, and job issues. Includes fields like Jobsite Display Name, Customer Display Name, Technician Name, Description, Location, Make, Model, Serial Number, and Replacement Item.

### Customizing Columns in ServiceBox

If your source files contain columns that aren’t available in ServiceBox, we can create **custom columns** to support your data.

> *Example:* If a client needs a “Previous Work Order #” field, we can add a custom column labeled “Historical WO#” to store this data.

**Important:** All custom column requests must be submitted before the data import begins to ensure proper integration and accuracy.

### How Does the Data Import Process Work?

1. Provide all required files to your ServiceBox representative. We recommend Excel or CSV format.
2. Our database team analyzes the files to assess structure and complexity.
3. Based on this analysis, we prepare a time and effort estimate and generate a quote.
4. Once the quote is approved, the data import process will begin.

 

**Need Help?**

If you have any questions or need support, please click the **Help** button in your ServiceBox account or email us at **support@getservicebox.com**.

- [Video Learning](https://learn.getservicebox.com/video-learning?hsLang=en#main-content)

    - [Accounting Integrations](https://learn.getservicebox.com/video-learning?hsLang=en#accounting-integrations)
- [FAQs](https://learn.getservicebox.com/faqs?hsLang=en)
- [Getting started](https://learn.getservicebox.com/getting-started?hsLang=en#main-content)

    - [User Guides](https://learn.getservicebox.com/getting-started?hsLang=en#user-guides)
- [ServiceBox Mobile](https://learn.getservicebox.com/servicebox-mobile?hsLang=en#main-content)

    - [Getting Started](https://learn.getservicebox.com/servicebox-mobile?hsLang=en#getting-started)
    - [User Guide Technician](https://learn.getservicebox.com/servicebox-mobile?hsLang=en#user-guide-technician)
    - [User Guide Admin](https://learn.getservicebox.com/servicebox-mobile?hsLang=en#user-guide-admin)
    - [FAQ](https://learn.getservicebox.com/servicebox-mobile?hsLang=en#faq)
    - [New Release](https://learn.getservicebox.com/servicebox-mobile?hsLang=en#new-release)
- [Invoices](https://learn.getservicebox.com/invoices?hsLang=en#main-content)

    - [Getting Started](https://learn.getservicebox.com/invoices?hsLang=en#getting-started)
    - [Advanced Functionality](https://learn.getservicebox.com/invoices?hsLang=en#advanced-functionality)
    - [User Guide](https://learn.getservicebox.com/invoices?hsLang=en#user-guide)
    - [FAQ](https://learn.getservicebox.com/invoices?hsLang=en#faq)
- [Quotes](https://learn.getservicebox.com/quotes?hsLang=en#main-content)

    - [Getting Started](https://learn.getservicebox.com/quotes?hsLang=en#getting-started)
    - [User Guide](https://learn.getservicebox.com/quotes?hsLang=en#user-guide)
    - [Advanced Functionality](https://learn.getservicebox.com/quotes?hsLang=en#advanced-functionality)
    - [FAQ](https://learn.getservicebox.com/quotes?hsLang=en#faq)
- [Work Orders](https://learn.getservicebox.com/work-orders?hsLang=en#main-content)

    - [Getting Started](https://learn.getservicebox.com/work-orders?hsLang=en#getting-started)
    - [User Guide](https://learn.getservicebox.com/work-orders?hsLang=en#user-guide)
    - [Advanced Functionalities](https://learn.getservicebox.com/work-orders?hsLang=en#advanced-functionalities)
    - [Work Order - FAQ](https://learn.getservicebox.com/work-orders?hsLang=en#work-order-faq)
- [Job Sites](https://learn.getservicebox.com/job-sites?hsLang=en#main-content)

    - [User Guide](https://learn.getservicebox.com/job-sites?hsLang=en#user-guide)
    - [Advanced Functionality](https://learn.getservicebox.com/job-sites?hsLang=en#advanced-functionality)
    - [FAQ](https://learn.getservicebox.com/job-sites?hsLang=en#faq)
- [Recurring Work](https://learn.getservicebox.com/recurring-work?hsLang=en#main-content)

    - [User Guide](https://learn.getservicebox.com/recurring-work?hsLang=en#user-guide)
    - [FAQ](https://learn.getservicebox.com/recurring-work?hsLang=en#faq)
- [Scheduler](https://learn.getservicebox.com/scheduler?hsLang=en#main-content)

    - [User Guide](https://learn.getservicebox.com/scheduler?hsLang=en#user-guide)
    - [Advanced Functionality](https://learn.getservicebox.com/scheduler?hsLang=en#advanced-functionality)
    - [FAQ](https://learn.getservicebox.com/scheduler?hsLang=en#faq)
- [Timesheets](https://learn.getservicebox.com/timesheets?hsLang=en#main-content)

    - [User Guide](https://learn.getservicebox.com/timesheets?hsLang=en#user-guide)
    - [Advanced Functionality](https://learn.getservicebox.com/timesheets?hsLang=en#advanced-functionality)
    - [FAQ](https://learn.getservicebox.com/timesheets?hsLang=en#faq)
- [Inventory](https://learn.getservicebox.com/inventory?hsLang=en#main-content)

    - [User Guides](https://learn.getservicebox.com/inventory?hsLang=en#user-guides)
    - [FAQ](https://learn.getservicebox.com/inventory?hsLang=en#faq)
- [Vendor Orders](https://learn.getservicebox.com/vendor-orders?hsLang=en#main-content)

    - [Getting Started](https://learn.getservicebox.com/vendor-orders?hsLang=en#getting-started)
    - [Advanced Functionality](https://learn.getservicebox.com/vendor-orders?hsLang=en#advanced-functionality)
    - [User Guide](https://learn.getservicebox.com/vendor-orders?hsLang=en#user-guide)
    - [FAQ](https://learn.getservicebox.com/vendor-orders?hsLang=en#faq)
- [Reporting](https://learn.getservicebox.com/reporting?hsLang=en#main-content)

    - [Getting Started](https://learn.getservicebox.com/reporting?hsLang=en#getting-started)
    - [FAQ](https://learn.getservicebox.com/reporting?hsLang=en#faq)
    - [User Guide](https://learn.getservicebox.com/reporting?hsLang=en#user-guide)
- [Integrations](https://learn.getservicebox.com/integrations?hsLang=en#main-content)

    - [Accounting Connector](https://learn.getservicebox.com/integrations?hsLang=en#accounting-connector)
    - [ServiceBox Payments](https://learn.getservicebox.com/integrations?hsLang=en#servicebox-payments)
- [Product Updates](https://learn.getservicebox.com/product-updates?hsLang=en)
- [Data Services](https://learn.getservicebox.com/data-services?hsLang=en#main-content)

    - [FAQ](https://learn.getservicebox.com/data-services?hsLang=en#faq)
- [QuickBooks Desktop](https://learn.getservicebox.com/quickbooks-desktop?hsLang=en#main-content)

    - [User Guide](https://learn.getservicebox.com/quickbooks-desktop?hsLang=en#user-guide)
    - [Getting Started](https://learn.getservicebox.com/quickbooks-desktop?hsLang=en#getting-started)
    - [FAQ](https://learn.getservicebox.com/quickbooks-desktop?hsLang=en#faq)
- [QuickBooks Online](https://learn.getservicebox.com/quickbooks-online?hsLang=en#main-content)

    - [Getting Started](https://learn.getservicebox.com/quickbooks-online?hsLang=en#getting-started)
    - [User Guide](https://learn.getservicebox.com/quickbooks-online?hsLang=en#user-guide)
    - [FAQ](https://learn.getservicebox.com/quickbooks-online?hsLang=en#faq)
- [Printing](https://learn.getservicebox.com/printing?hsLang=en)
- [Sage 50 (Canada)](https://learn.getservicebox.com/sage-50-canada?hsLang=en#main-content)

    - [Configuration](https://learn.getservicebox.com/sage-50-canada?hsLang=en#configuration)
    - [FAQ](https://learn.getservicebox.com/sage-50-canada?hsLang=en#faq)
    - [User Guide](https://learn.getservicebox.com/sage-50-canada?hsLang=en#user-guide)
- [First Steps for ServiceBox Users](https://learn.getservicebox.com/first-steps-for-servicebox-users?hsLang=en#main-content)

    - [User Guide](https://learn.getservicebox.com/first-steps-for-servicebox-users?hsLang=en#user-guide)
    - [FAQ](https://learn.getservicebox.com/first-steps-for-servicebox-users?hsLang=en#faq)
- [Configuring Your ServiceBox Site](https://learn.getservicebox.com/configuring-your-servicebox-site?hsLang=en#main-content)

    - [Getting Started](https://learn.getservicebox.com/configuring-your-servicebox-site?hsLang=en#getting-started)
    - [User Guides](https://learn.getservicebox.com/configuring-your-servicebox-site?hsLang=en#user-guides)
    - [FAQ](https://learn.getservicebox.com/configuring-your-servicebox-site?hsLang=en#faq)
    - [Advanced Functionality](https://learn.getservicebox.com/configuring-your-servicebox-site?hsLang=en#advanced-functionality)
- [Customer](https://learn.getservicebox.com/customer?hsLang=en#main-content)

    - [User Guide](https://learn.getservicebox.com/customer?hsLang=en#user-guide)
    - [Advanced Functionality](https://learn.getservicebox.com/customer?hsLang=en#advanced-functionality)
    - [FAQ](https://learn.getservicebox.com/customer?hsLang=en#faq)
- [Notes](https://learn.getservicebox.com/notes?hsLang=en)
- [To Dos](https://learn.getservicebox.com/to-dos?hsLang=en#main-content)

    - [Getting Started](https://learn.getservicebox.com/to-dos?hsLang=en#getting-started)
    - [To Dos - User Guide](https://learn.getservicebox.com/to-dos?hsLang=en#to-dos-user-guide)
- [Vendor](https://learn.getservicebox.com/vendor?hsLang=en#main-content)

    - [User Guide](https://learn.getservicebox.com/vendor?hsLang=en#user-guide)

[![sblogo-whiteandtransparent120x30\[8666\]](https://learn.getservicebox.com/hs-fs/hubfs/sblogo-whiteandtransparent120x30%5B8666%5D.png?width=120&height=30&name=sblogo-whiteandtransparent120x30%5B8666%5D.png "sblogo-whiteandtransparent120x30[8666]")](https://learn.getservicebox.com/knowledge-base?hsLang=en)

 

<https://www.facebook.com/getservicebox/> <https://x.com/getservicebox> <https://www.instagram.com/getservicebox/?hl=en> <https://www.youtube.com/@JobboxSoftware> <https://www.linkedin.com/company/getservicebox/>

Copyright © 2026