Learn how to import a list of your products and services from Excel, CSV, or Google Sheets 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, CSV, or Google Sheets and import it directly into QuickBooks. You can create a spreadsheet of your products and services in Excel, CSV, or Google Sheets. 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: Formatting tips: Now that you’ve made a spreadsheet with your products and services in Excel or Google Sheets, 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: 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. In the products/services field on your file, use the following formats: For categories only: [Name of category]:[Name of product/service] For categories and sub-categories: [Name of category]:[Name of sub-category]:[Name of product/service] Use a row for each item variation. For example: A retail business has pieces of clothing in multiple colors and sizes. Use this format: [Item]:[Size]:[Color]Format your spreadsheet
Import your products and services
Import products and services with sub-categories and sub-items
Categories and sub-categories
Product/Service name Large: T-shirt Medium: T-shirt Small: T-shirt 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 Items and sub-items
Product/Service name T-shirt T-shirt: Large: Blue T-shirt: Large: White T-shirt: Medium T-shirt: Small: Red T-shirt: Small: Yellow

Import products and services into QuickBooks Online
SOLVED•by QuickBooks•583•Updated 5 days ago
Was this helpful?
You must sign in to vote, reply, or post
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
More like this
- Create budgets in QuickBooks Onlineby QuickBooks•6568•Updated 4 days ago
- Common questions about importing data to QuickBooks Onlineby QuickBooks•642•Updated 2 weeks ago
- Import customers or vendors from email contacts to QuickBooks Onlineby QuickBooks•495•Updated 5 days ago
- Export reports, lists, and other data from QuickBooks Onlineby QuickBooks•723•Updated 7 hours ago
- Add product and service items to QuickBooks Onlineby QuickBooks•798•Updated 2 weeks ago