Importing Graph Data from Another Workbook

You can import graph data that is stored in another open Excel workbook in either matrix format or as an edge list. In either case, the other workbook must already be opened in Excel; NodeXL will not open it for you.

To import graph data from an Excel workbook that contains a matrix:
  1. In the Ribbon, select NodeXL, Data, Import, From Open Matrix Workbook.
  2. Follow the instructions in the Import from Open Matrix Workbook dialog box.
To import graph data from an Excel workbook that contains an edge list:
  1. In the Ribbon, select NodeXL, Data, Import, From Open Workbook.
  2. Follow the instructions in the Import from Open Workbook dialog box.

More Information