[Click here to read part 1, part 2 and part 3a]
First, save your “nodes” sheet as a csv-file: Go to “save as” and then select “csv” as the data type. Name your new csv file for example “academy awards nodes.csv.” Do the same with the “ties numerical” sheet and name it accordingly.
Now open the network analysis software visone. (Download links and instructions can be found here).
In visone you find the file symbol (“open network from file”) on the top left. Click on it, chose your “ties numeric” csv file and confirm with “ok.” The program will then ask you to “specify your data format.” Select “CSV files.” In the next window, set everything as you can see below and then click “ok”.
Now, visone can already visualize your network.
I will later add a blogpost on how you can import attribute data and work with visone.