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:

How to create a Product List

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).

How to bring your Product List data into Microsoft ExcelHow to bring your Product List data into Google Sheets

Linking your Product List and AutoCAD dwg with Data Links:

• 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.

‍

• 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.