To import a physical inventory count of Q type items using a spreadsheet, complete the following steps:

1. Download the physical inventory count template here and save the file locally.
2. Modify the data in the template as required.
3. Go to Inventory > Physical Inventory Count, then open the physical inventory count.
4. Click the extended menu icon and select Import Inventory Count.
5. Select the file you downloaded and modified, then click OK. The data displays in the form.
6. Click Save.