---
title: "Import count data from Excel"
description: "In the Stocktaking review window, you can import count data from Excel spreadsheets (.xlsx files)."
lang: en
languages:
  en: https://docs.vismasoftware.no/visma-net-erp/help/inventory/manage-stocktaking-counts/import-count-data-from-excel/index.md
lastmod: 2026-02-23
---

> Documentation index: https://docs.vismasoftware.no/visma-net-erp/help/inventory/manage-stocktaking-counts/llms.txt


# Import count data from Excel

Last modified February 23, 2026

> 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)](https://docs.vismasoftware.no/visma-net-erp/help/inventory/inventory-windows/stocktaking-review-in305000/index.md) 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 ![icon-load-from-file](https://docs.vismasoftware.no/media/visma-net-erp/icon-load-from-file.png).
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 ![icon-save](https://docs.vismasoftware.no/media/visma-net-erp/icon-save.png).

> [!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.

<h2>Related pages</h2><h3>Concepts</h3>
<ul><li><a href="/visma-net-erp/help/inventory/manage-stocktaking-counts/about-stocktaking/index.md">About stocktaking</a></li>
</ul><h3>Tasks</h3>
<ul><li><a href="/visma-net-erp/help/inventory/manage-stocktaking-counts/complete-a-stocktaking-count/index.md">Complete a stocktaking count</a></li><li><a href="/visma-net-erp/help/inventory/manage-stocktaking-counts/view-and-correct-imported-count-data/index.md">View and correct imported count data</a></li>
</ul><h3>Windows</h3>
<ul><li><a href="/visma-net-erp/help/inventory/inventory-windows/stocktaking-review-in305000/index.md">Stocktaking review (IN305000)</a></li><li><a href="/visma-net-erp/help/inventory/inventory-windows/prepare-stocktaking-in504000/index.md">Prepare stocktaking (IN504000)</a></li><li><a href="/visma-net-erp/help/inventory/inventory-windows/stocktaking-count-in305010/index.md">Stocktaking count (IN305010)</a></li>
</ul>


---

[View this page](https://docs.vismasoftware.no/visma-net-erp/help/inventory/manage-stocktaking-counts/import-count-data-from-excel/)