---
title: How Do I Import and Export Products & Services?
description: Learn how to export your Products & Services to a CSV file, edit them in bulk, and import your changes back into JobNimbus.
---

[Skip to content](https://support.jobnimbus.com/how-do-i-import-and-export-products-services#main-content)

English

Show submenu for translations

[Contact Us](https://support.jobnimbus.com/kb-tickets/new?hsLang=en)

![JN\_Logo\_Long-White@1x.png\]](https://support.jobnimbus.com/hs-fs/hubfs/JN_Logo_Long-White@1x.png?height=40&name=JN_Logo_Long-White@1x.png)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [Contact Us](https://support.jobnimbus.com/kb-tickets/new)
- [Go to the JobNimbus Toolbox](https://www.jobnimbus.com/support/)

[Go to the JobNimbus Toolbox](https://www.jobnimbus.com/support/)

 How can we help you?

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

1. [Help Center](https://support.jobnimbus.com/?hsLang=en)
2. [Financials](https://support.jobnimbus.com/financials?hsLang=en)
3. [Products and Services](https://support.jobnimbus.com/financials?hsLang=en#products-and-services)

# How Do I Import and Export Products & Services?

## Learn how to export your Products & Services to a CSV file, edit them in bulk, and import your changes back into JobNimbus.

#### On This Page

- [Exporting Your Products & Services](https://support.jobnimbus.com/how-do-i-import-and-export-products-services#exporting)
- [Editing the Products & Services CSV File](https://support.jobnimbus.com/how-do-i-import-and-export-products-services#editing)
- [Making Common Changes in the Products & Services File](https://support.jobnimbus.com/how-do-i-import-and-export-products-services#common-changes)
- [Importing Your Products & Services File](https://support.jobnimbus.com/how-do-i-import-and-export-products-services#importing)
- [Reviewing and Applying a Products & Services Import](https://support.jobnimbus.com/how-do-i-import-and-export-products-services#review-and-apply)

To add or edit one product at a time instead, check out [How Do I Add and Edit Products & Services in JobNimbus?](https://support.jobnimbus.com/how-do-i-add-and-edit-products-services-in-jobnimbus?hsLang=en)

Products & Services import and export is available on accounts by enabling it in NimbusLabs.

[Products and Services Import/Export Walkthrough Video](https://vimeo.com/1247274291/6b0d987c3f?share=copy&fl=sv&fe=ci)

 

### Exporting Your Products & Services

1. Click on your **profile icon or initials** in the top right corner. Then, select **Settings** from the dropdown menu.
2. In the **Settings** menu on the left-hand side, select **Products & Services**.
3. Select **Export**.

![](https://support.jobnimbus.com/hs-fs/hubfs/Screenshot%202026-11-10%20at%209-13-23%E2%80%AFAM-png.png?width=670&height=173&name=Screenshot%202026-11-10%20at%209-13-23%E2%80%AFAM-png.png)

Your Products & Services download as a CSV file. If you haven't searched or changed any filters, the export includes all of your visible products. Hidden products aren't included, because the **Visibility** filter is set to **Visible** by default.

![](https://support.jobnimbus.com/hs-fs/hubfs/Screenshot%202026-11-16%20at%208-34-31%E2%80%AFAM-png.png?width=330&height=370&name=Screenshot%202026-11-16%20at%208-34-31%E2%80%AFAM-png.png)

To export only some products, search your list or select **Filters** first. You can filter by **Suppliers**, **Types**, **Locations**, and **Visibility**. To include hidden products, change the **Visibility** filter. After you search or change a filter, selecting **Export** opens the **Export products** window. Choose an option, then select **Export**:

- **Filtered products**: Only the products that match your search and filters.
- **Visible products**: All visible products, ignoring your search and filters.

![](https://support.jobnimbus.com/hs-fs/hubfs/Screenshot%202026-11-16%20at%208-33-58%E2%80%AFAM-png-1.png?width=330&height=361&name=Screenshot%202026-11-16%20at%208-33-58%E2%80%AFAM-png-1.png)

You can also select **Import**, then **Export current list** in the import window. Both give you a file in the exact format the import needs.

### Editing the Products & Services CSV File

Open your Products & Services export in a spreadsheet program, such as Excel, Google Sheets, or Numbers. Each product uses at least two rows, and the **recordType** column tells them apart:

- **product**: The product row holds the name, description, tax exempt setting, visibility, and location.
- **uom**: A unit of measure row holds one unit's cost and price. A product with three units of measure has three uom rows.

A product row and its uom rows share the same ID in the **id** column. Keep each uom row directly below its product row.

![](https://support.jobnimbus.com/hs-fs/hubfs/Screenshot%202026-11-10%20at%209-34-44%E2%80%AFAM-png.png?width=670&height=67&name=Screenshot%202026-11-10%20at%209-34-44%E2%80%AFAM-png.png)

The file has these columns:

- **name** and **description**: The product's name and description, on the product row.
- **taxExempt**: TRUE if the product is tax exempt, FALSE if it isn't.
- **enabled**: TRUE shows the product in your list. FALSE hides it.
- **location**: The company location's name, as it appears in JobNimbus.
- **uomName**: The unit of measure, such as SQ or BX.
- **materialCost** and **laborCost**: What the product costs your company.
- **materialPrice** and **laborPrice**: What your customer pays.
- **materialTaxId** and **laborTaxId**: IDs that tell JobNimbus which of your existing tax options to use for the product's material and labor.
- **supplier**: The supplier the product is connected to. This column is for reference only, and changes to it aren't imported.

There's no markup column. JobNimbus works out the markup from cost and price when you import. To change a markup, change the price. On a Material product the labor columns are blank, and on a Labor product the material columns are blank.

Keep every column from the export, even ones you don't change. Save the file as a CSV. Excel (.xlsx) files can't be imported.

 

### Making Common Changes in the Products & Services File

- **Update a product**: Change the values on its rows and keep its ID the same.
- **Add a new product**: Add a product row and leave the **id** blank. Then add at least one uom row directly below it with the unit, cost, and price.
- **Add a unit of measure**: Add a uom row directly below the product row and copy in the product's ID.
- **Rename a unit of measure**: Changing the **uomName** adds a new unit to the product. The old unit stays.
- **Hide or show a product**: Set **enabled** to FALSE to hide it, or TRUE to show it.
- **Switch between Material and Labor**: Clear the cost and price for the old type and fill in the new one. The product updates in place.
  
  For example: If you would like to change a material only product to a labor only product, you must remove the material price and cost values. Setting those values to 0 will not work to remove it as a material product, only a blank value will work. If a product has values (including 0) in both the labor and material columns, the product will be a Material and Labor product.

- **Change a product's location**: This creates a new product at the new location. The original product stays at its location.

Adding labor prices to a Material product, or material prices to a Labor product, hides the original and creates a new Material and Labor product with a new ID.

 

 

### Importing Your Products & Services File

1. In the **Settings** menu on the left-hand side, select **Products & Services**.
2. Select **Import**.
3. Select **Click to upload**, or drag your CSV file into the **Import & review changes** window.
   
   ![](https://support.jobnimbus.com/hs-fs/hubfs/Screenshot%202026-11-10%20at%209-43-48%E2%80%AFAM-png.png?width=582&height=568&name=Screenshot%202026-11-10%20at%209-43-48%E2%80%AFAM-png.png)
4. Select **Upload**.
   
   ![](https://support.jobnimbus.com/hs-fs/hubfs/Screenshot%202026-11-10%20at%209-44-55%E2%80%AFAM-png.png?width=578&height=262&name=Screenshot%202026-11-10%20at%209-44-55%E2%80%AFAM-png.png)
5. Select **Done**.
   
   ![](https://support.jobnimbus.com/hs-fs/hubfs/Screenshot%202026-11-10%20at%209-47-39%E2%80%AFAM-png.png?width=581&height=180&name=Screenshot%202026-11-10%20at%209-47-39%E2%80%AFAM-png.png)

JobNimbus checks your Products & Services file in the background, and nothing changes yet. Large files can take several minutes. When the check is done, you'll get a **Product Import Analysis Ready** notification with a count of new and updated products.

 

### Reviewing and Applying a Products & Services Import

1. Select the **Notifications** bell in the top right corner.
   
   ![](https://support.jobnimbus.com/hs-fs/hubfs/Screenshot%202026-11-10%20at%209-48-53%E2%80%AFAM-png.png?width=614&height=140&name=Screenshot%202026-11-10%20at%209-48-53%E2%80%AFAM-png.png)
2. Select the **Product Import Analysis Ready** notification.
   
   ![](https://support.jobnimbus.com/hs-fs/hubfs/Screenshot%202026-11-10%20at%209-48-33%E2%80%AFAM-png.png?width=403&height=298&name=Screenshot%202026-11-10%20at%209-48-33%E2%80%AFAM-png.png)
3. Check the changes on the **Import & review changes** page.
   
   ![](https://support.jobnimbus.com/hs-fs/hubfs/Screenshot%202026-11-10%20at%209-53-26%E2%80%AFAM-png.png?width=670&height=476&name=Screenshot%202026-11-10%20at%209-53-26%E2%80%AFAM-png.png)
4. Select **Apply to (number) products**.
   
   ![](https://support.jobnimbus.com/hs-fs/hubfs/Screenshot%202026-11-10%20at%209-54-29%E2%80%AFAM-png.png?width=292&height=63&name=Screenshot%202026-11-10%20at%209-54-29%E2%80%AFAM-png.png)

The review page shows how many products will be updated and added. **Changes to Existing Products** lists only the fields that differ, with the old value crossed out next to the new one. **New Products** lists each product you're adding and labels hidden ones **Hidden**. If a change turns a product into a Material and Labor product, a warning shows at the top of the page.

Large imports are split into pages. Use **Rows per page** to show more products at once, and select **Next** or **Previous** to move between pages.

![](https://support.jobnimbus.com/hs-fs/hubfs/undefined-Nov-16-2026-04-04-02-2988-PM.png?width=670&height=255&name=undefined-Nov-16-2026-04-04-02-2988-PM.png)

Apply the import before the time shown at the top of the review page. After that, the review expires and you'll need to upload the file again. To stop without changing anything, select **Cancel**.

The import rejects any row it can't save and shows an error for that row. The rest of the file still imports. A row is rejected when it has:

- A product name over 200 characters
- A description over 10,000 characters
- A cost or price below $0 or over $1,000,000

After you apply, the **Import submitted** page confirms your changes are being saved. You'll get a notification when the import is finished. Select **Back to products** to return to your Products & Services list.

- [Learning and Training Resources](https://support.jobnimbus.com/learning-and-training-resources?hsLang=en)
- [Jobs, Contacts, and Boards](https://support.jobnimbus.com/jobs-contacts-and-boards?hsLang=en#main-content)

    - [Jobs and Contacts](https://support.jobnimbus.com/jobs-contacts-and-boards?hsLang=en#jobs-and-contacts)
    - [Boards](https://support.jobnimbus.com/jobs-contacts-and-boards?hsLang=en#boards)
    - [Documents & Photos](https://support.jobnimbus.com/jobs-contacts-and-boards?hsLang=en#documents-photos)
    - [Subcontractors as Contacts](https://support.jobnimbus.com/jobs-contacts-and-boards?hsLang=en#subcontractors-as-contacts)
    - [Communications](https://support.jobnimbus.com/jobs-contacts-and-boards?hsLang=en#communications)
    - [Photos](https://support.jobnimbus.com/jobs-contacts-and-boards?hsLang=en#photos)
- [Calendar and Tasks](https://support.jobnimbus.com/calendar-and-tasks?hsLang=en#main-content)

    - [Syncing Your Calendar](https://support.jobnimbus.com/calendar-and-tasks?hsLang=en#syncing-your-calendar)
    - [Your Calendar](https://support.jobnimbus.com/calendar-and-tasks?hsLang=en#your-calendar)
    - [Tasks](https://support.jobnimbus.com/calendar-and-tasks?hsLang=en#tasks)
    - [Record Scheduling](https://support.jobnimbus.com/calendar-and-tasks?hsLang=en#record-scheduling)
- [Financials](https://support.jobnimbus.com/financials?hsLang=en#main-content)

    - [Estimates](https://support.jobnimbus.com/financials?hsLang=en#estimates)
    - [Invoices](https://support.jobnimbus.com/financials?hsLang=en#invoices)
    - [Work Orders](https://support.jobnimbus.com/financials?hsLang=en#work-orders)
    - [Material Orders](https://support.jobnimbus.com/financials?hsLang=en#material-orders)
    - [Margin and Markup](https://support.jobnimbus.com/financials?hsLang=en#margin-and-markup)
    - [Products and Services](https://support.jobnimbus.com/financials?hsLang=en#products-and-services)
    - [Taxes](https://support.jobnimbus.com/financials?hsLang=en#taxes)
    - [Measurements](https://support.jobnimbus.com/financials?hsLang=en#measurements)
    - [Profit Tracker](https://support.jobnimbus.com/financials?hsLang=en#profit-tracker)
    - [Payments](https://support.jobnimbus.com/financials?hsLang=en#payments)
    - [Credit Memos](https://support.jobnimbus.com/financials?hsLang=en#credit-memos)
    - [Financing](https://support.jobnimbus.com/financials?hsLang=en#financing)
- [Reports](https://support.jobnimbus.com/reports?hsLang=en#main-content)

    - [Insights](https://support.jobnimbus.com/reports?hsLang=en#insights)
    - [Classic Reports](https://support.jobnimbus.com/reports?hsLang=en#classic-reports)
    - [Built-in Reports](https://support.jobnimbus.com/reports?hsLang=en#built-in-reports)
    - [Analytics](https://support.jobnimbus.com/reports?hsLang=en#analytics)
- [Settings](https://support.jobnimbus.com/settings?hsLang=en#main-content)

    - [General Settings](https://support.jobnimbus.com/settings?hsLang=en#general-settings)
    - [Company Info](https://support.jobnimbus.com/settings?hsLang=en#company-info)
    - [Team](https://support.jobnimbus.com/settings?hsLang=en#team)
    - [Groups](https://support.jobnimbus.com/settings?hsLang=en#groups)
    - [Estimate Settings](https://support.jobnimbus.com/settings?hsLang=en#estimate-settings)
    - [Workflows](https://support.jobnimbus.com/settings?hsLang=en#workflows)
    - [Templates](https://support.jobnimbus.com/settings?hsLang=en#templates)
    - [Forms](https://support.jobnimbus.com/settings?hsLang=en#forms)
    - [Subscription](https://support.jobnimbus.com/settings?hsLang=en#subscription)
    - [Mobile Settings](https://support.jobnimbus.com/settings?hsLang=en#mobile-settings)
    - [Account Switcher](https://support.jobnimbus.com/settings?hsLang=en#account-switcher)
- [Automations](https://support.jobnimbus.com/automations?hsLang=en#main-content)

    - [Event-Based Automations](https://support.jobnimbus.com/automations?hsLang=en#event-based-automations)
    - [Time-Based Automations](https://support.jobnimbus.com/automations?hsLang=en#time-based-automations)
    - [Automation Recipes](https://support.jobnimbus.com/automations?hsLang=en#automation-recipes)
- [Engage](https://support.jobnimbus.com/engage?hsLang=en#main-content)

    - [Set-Up](https://support.jobnimbus.com/engage?hsLang=en#set-up)
    - [Usage](https://support.jobnimbus.com/engage?hsLang=en#usage)
- [AssistAI](https://support.jobnimbus.com/assistai?hsLang=en)
- [JobNimbus Marketing](https://support.jobnimbus.com/jobnimbus-marketing?hsLang=en)
- [JobNimbus Payments](https://support.jobnimbus.com/jobnimbus-payments?hsLang=en#main-content)

    - [Account Set-Up](https://support.jobnimbus.com/jobnimbus-payments?hsLang=en#account-set-up)
    - [Usage](https://support.jobnimbus.com/jobnimbus-payments?hsLang=en#usage)
    - [Fees and Transactions](https://support.jobnimbus.com/jobnimbus-payments?hsLang=en#fees-and-transactions)
    - [Tracking and Reporting](https://support.jobnimbus.com/jobnimbus-payments?hsLang=en#tracking-and-reporting)
- [QuickBooks](https://support.jobnimbus.com/quickbooks?hsLang=en#main-content)

    - [General QuickBooks Info](https://support.jobnimbus.com/quickbooks?hsLang=en#general-quickbooks-info)
    - [QuickBooks Online](https://support.jobnimbus.com/quickbooks?hsLang=en#quickbooks-online)
    - [Accounting Sync](https://support.jobnimbus.com/quickbooks?hsLang=en#accounting-sync)
    - [QuickBooks Desktop](https://support.jobnimbus.com/quickbooks?hsLang=en#quickbooks-desktop)
- [Suppliers](https://support.jobnimbus.com/suppliers?hsLang=en#main-content)

    - [ABC Supply](https://support.jobnimbus.com/suppliers?hsLang=en#abc-supply)
    - [QXO](https://support.jobnimbus.com/suppliers?hsLang=en#qxo)
    - [SRS Distribution](https://support.jobnimbus.com/suppliers?hsLang=en#srs-distribution)
    - [Third-Party Suppliers](https://support.jobnimbus.com/suppliers?hsLang=en#third-party-suppliers)
- [Integrations](https://support.jobnimbus.com/integrations?hsLang=en#main-content)

    - [API](https://support.jobnimbus.com/integrations?hsLang=en#api)
    - [Angi](https://support.jobnimbus.com/integrations?hsLang=en#angi)
    - [ArcSite](https://support.jobnimbus.com/integrations?hsLang=en#arcsite)
    - [BirdEye](https://support.jobnimbus.com/integrations?hsLang=en#birdeye)
    - [CompanyCam](https://support.jobnimbus.com/integrations?hsLang=en#companycam)
    - [EagleView](https://support.jobnimbus.com/integrations?hsLang=en#eagleview)
    - [Get The Referral](https://support.jobnimbus.com/integrations?hsLang=en#get-the-referral)
    - [Global Payments](https://support.jobnimbus.com/integrations?hsLang=en#global-payments)
    - [HailTrace](https://support.jobnimbus.com/integrations?hsLang=en#hailtrace)
    - [Hover](https://support.jobnimbus.com/integrations?hsLang=en#hover)
    - [Leap](https://support.jobnimbus.com/integrations?hsLang=en#leap)
    - [mySalesman](https://support.jobnimbus.com/integrations?hsLang=en#mysalesman)
    - [naturalForms](https://support.jobnimbus.com/integrations?hsLang=en#naturalforms)
    - [Podium](https://support.jobnimbus.com/integrations?hsLang=en#podium)
    - [RoofScope](https://support.jobnimbus.com/integrations?hsLang=en#roofscope)
    - [SalesRabbit](https://support.jobnimbus.com/integrations?hsLang=en#salesrabbit)
    - [Simplii](https://support.jobnimbus.com/integrations?hsLang=en#simplii)
    - [Solo](https://support.jobnimbus.com/integrations?hsLang=en#solo)
    - [Spotio](https://support.jobnimbus.com/integrations?hsLang=en#spotio)
    - [SumoQuote](https://support.jobnimbus.com/integrations?hsLang=en#sumoquote)
    - [Sunlight Financial](https://support.jobnimbus.com/integrations?hsLang=en#sunlight-financial)
    - [Toolsey](https://support.jobnimbus.com/integrations?hsLang=en#toolsey)
    - [Wisetack](https://support.jobnimbus.com/integrations?hsLang=en#wisetack)
    - [Xactimate](https://support.jobnimbus.com/integrations?hsLang=en#xactimate)
    - [Zapier](https://support.jobnimbus.com/integrations?hsLang=en#zapier)
- [Additional Resources](https://support.jobnimbus.com/additional-resources?hsLang=en#main-content)

    - [General](https://support.jobnimbus.com/additional-resources?hsLang=en#general)
    - [Sales and Financial Information](https://support.jobnimbus.com/additional-resources?hsLang=en#sales-and-financial-information)
    - [Backing up data](https://support.jobnimbus.com/additional-resources?hsLang=en#backing-up-data)
- [App Status](https://support.jobnimbus.com/app-status?hsLang=en)
- [Suggestions](https://support.jobnimbus.com/suggestions?hsLang=en)
- [JobNimbus Legacy](https://support.jobnimbus.com/jobnimbus-legacy?hsLang=en#main-content)

    - [Legacy Estimates](https://support.jobnimbus.com/jobnimbus-legacy?hsLang=en#legacy-estimates)
    - [Legacy Invoices](https://support.jobnimbus.com/jobnimbus-legacy?hsLang=en#legacy-invoices)
    - [Legacy Material Orders](https://support.jobnimbus.com/jobnimbus-legacy?hsLang=en#legacy-material-orders)
    - [Legacy Budgets](https://support.jobnimbus.com/jobnimbus-legacy?hsLang=en#legacy-budgets)
    - [Legacy Mobile](https://support.jobnimbus.com/jobnimbus-legacy?hsLang=en#legacy-mobile)
    - [Legacy Integrations](https://support.jobnimbus.com/jobnimbus-legacy?hsLang=en#legacy-integrations)
    - [Legacy Jobs and Contacts](https://support.jobnimbus.com/jobnimbus-legacy?hsLang=en#legacy-jobs-and-contacts)
    - [Legacy Subscriptions](https://support.jobnimbus.com/jobnimbus-legacy?hsLang=en#legacy-subscriptions)
- [Analytics](https://support.jobnimbus.com/analytics?hsLang=en)

[![JN\_Logo\_Long-White@1x](https://support.jobnimbus.com/hs-fs/hubfs/JN_Logo_Long-White@1x.png?width=241&height=31&name=JN_Logo_Long-White@1x.png "JN_Logo_Long-White@1x")](http://www.jobnimbus.com)

JobNimbus Help Center

Copyright © 2025, JobNimbus