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)
And the result in Gephi will be:
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):
And this leads to something more meaningful, in my opinion at least:
3. Issues and feature requests?
Please post your comments and questions on Github: https://github.com/seinecle/My-Plugins-for-Gephi/issues
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.