# How to bring your Product List data into AutoCAD

Make sure to start with:

{% content-ref url="../../design/how-to-create-a-product-list" %}
[how-to-create-a-product-list](https://help.canoa.supply/docs/design/how-to-create-a-product-list)
{% endcontent-ref %}

## **Importing your CSV** Product List **into Microsoft Excel:**

Before you can link your Product List from Canvas into your AutoCAD dwg drawing, you will need to save your Product List as a CSV and bring it into an Excel file (.xls or .xlsx).

{% content-ref url="how-to-bring-your-product-list-data-into-microsoft-excel" %}
[how-to-bring-your-product-list-data-into-microsoft-excel](https://help.canoa.supply/docs/share/how-to-download-a-product-list/how-to-bring-your-product-list-data-into-microsoft-excel)
{% endcontent-ref %}

{% content-ref url="how-to-bring-your-product-list-data-into-google-sheets" %}
[how-to-bring-your-product-list-data-into-google-sheets](https://help.canoa.supply/docs/share/how-to-download-a-product-list/how-to-bring-your-product-list-data-into-google-sheets)
{% endcontent-ref %}

## **Linking your** Product List **and AutoCAD dwg with Data Links:**

<figure><img src="https://uploads-ssl.webflow.com/6399c9f45da398ac3776f03e/6596ed227a29c3b60b9a5951_Screenshot%202024-01-04%20at%2010.37.56%20AM.png" alt=""><figcaption></figcaption></figure>

* Open your **AutoCAD DWG**.
* Run the **DATALINK** command and navigate to where your Product List Excel file is saved.
* Select your file and click **Open**.
* The **New Excel Data Link window** will open. Confirm the **File Name** and file path is correct. Select the link type and create a unique **Data Link Name**.
* You have the option of revising the cell content and formatting in AutoCAD or Excel. Checking **Keep data formats and formulas** and **Allow writing to source file** will make sure your Excel formulas are preserved
* Check **Insert Table.**

‍

<figure><img src="https://uploads-ssl.webflow.com/6399c9f45da398ac3776f03e/6596078c9d114aa687f68d73_Screenshot%202024-01-03%20at%205.47.01%20PM.png" alt=""><figcaption></figcaption></figure>

* To modify data in locked cells, right-click on the cell to open up your **Properties** manager, and select **Unlocked** from the drop-down menu under **Cell locking**.
* Remember to **Refresh Content** in your **Reference Manager** to sync the data link between your Excel file and your AutoCAD drawing.