Import products and services into QuickBooks Online
by Intuit•1• Updated 1 month ago
Learn how to import a list of your products and services from Excel or CSV to QuickBooks Online.
Importing a spreadsheet of your products and services into QuickBooks can save you time. We’ll show you how to format your spreadsheet in Excel or CSV and import it directly into QuickBooks.
Format your spreadsheet
You can create a spreadsheet of your products and services in Excel or 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:
- Sign in to QuickBooks Online.
- Select Settings , then select Import data.
- Select Products and Services.
- Select Download a sample file and open the file.
Formatting tips:
- Product/Service Name: 100 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
- Income and 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 Excel or 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:
- Sign in to QuickBooks Online.
- Go to Settings and select Import data.
- Select Products and Services.
- To upload an Excel or CSV file, select Browse to upload the file from your computer. Choose the file, and then select Open.
- Select Next.
- Map your information. Your Field represents the headers on your spreadsheet. From each dropdown ▼ menu, select the one that matches a field in QuickBooks Online.
- Select Next.
- If you see some cells highlighted in red, this means the cell is invalid. Check the cell in your spreadsheet and try importing again.
- Select Overwrite all values for each product or service with the identical name to replace details of existing items in your account. Make sure everything looks correct because this can't be undone.
- Select Import.
Import products and services with sub-categories
If you use sub-categories, you need to format your spreadsheet a specific way so your list imports correctly. The sample spreadsheet includes a couple of examples you can reference.
Categories and sub-categories
In the products/services field on your file, use the following formats:
For categories only: [Name of category]:[Name of product/service]
Product/Service name |
Large: T-shirt |
Medium: T-shirt |
Small: T-shirt |
For categories and sub-categories: [Name of category]:[Name of sub-category]:[Name of product/service]
Product/Service name |
Large: Red: T-shirt |
Large: Yellow: T-shirt |
Medium: Red: T-shirt |
Medium: Yellow: T-shirt |
Small: Red :T-shirt |
Small: Yellow: T-shirt |
Here are other articles our customers find useful on importing data:
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this
- Add product and service items to QuickBooks Onlineby QuickBooks•7•Updated 1 month ago
- Import data from other software into QuickBooks Onlineby QuickBooks•41•Updated August 23, 2024
- Common questions about importing data to QuickBooks Onlineby QuickBooks•6•Updated May 30, 2024
- Remove a product or service in QuickBooks Onlineby QuickBooks•Updated 1 month ago