Hi
In Quickbooks, File>Import>Excel Enter Excel File Name, Enter Sheet name in
dialogue box, check the Data File has header rows (assuming you have set up
column Names)
In Choose a Mapping, use the dropdown to Create New
Give it a Name e.g. Inventory
Select the Import type Customer, Supplier, Item or Account
You need Item, then map your column headings in the Excel file to the
headings in Quickbooks for as many columns as you wish to import.
Regards
Roger Govier