Import products and services into QuickBooks Online

Once on Batch-import products & services:

1. Select Import from file.
2. Select Download our sample csv and open the file.

Formatting tips:

• Avoid special characters.
• Character limits:
  • Product/service name: 512
  • Category: 100
  • Sales description/Purchase description: 4000
  • Item/Service code: 100
• Quantity as of date: Format like this: MM/DD/YYYY
• Income account and Expense account: You can't use subaccounts.
• Category: [Name of category]:[Name of sub-category] up to four levels.
  • Example - Clothing:Jackets or Clothing:Shirts

Import your products and services

Now that you’ve made a spreadsheet with your products and services, you’re ready to import them to QuickBooks. Keep in mind that once you import a list, it can't be undone. And you can only import 1,000 rows at a time. If your list is longer than that, split it up into multiple, smaller files.

Here’s how to import your file:

1. Sign in to QuickBooks Online.
2. Go to Settings ⚙, then select Import data.
3. Select Products and Services.
4. Here, you can manually enter your product data, or copy and paste from your spreadsheet. To import, select Import from file.
5. To upload an Excel or CSV file, select Browse to upload the file from your computer. Choose the file, and then select Open.
6. Select Next.
7. Map your information. Column Headers From File represents the headers on your spreadsheet. From each dropdown ▼, select the one that matches a field in QuickBooks Online.
   Note: Make sure you select the correct date format.
8. Select Next.
9. If you see some cells highlighted in red, this means the values entered in the cell are not correct. Check the cell in your spreadsheet and try importing again. Read the error message and make the correction. Or, you can edit your CSV or Excel file and upload it again.
10. (Optional) Select Check this box to overwrite details of existing items with the same name and category to replace details of existing items in your account. Make sure everything looks correct because this can't be undone.
11. Select Save.

You can create a spreadsheet of your products and services in CSV. Our sample file shows you how to format your spreadsheet so it imports correctly. Here's how to download the sample file and formatting tips:

Once on Batch-import products & services:

1. Select Import CSV.
2. Select Download this sample template and open the file.

Formatting tips:

• Product/service name: 512 character limit. Avoid special characters. See the approved characters list for more info.
• Income account: You can't use subaccounts.
• Quantity as of date: Format like this: MM/DD/YYYY or DD/MM/YYYY
• Expense account: You can't use subaccounts.

Import your products and services

Now that you’ve made a spreadsheet with your products and services in CSV, you’re ready to import them to QuickBooks. Keep in mind that once you import a list, it can't be undone. And you can only import 1,000 rows at a time. If your list is longer than that, split it up into multiple, smaller files.

Here’s how to import your file:

1. Sign in to QuickBooks Online.
2. Go to Settings ⚙ and select Import data.
3. Select Products and Services.
4. Here, you can manually enter your product data, or copy and paste it from your spreadsheet. To import, select Import CSV.
5. To upload a CSV file, select Browse to upload the file from your computer. Choose the file, and then select Open.
6. Select Next.
7. Map your information. CSV column headers represents the headers on your spreadsheet. From each dropdown ▼ menu, select the one that matches a field in QuickBooks Online.
8. Select Next.
9. If you see some cells highlighted in red, this means the values entered in the cell are not correct. Check the cell in your spreadsheet and try importing again.
10. Select Check this box to overwrite details of existing items with the same name and category to replace details of existing items in your account. Make sure everything looks correct because this can't be undone.
11. Select Save.