About Working With Part Data in Excel

You can copy and paste part data between Catalog Editor and Microsoft® Excel. Right-click a cell in Catalog Editor, click Cut or Copy, and then paste the part data into Excel for further manipulation, for use in part schedules, or for performing engineering calculations. You can also cut or copy part data from Excel and paste it into Catalog Editor. Part data can be selected by rows, columns, or individual cells by dragging the cursor over your selection.

When copying part data from Catalog Editor into Excel, you select one or more parameter values to copy, and the rows are pasted into the Excel spreadsheet in order. When copying part data from Excel into Catalog Editor, you select values from the spreadsheet, and they are pasted into the appropriate cells based on data type.

Danger: If parameter values copied from Excel are not pasted correctly into Catalog Editor, default data type values are placed in the cells instead of the copied values. The default values based on type are Integer = 0, Double = 0.00, and Boolean = False. In some cases, Catalog Editor might attempt to convert the copied value, for example, from a real number to a string.