/visma-net-erp/getting-started/use-system-wide-actions/import-data-from-a-local-file-to-a-table section 2026-02-19T17:09:06+01:00 # Import data from a local file to a table You can import data from an Excel spreadsheet or a CSV file to a Visma Net table when you see  (the Load records from file button) on the table toolbar. Visma Net uses the spreadsheet format introduced in Microsoft Office 2007, so if you use an earlier version of Microsoft Office, you should install the appropriate plug-in. 1. Open the appropriate window, and select the record to which you want to import data or add a new record. 1. On the table toolbar, click ****. 1. In the **File upload** dialog box, click **Choose file** and select the file you want to import. 1. Click **Upload** to upload the file to the system. After the file is uploaded, the **Common settings** dialog box is opened. 1. To import an Excel spreadsheet, do the following in the **Common settings** dialog box: 1. If an atypical null value is used in the uploaded file, specify the value in the **Null value** field. 1. In the **Culture** field, select the region whose measurement settings have been used in the uploaded file. 1. In the **Mode** field, select the option that determines which data will be imported into the table: + **Update existing**: To update the rows that are already present in the table and add new rows that are not present in the table. + **Bypass existing**: To import only new rows that were not present in the table. The existing rows will not be updated. + **Insert all records**: To add all rows from the file to the table. If you select this option, you may get duplicated rows because the system won't check for duplicates when importing rows from the file. 1. Click **OK**. 1. To import a CSV file, do the following in the **Common settings** dialog box: 1. If an atypical separator character is used in the uploaded file, specify it in the **Separator chars** field. 1. If an atypical null value is used in the uploaded file, specify the value in the **Null value** field. 1. Select the encoding of the uploaded file in the **Encoding** field. 1. In the **Culture** field, select the region whose measurement settings have been used in the uploaded file. 1. In the **Mode** field, select the option that determines which data will be imported into the table: + **Update existing**: To update the rows that are already present in the table and add new rows that are not present in the table. + **Bypass existing**: To import only new rows that were not present in the table. The existing rows will not be updated. + **Insert all records**: To add all rows from the file to the table. With a CSV file, the uploaded file must contain only rows that have not already been imported. If the system encounters a row that already exists in the table, the import process will be terminated. To resolve the situation, click , and try to import data in another mode. 1. Click **OK**. 1. In the **Columns** dialog box, match the columns of the imported file (displayed in the **Column name** column) to the columns in the Visma Net table to which you want to import data (displayed in the **Property name** column). 1. Click **OK** to import data to the table. 1. After the data is successfully imported, click **Save** in the window toolbar. After the data is imported and the document is saved, you can continue processing the document according to your organisation's work flow.