## NodeXL: Network Overview, Discovery and Exploration for Excel

NodeXL: Network Overview, Discovery and Exploration for Excel

From the webpage:

NodeXL is a free, open-source template for Microsoft® Excel® 2007 and 2010 that makes it easy to explore network graphs. With NodeXL, you can enter a network edge list in a worksheet, click a button and see your graph, all in the familiar environment of the Excel window.

**NodeXL Features**

**Flexible Import and Export** Import and export graphs in GraphML, Pajek, UCINet, and matrix formats.
**Direct Connections to Social Networks** Import social networks directly from Twitter, YouTube, Flickr and email, or use one of several available plug-ins to get networks from Facebook, Exchange and WWW hyperlinks.
**Zoom and Scale** Zoom into areas of interest, and scale the graph’s vertices to reduce clutter.
**Flexible Layout** Use one of several “force-directed” algorithms to lay out the graph, or drag vertices around with the mouse. Have NodeXL move all of the graph’s smaller connected components to the bottom of the graph to focus on what’s important.
**Easily Adjusted Appearance** Set the color, shape, size, label, and opacity of individual vertices by filling in worksheet cells, or let NodeXL do it for you based on vertex attributes such as degree, betweenness centrality or PageRank.
**Dynamic Filtering** Instantly hide vertices and edges using a set of sliders—hide all vertices with degree less than five, for example.
**Powerful Vertex Grouping** Group the graph’s vertices by common attributes, or have NodeXL analyze their connectedness and automatically group them into clusters. Make groups distinguishable using shapes and color, collapse them with a few clicks, or put each group in its own box within the graph. “Bundle” intergroup edges to make them more manageable.
**Graph Metric Calculations** Easily calculate degree, betweenness centrality, closeness centrality, eigenvector centrality, PageRank, clustering coefficient, graph density and more.
**Task Automation** Perform a set of repeated tasks with a single click.

Homepage for NodeXL, which uses Excel as the framework for display and exploration of graphs.

There is something to be said about software that ties itself to other successful software. I think that is “increased chances of success.” Don’t you?

This entry was posted
on Friday, March 30th, 2012 at 4:37 pm and is filed under Excel, Graphs, Networks, NodeXL.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.