NodeXL

NodeXL
Developer(s)	Social Media Research Foundation
Initial release	July 2008; 16 years ago
Stable release	1.0.1.238 / 8 April 2013; 11 years ago
Written in	C#, .NET Framework
Operating system	Windows
Size	7.8 MB
Available in	English
Type	Data analysis, Data visualization
License	Microsoft Public License
Website	nodexlgraphgallery.org

NodeXL is a network analysis and visualization software package for Microsoft Excel 2007/2010/2013/2016.^[2]^[3] The package is similar to other network visualization tools such as Pajek, UCINet, and Gephi.^[4] It is widely applied in ring, mapping of vertex and edge, and customizable visual attributes and tags. It enables researchers to undertake social network analysis work metrics such as centrality, degree, and clustering, as well as see relational data and describe the overall relational network structure. When it was applied to Twitter data analysis, it showed the total network of all users participating in public discussion and its internal structure through data mining. It permits social Network analysis (SNA) to emphasize the relationships rather than the isolated individuals or organizations, allowing interested parties to investigate the two-way dialogue between organizations and the public. SNA also provides a flexible measurement system and parameter selection to confirm the influential nodes in the network, such as in-degree and out-degree centrality.^[5] The software contains network visualization, social network analysis features, access to social media network data importers, advanced network metrics, and automation.

Codebase

NodeXL is a set of prebuilt class libraries using a custom Windows Presentation Foundation control.^[6] Additional .NET assemblies can be developed as "plug-ins" to import data from outside data providers. Currently-implemented data providers for NodeXL include YouTube, Twitter, Wikipedia (the MediaWiki understructure), web hyperlinks, Microsoft Exchange Server.^[7]

Contributors

NodeXL is a collaborative effort of a number of individuals from different universities and other organizations forming the NodeXL Team. Notable contributors include:^[8]

Microsoft Research established a NodeXL research project on November 20, 2008.^[9]

Features

NodeXL is intended for users with little or no programming experience to allow them to collect, analyze, and visualize a variety of networks.^[10] NodeXL integrates into Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365 and opens as a workbook with a variety of worksheets containing the elements of a graph structure such as edges and nodes. NodeXL can also import a variety of graph formats such as edgelists, adjacency matrices, GraphML, UCINet .dl, and Pajek .net.

Data import

NodeXL Pro imports UCINet and GraphML files, as well as Excel spreadsheets containing edge lists or adjacency matrices, into NodeXL workbooks. NodeXL Pro also allows for quick collection of social media data via a set of import tools which can collect network data from e-mail, Twitter, YouTube, and Flickr. NodeXL requests the user's permission before collecting any personal data and focuses on the collection of publicly available data, such as Twitter statuses and follows relationships for users who have made their accounts public. These features allow NodeXL users to instantly get working on relevant social media data and integrate aspects of social media data collection and analysis into one tool.

Data representation

NodeXL workbooks contain four worksheets: Edges, Vertices, Groups, and Overall Metrics. The relevant data about entities in the graph and relationships between them are located in the appropriate worksheet in row format. For example, the edges worksheet contains a minimum of two columns, and each row has a minimum of two elements corresponding to the two vertices that make up an edge in the graph. Graph metrics and edge and vertex visual properties appear as additional columns in the respective worksheets. This representation allows the user to leverage the Excel spreadsheet to quickly edit existing node properties and to generate new ones, for instance by applying Excel formulas to existing columns.

Graph analysis

NodeXL Pro contains a library of commonly used graph metrics: centrality, clustering coefficient, diameter. NodeXL differentiates between directed and undirected networks. NodeXL Pro implements a variety of community detection algorithms to allow the user to automatically discover clusters in their social networks.

Graph visualization

NodeXL generates an interactive canvas for visualizing graphs. The project allows users to pick from several well-known Force-directed graph drawing layout algorithms such as Fruchterman-Reingold and Harel-Koren. NodeXL allows the user to multi-select, drag and drop nodes on the canvas and to manually edit their visual properties (size, color, and opacity). In addition, NodeXL allows users to map the visual properties of nodes and edges to metrics it calculates, and in general to any column in the edges and vertices worksheet.

Research

NodeXL has been used by news outlets like Foreign Policy to visualize the structure of conversations about political topics as well as organizations like the World Bank to analyze voting data.^[11]^[12]^[13] NodeXL has been used as an analytical tool in dozens^{[n 1]} of research papers in the social, information, and computer sciences as well as the focus of research in human–computer interaction, data mining, and data visualization.^[15]^[16]^[17]^[18]

Notes

^ 585 references^[14]

References

^ Change History, Social Media Research Foundation
^ Smith, Marc A.; Shneiderman, Ben; Milic-Frayling, Natasa; Rorigues, Eduarda; Barash, Vladimir; Dunne, Cody; Capone, Tony; Perer, Adam; Gleave, Eric (2009), "Analyzing (social media) networks with NodeXL", Proceedings of the Fourth International Conference on Communities and Technologies, ACM: 255–264, CiteSeerX 10.1.1.147.5521, doi:10.1145/1556460.1556497, ISBN 978-1-60558-713-4, S2CID 207173208
^ Hansen, Derek L.; Shneiderman, Ben; Smith, Marc (2010), Analyzing social media networks with NodeXL: Insights from a Connected World, Morgan Kaufmann, ISBN 9780123822291
^ Marin, Alexandra; Wellman, Barry (2011), "Social network analysis: An Introduction", The Sage Handbook of Social Network Analysis, London, UK: Sage, pp. 11–25, ISBN 9781847873958, ...social network analysts have developed a number of software applications to analyze social network data. The most commonly used are: Pajek, UCINet, MultiNet, Siena, P*/ERGM, R, and NodeXL
^ Yao, Q. et al (2021) Construction Safety Knowledge Sharing on Twitter: A Social Network Analysis, Safety Science, 143, 105411, https://www.researchgate.net/publication/353546913_Safety_knowledge_sharing_on_Twitter_A_social_network_analysis
^ For Programmers: About NodeXL Graph Data Providers, Social Media Research Foundation, retrieved May 13, 2013
^ Third-Party Graph Data Importers, Social Media Research Foundation, retrieved May 13, 2013
^ "NodeXL: Network Overview, Discovery and Exploration for Excel - Home". Archived from the original on 2018-01-20. Retrieved 2020-12-13.
^ NodeXL: Network Overview, Discovery and Exploration in Excel - Microsoft Research
^ Bonsignore, E.M.; Dunne, Cody; Rotman, D.; Smith, M.; Capone, T.; Hansen, D.L.; Shneiderman, B. (2009), "First Steps to Netviz Nirvana: Evaluating Social Network Analysis with NodeXL" (PDF), International Conference on Computational Science and Engineering: 332–339, CiteSeerX 10.1.1.296.6307, doi:10.1109/CSE.2009.120, ISBN 978-1-4244-5334-4, S2CID 1080217
^ Allnutt, Luke (April 11, 2012), "Pictures at a Revolution", Foreign Policy, retrieved May 13, 2013
^ "Visualizing the War on Women", Foreign Policy, June 18, 2012
^ Moeller, Susan (November 18, 2009), You Know and Use Web 2.0 Tools. What About Those of Science 2.0?, The World Bank, retrieved May 13, 2013
^ Google Scholar - "nodexl network", retrieved May 13, 2013
^ Dunne, Cody; Shneiderman, Ben (2013), "Motif Simplication: Improving Network Visualization Readability with Fan, Connector, and Clique Glyphs" (PDF), Proceedings of the SIGCHI Conference on Human Factors in Computing Systems, ACM: 3247, doi:10.1145/2470654.2466444, ISBN 978-1-4503-1899-0, S2CID 15321464
^ Shneiderman, Ben; Dunne, Cody (2012), "Interactive network exploration to derive insights: filtering, clustering, grouping, and simplification" (PDF), Proceedings of the 20th International Conference on Graph Drawing, Lecture Notes in Computer Science, 7704: 2, doi:10.1007/978-3-642-36763-2_2, ISBN 978-3-642-36762-5
^ Mendes Rodrigues, Eduarda; Milic-Frayling, Natasa; Smith, Marc; Shneiderman, Ben; Hansen, Derek (2011), "Group-In-a-Box Layout for Multi-faceted Analysis of Communities", Proceedings of the 3rd IEEE International Conference on Social Computing, IEEE: 354, CiteSeerX 10.1.1.296.6410, doi:10.1109/PASSAT/SocialCom.2011.139, ISBN 978-1-4577-1931-8, S2CID 6265697
^ Himelboim, Itai; McCreery, Stephen; Smith, Marc (2013-01-01). "Birds of a Feather Tweet Together: Integrating Network and Content Analyses to Examine Cross-Ideology Exposure on Twitter". Journal of Computer-Mediated Communication. 18 (2): 40–60. doi:10.1111/jcc4.12001. ISSN 1083-6101.

External links

Resources

[15] 585 references^[14]

[1] Change History, Social Media Research Foundation

[smith2009-2] Smith, Marc A.; Shneiderman, Ben; Milic-Frayling, Natasa; Rorigues, Eduarda; Barash, Vladimir; Dunne, Cody; Capone, Tony; Perer, Adam; Gleave, Eric (2009), "Analyzing (social media) networks with NodeXL", Proceedings of the Fourth International Conference on Communities and Technologies, ACM: 255–264, CiteSeerX 10.1.1.147.5521, doi:10.1145/1556460.1556497, ISBN 978-1-60558-713-4, S2CID 207173208

[hansen2010-3] Hansen, Derek L.; Shneiderman, Ben; Smith, Marc (2010), Analyzing social media networks with NodeXL: Insights from a Connected World, Morgan Kaufmann, ISBN 9780123822291

[4] Marin, Alexandra; Wellman, Barry (2011), "Social network analysis: An Introduction", The Sage Handbook of Social Network Analysis, London, UK: Sage, pp. 11–25, ISBN 9781847873958, ...social network analysts have developed a number of software applications to analyze social network data. The most commonly used are: Pajek, UCINet, MultiNet, Siena, P*/ERGM, R, and NodeXL

[5] Yao, Q. et al (2021) Construction Safety Knowledge Sharing on Twitter: A Social Network Analysis, Safety Science, 143, 105411, https://www.researchgate.net/publication/353546913_Safety_knowledge_sharing_on_Twitter_A_social_network_analysis

[Graph_Data_Providers-6] For Programmers: About NodeXL Graph Data Providers, Social Media Research Foundation, retrieved May 13, 2013

[3rd_Party-7] Third-Party Graph Data Importers, Social Media Research Foundation, retrieved May 13, 2013

[8] "NodeXL: Network Overview, Discovery and Exploration for Excel - Home". Archived from the original on 2018-01-20. Retrieved 2020-12-13.

[9] NodeXL: Network Overview, Discovery and Exploration in Excel - Microsoft Research

[10] Bonsignore, E.M.; Dunne, Cody; Rotman, D.; Smith, M.; Capone, T.; Hansen, D.L.; Shneiderman, B. (2009), "First Steps to Netviz Nirvana: Evaluating Social Network Analysis with NodeXL" (PDF), International Conference on Computational Science and Engineering: 332–339, CiteSeerX 10.1.1.296.6307, doi:10.1109/CSE.2009.120, ISBN 978-1-4244-5334-4, S2CID 1080217

[FP_revolution-11] Allnutt, Luke (April 11, 2012), "Pictures at a Revolution", Foreign Policy, retrieved May 13, 2013

[FP_women-12] "Visualizing the War on Women", Foreign Policy, June 18, 2012

[World_Bank-13] Moeller, Susan (November 18, 2009), You Know and Use Web 2.0 Tools. What About Those of Science 2.0?, The World Bank, retrieved May 13, 2013

[Google_Scholar-14] Google Scholar - "nodexl network", retrieved May 13, 2013

[Dunne_2013-16] Dunne, Cody; Shneiderman, Ben (2013), "Motif Simplication: Improving Network Visualization Readability with Fan, Connector, and Clique Glyphs" (PDF), Proceedings of the SIGCHI Conference on Human Factors in Computing Systems, ACM: 3247, doi:10.1145/2470654.2466444, ISBN 978-1-4503-1899-0, S2CID 15321464

[Shneiderman_2012-17] Shneiderman, Ben; Dunne, Cody (2012), "Interactive network exploration to derive insights: filtering, clustering, grouping, and simplification" (PDF), Proceedings of the 20th International Conference on Graph Drawing, Lecture Notes in Computer Science, 7704: 2, doi:10.1007/978-3-642-36763-2_2, ISBN 978-3-642-36762-5

[Rodrigues_2011-18] Mendes Rodrigues, Eduarda; Milic-Frayling, Natasa; Smith, Marc; Shneiderman, Ben; Hansen, Derek (2011), "Group-In-a-Box Layout for Multi-faceted Analysis of Communities", Proceedings of the 3rd IEEE International Conference on Social Computing, IEEE: 354, CiteSeerX 10.1.1.296.6410, doi:10.1109/PASSAT/SocialCom.2011.139, ISBN 978-1-4577-1931-8, S2CID 6265697

[19] Himelboim, Itai; McCreery, Stephen; Smith, Marc (2013-01-01). "Birds of a Feather Tweet Together: Integrating Network and Content Analyses to Examine Cross-Ideology Exposure on Twitter". Journal of Computer-Mediated Communication. 18 (2): 40–60. doi:10.1111/jcc4.12001. ISSN 1083-6101.

[1]

[2]

[3]

[4]

[5]

[6]

[7]

[8]

[9]

[10]

[11]

[12]

[13]

[n 1]

[15]

[16]

[17]

[18]

[14]