Capital™ How to copy a list of parts to an Excel spreadsheet

Capital Capital Component Manager


The export/import format for parts is .xml but sometimes a librarian likes to check data content using Excel spreadsheets. This is possible by a simple copy/paste action.


This is an example of how to copy all the existing wire parts.

  1. Open Component Maintenance (CM) and have a blank Excel spreadsheet ready

  2. On the bottom panel of the CM window, select Group Name: Wire and click on the Search button       

  3. This will populate the top panel with the results of the search query

  4. Select any row on the top panel and press Ctrl+A to select all rows. They should all highlight in blue:

  5. Press Ctrl+C to copy all rows

  6. In your Excel spreadsheet, do a Ctrl+V and it should paste all the rows

KB Article ID# KB000122343_EN_US



Associated Components

Capital Library