Skip to main content
May 15, 2022
Question

Is it possible to import an excel inventory list instead of adding products one by one?

  • May 15, 2022
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

May 15, 2022

Hello there, fayaddalia-yahoo.

 

Importing a list of your product and services from Excel to QuickBooks Online is possible. Please note the format so it imports seamlessly.

 

I'll be glad to walk you through the steps on how to import the file:

 

  1. Go to Settings and select Import Data.
  2. Select Products and Services.
  3. Select Browse to upload the file from your computer. Choose the file, and then select Open.
  4. Select Next.
  5. Map your information. Your Field represents the headers on your spreadsheet. From each drop-down ▼ menu, select the one that matches a field in QuickBooks Online.
  6. Select Next.
  7. If you see some cells highlighted in red, this means the cell is invalid. Check the cell in your spreadsheet and try importing again.
  8. Select Overwrite all values for each product or service with the same name. Make sure everything looks correct because this can't be undone.
  9. Select Import.

 

You can also check this article for additional guide on importing data: Common questions about importing data to QBO.

 

I'll be around if you have additional questions importing your data into QBO.