> For the complete documentation index, see [llms.txt](https://help.canoa.supply/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.canoa.supply/docs/share/how-to-download-a-product-list/how-to-bring-your-product-list-data-into-autocad.md).

# How to bring your Product List data into AutoCAD

Easily create a Product List in your Canvas mood board and bring that data into your AutoCAD dwg drawing.

Make sure to start with:

{% content-ref url="/pages/RWpLzkuromEfDYsBNVrn" %}
[How to create a Product List](/docs/design/how-to-create-a-product-list.md)
{% 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="/spaces/oXL90G447T7Arsje35d9/pages/M1KYHJTsdso6QCP2bXPV" %}
[How to bring your Product List data into Microsoft Excel](/docs/share/how-to-download-a-product-list/how-to-bring-your-product-list-data-into-microsoft-excel.md)
{% endcontent-ref %}

{% content-ref url="/pages/6e4PsWcjyeUwnU1KnOf5" %}
[How to bring your Product List data into Google Sheets](/docs/share/how-to-download-a-product-list/how-to-bring-your-product-list-data-into-google-sheets.md)
{% 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.