Gephi.org | Download Gephi | Blog | Gephi Store | Wiki | Forum | Support | Bugtracker

Look for Gephi Plugins

Popular Keywords

Close Search

Excel / csv converter to network

Excel / csv converter to network
1 vote, 4.00 avg. rating (84% score)

Convert Excel spreadsheets and csv files into networks

This plugin helps transform your Excel files (or csv files) into a network, directly imported into Gephi. You can choose which entities, and which relations, form the network.

1. Quick how-to

- Install the plugin in Gephi (File -> Tools -> Plugins -> Available).
- Restart Gephi

In the Gephi menu, select File -> Import Spigot.
- Select “Data importer”
- Get your Excel file ready!
- Follow the steps of the wizard.

2. To go further…

The plugin gives you the possibility to create network of two types of entities. Let’s say that your Excel file looks like:

Author Book Year Sales of the book
David My life 1972 350 copies
Mary My story 1968 400 copies

In the wizard you’ll get to a window where you’ll select “Author” and “Book” as the two types of entities you want to connect:

(click to enlarge)

bipartite

And the result in Gephi will be:

network bipartite

This looks fantastic, but in practice this type of networks gets quickly messy – lots of connections between both types of agents, making it hard to disentangle and to visualize.

 

-> For this reason, I’d suggest to also try the plugin on this type of files:

Author Book Year Sales of the book Literary agent
David My life 1972 350 copies Philip
Mary My story 1968  400 copies Philip

 

Here, by selecting a network made of ‘Authors’ and ‘Literary Agent’ in the plugin, the resulting network will be much more interesting (because it is made of one type of agents: persons).

So in the plugin you select (click to enlarge):

tttt

 

And this leads to something more meaningful, in my opinion at least:

 

network

Enjoy!

3. Issues and feature requests?

Please post your comments and questions on Github: https://github.com/seinecle/My-Plugins-for-Gephi/issues

I am Clement Levallois (@seinecle), and you can see my other projects on www.clementlevallois.net.

4. Release history

Initial release (Nov. 2013).

Version 1.1 (Nov. 2013). Added error messages helping the user navigate the plugin.

Version 1.3 (March 2014). Bug fix: same names in different columns are now treated correctly. Bug report / analysis by Wouters A.H. Spekkink.

Similar Plugins

Graph Streaming

The purpose of the Graph Streaming API is to build a unified framework for streaming graph objects. Gephi’s data structure and visualization engine has been built with the idea that a graph is not static and might change continuously. By connecting Gephi with external data-sources, we leverage its power to visualize and monitor complex systems or enterprise data in real-time. Moreover, the idea of streaming graph data goes beyond Gephi, and a unified and standardized API could bring interoperability with other available tools for graph and network analysis, as they could start to interoperate with other tools in a distributed and cooperative fashion.

More Info

Virtuoso Importer

Allows importing of RDF data from a Virtuoso server. Uses the import spigot functionality

More Info

SemanticWebImport

This plugins allows to apply a SPARQL request on: 1. a set of RDF local files, i.e. on your computer. This is done by using the Corese SPARQL engine; 2. a SPARQL SOAP or REST end-point. It provides also the following functionalities: – statistics on the types present in the rdf obtained (if the rdf:type [...]

More Info