Import count data from Excel
/visma-net-erp/help/inventory/manage-stocktaking-counts/import-count-data-from-excel
section
In the Stocktaking review window, you can import count data from Excel spreadsheets (.xlsx files).
2026-02-19T17:09:06+01:00
# Import count data from Excel
In the Stocktaking review window, you can import count data from Excel spreadsheets (.xlsx files).
## Preparation
Review the Excel spreadsheets with the count results and correct any errors in the counted quantities.
## The import count data process
1. Go to the [Stocktaking review (IN305000)](/visma-net-erp/help/inventory/inventory-windows/stocktaking-review-in305000/) window.
1. In the **Ref. no.** field, select the count you are participating in. It has the status **Counting in progress**.
1. On the **Stocktaking details** tab, click .
1. In the **File upload** dialog box, click **Select file**. Browse to the file with your count results and select it.
1. Click **Upload**. The **Common settings** dialog box is displayed.
1. In the **Culture** drop-down list, select the language of the file.
1. In the **Mode** drop-down list, select **Update existing**.
1. Click **OK**. The **Columns** dialog box is displayed.
1. Map each column from the file to a column in the window, as follows:
+ In the **Column name** column, select a column in the uploaded file.
+ In the **Property name** column, select a column to update from the columns available.
1. Click **OK**.
1. Review the values in the **Physical quantity** and **Variance quantity** columns.
1. Click .
> [!NOTE]
> The data import can take some time. A spinning wheel icon in the toolbar shows that the import is in progress. When this changes to a green check mark icon, the import is completed successfully.
Related pages
Concepts
Tasks
Windows