# How to bring your Product List data into AutoCAD

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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.canoa.supply/docs/share/how-to-download-a-product-list/how-to-bring-your-product-list-data-into-autocad.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.