Overview

Import quotes into Jobber from a CSV file to create many quotes at once, for example when you move from another platform or bring in past quotes. Each row in your file becomes one quote, with its line items, and Jobber links it to an existing client and property or creates new ones.

A quote import creates new quotes only. It can’t edit quotes that are already in Jobber, and it can’t import custom fields.

For every column you can use, and how Jobber matches quotes to clients, see Quote and invoice import columns.

Prepare your quote CSV file

Start from the sample file so your columns match what Jobber expects.

Download quote import sample file

To prepare your file:

  1. Open the sample file in a spreadsheet program, such as Excel or Google Sheets.
  2. Delete the example rows and add one row for each quote.
  3. Save the file as a CSV file with UTF-8 encoding. If you don’t see a CSV option, look under Save As, Export, or Download in the spreadsheet program’s File menu.

Keep these rules in mind:

  • Column headers: Keep the first row exactly as it is in the sample file. A renamed header might not map to the right field.
  • Row limit: A file can have up to 5,000 rows. Split a longer list into more than one file.
  • Accepted values: When a header lists options in brackets, such as Tax Method (Inclusive/Exclusive), enter only one of those options.
  • Quote numbers: Use numbers only, such as 1001. Leave the cell blank and Jobber gives the quote your next quote number.
  • Line item prices: Enter the price for one unit in each UNIT Price column.
  • Symbols: Don’t use symbol fonts, such as Wingdings or Webdings.

Add more than 10 line items to a quote

You can import up to 100 line items on each quote. The sample file has columns for 10 line items.

To add more line items to your quote CSV file:

  1. Copy the seven Line Item 10 columns and paste them after the last column.
  2. Change the number in each copied header to 11, for example Line Item 11 Name and Line Item 11 UNIT Price.
  3. Repeat for each extra line item, up to Line Item 100.

When you import, choose how many line items to import, up to 100, so it matches the columns in your file. Leave unused line item cells blank.

Import your quote CSV file

To import your quotes:

  1. Select Quotes from the side navigation, then select More Actions.
  2. Start a new quote import:
    • If you haven’t imported quotes before: Select Import Quote Data.
    • After your first quote import: Select Manage Imports, then New Import, then Import Quote Data.
  3. Read and agree to the terms and conditions, then select Begin Import.
  4. Select Upload file and choose your CSV file.
  5. Check that each column maps to the right Jobber field, then select Continue.
  6. Check how the values in each column map, such as each Quote Status, then select Continue. Choose Do Not Import for any data you want to leave out.
  7. Select the Invalid tab, then correct or delete each cell highlighted in red. The All and Valid tabs show every row and the rows that are ready to import.
  8. Select Start Import.

The import runs in the background, so you can keep working in Jobber. When it finishes, Jobber shows how many rows it imported, for example “Imported 25 of 25 rows.” Select View Imported Data to see what the import created.

Manage Imports opens the Imports page, which lists your past quote, invoice, and job imports.

Cancel or revert a quote import

To stop a quote import while it’s running, select Cancel Import, then select Confirm. Jobber deletes the import and removes any data it already imported.

To undo a quote import after it finishes:

  1. Select Quotes from the side navigation, then select More Actions.
  2. Select Manage Imports to open the Imports page.
  3. Select the import. Its Import overview opens on the Data Imports page.
  4. Select Revert Data.

Fix quote rows that don’t import

A quote number shows an error. Quote numbers can only contain numbers, so a value like Q-1001 fails. Change it to numbers only, or leave it blank to use your next quote number.

Jobber marks a cell invalid in a column with options in its header. These columns accept only the options in the brackets. Change the value to one of them, for example Unit or Percentage in Quote Discount Type (Unit/Percentage).

A row is missing required data. Jobber needs enough information to find or create the client and to build the quote. Add a Jobber Client ID, an exact client name, or the details for a new client: Client First Name or Client Company Name, Property Street 1, and at least one line item.

A row has both an existing and a new tax rate. Each quote uses one tax rate. When Jobber asks, keep one and remove the other.

A column doesn’t map to a Jobber field. The header no longer matches the sample file. Change it back to the header in the sample file, or choose the right field when you map columns.

The import created a duplicate client. Jobber couldn’t match the client details in your file to the client in Jobber, so it created a new client. Merge the duplicate clients. In future imports, use the Jobber Client ID column, or enter client names and email addresses exactly as they appear in Jobber.