Can I import Inventory with Quantity on Hand from Excel Spreadsheet in new QuickBooks Online?

YES, you can import Inventory with Quantity on Hand from Excel Spreadsheet.

Import from Excel spreadsheet (see attached sample spreadsheet format below)

  • GO the Company Gear (located at upper right hand corner)
  • Select “Import Data” under Tools heading
  • Select “Product and Services”
  • Click “Choose File” button to import
  • Follow the instructions

I would recommend importing few inventory items first and review it.

Import Inventory List from Excel
Import Inventory List from Excel