I am trying to study the social network of the center where I am working. I have done a compilation of relation between personal from programed meeting, formal working team, etc. to analyze structural relevant positions. I recapitulated all these information in a matrix of incidence: a square symmetric matrix which entries are related with the time two persons stay together. This matrix is in Excel.

I am looking for free software which draws a graph from the incidence matrix via importation of Excel file.

Any help?

Thank you in advance

  • $\begingroup$ I can't offer specific software recommendations, but know that Excel can save files as comma separated value or tab delimited (.csv or .tab) files, which are pretty much universal for data-driven software. So, no need to limit your search only to programs that can read from excel files. $\endgroup$ Jun 2, 2012 at 17:31
  • $\begingroup$ Ok. If I save data in .csv for example, are there software to make graph from incidence matrix? $\endgroup$ Jun 2, 2012 at 17:35
  • $\begingroup$ Yup, looks like R will do it. I've added an answer with links to it and the necessary package. $\endgroup$ Jun 2, 2012 at 18:10

1 Answer 1


So it looks like R can generated the graph youre looking for via graph.incidence in the igraph package, which can be found in CRAN. To get the incidence matrix, you can just do:

matrix.pickaname <- as.matrix(x)

Though, it seems that this solution only works if the .csv is only the data, no headers. If you still have string values in the file, it gets imported as a data.frame.

  • $\begingroup$ Is this for logic matrix only? $\endgroup$ Jun 2, 2012 at 18:34
  • $\begingroup$ The documentation I linked indicates it takes an incidence matrix. This isn't exactly my area though, so I can't attest to it. R is free though, and very effective so I'd give it a shot. $\endgroup$ Jun 2, 2012 at 23:35

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .