
Import products and services into QuickBooks Online
by Intuit•462• Updated 3 weeks ago
For a better experience, open this article in QuickBooks Online. Launch side-by-side view
If you're interested in support any time, any day, consider upgrading to QuickBooks Online Advanced.
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.
Learn which batch import version you have
We are currently rolling out a new batch import feature. Do the following to see which version your account has right now:
- Sign in to QuickBooks Online.
- Select Settings ⚙, then select Import data.
- Select Products and Services.
- If you have the new version, you’ll see a Batch-import screen with a spreadsheet layout. Go to Import your spreadsheet using the new batch import.
- If you have the old version, you’ll see an option to upload either a CSV and Excel file, or a Google sheet. Go to Import your spreadsheet using the old batch import.
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
- Common questions about importing data to QuickBooks Onlineby QuickBooks
- Create sales receipts in QuickBooks Onlineby QuickBooks
- Remove a product or service in QuickBooks Onlineby QuickBooks