---
title: "Implementation > Import Data"
canonical: "https://technology.bytangram.com/space/TGKB/1659961345/Implementation%20%3E%20Import%20Data"
format: markdown
---
Data can be imported into your WorkBook system when an existing importer template is available. When first setting up your WorkBook system, a starting set of data will be imported, including your client information, supplier list, and employee details. To import data successfully it is important to understand the [data structures](https://tangram.atlassian.net/wiki/spaces/TGKB/pages/616235136) and the format required in the [import data sheets](https://tangram.atlassian.net/wiki/spaces/TGKB/pages/610435259). 

Things to note:

- Once your data is imported and a record has been created, all future updates need to be completed in the system, for example, you can’t overwrite existing records with a new import, so it is important to ensure accuracy and consistency prior to uploading.
- Not all fields are required at import, optional fields can be added to the system manually at a later date as required.

---

## IMPORT DATA 

Before you import data, go to:

- The **settings **module > **global system settings** > **system variables**
- Select **implementation variables** > and check that **system variable 1154** ‘enable implementation import’ is enabled

![image](media://eeac2a23-9a6a-44db-9697-583515ea33cc)


- Staying in the **settings** module go to:
- **Advanced tools** > **ad-hoc import**
- Click the **ad-hoc import** button and search or scroll through the list to select the relevant importer
- Click **ok**

> 📝 Download the latest [implementation file templates](https://tangram.atlassian.net/wiki/spaces/TGKB/pages/610435259) and see articles on the specific data requirements for implementation [here](https://tangram.atlassian.net/wiki/spaces/TGKB/pages/616235136).


![image](media://656e5544-a2a0-4a7d-8fc1-e127abb078b4)


- In the pop-up, **drop** or **choose **your complete and formatted file and click **ok**

![image](media://3d16a0ee-5c89-47fd-8f14-20555c1da51f)


- In the pop-up check **test mode** and click **ok**
  - It is important to initially import data in ‘test mode’ and the system will check the files for errors, to allow you to fix them before the final import
  - When errors exist, simply address them in the original file and repeat the steps above to re-upload and check

![image](media://787b2732-fe74-4c7e-847f-f0510a6f1162)

 

- Continue uploading in test mode until no errors are returned

![image](media://594689f1-e965-469c-a5de-4420fa1a4a4e)


- Now you are ready to import the final data file
- Leave test mode unchecked and click **ok **to import the final file

![image](media://a5ce33cf-7904-4873-85fc-3b14ecce7843)


- Once your data has been successfully imported, click **ok**
- Then navigate to the relevant WorkBook module to view the imported data

![image](media://84bb1628-35ae-46d3-b24a-8f2ab4033108)


---

### Related articles

> Macro (contentbylabel)