How to Export Data to an Excel Sheet/CSV File?

Export Data to Excel/CSV

Soley Studio provides the option to export data of all your analyses directly to an Excel sheet or .csv file using the built in Export function. It can be used while a graph file is open. Just click on the Export data button in the toolbar, as shown below, and choose whether you want to save your data as a .xlsx file or .csv file.

Export your Graph results from Soley Studio to Excel with one click of a button.

For every graph visualization type except the Table and Matrix view, all data is exported. That means the exported table contains one row for each element in the graph with the columns representing the property values. This also includes the system-defined attributes, such as __guid.

Use Soley Studio to export all of the data contained in your graph into an Excel Sheet.
Example of a Excel table exported from a graph view

As we can see in the image above, each Node and Edge Class is stored in a separate Sheet. This way it is possible to save all of the attributes of the respective classes, in comparison to the case where all of the nodes are displayed in one spreadsheet.

 

Matrix View

A Matrix view can be exported as displayed in the Soley software. That means that the export does not contain all the data but the layout and styling of the original Matrix view:

The Matrix view in Soley Studio can also be exported to an Excel Sheet.
Example of a Matrix view in Soley software

The corresponding graph visualization in Excel looks pretty much the same:

The exported Matrix View in Excel takes up the same look as the Soley Studio version.
Example of the resulting Excel export

Table View

The export of a Table view also takes the layout but not the styling of the view into account. That means that the resulting Excel/CSV file will only contain the data points and columns shown in the Table view. That allows you to create a customized excerpt of the data in your graph and export only this section as a table.

The Table View in Soley Studio allows for displaying only the attributes, and also sorting the data in a way that suits you the most.
Example of a (simple) Table view in Soley software

When exported to Excel, the Table View will get adapted to a “typical” Excel sheet look:

When exported, the Table View from Soley Studio takes on a look that is adapted to the way Excel tables look like.
Example of a Table view exported to Excel/CSV

Was this article helpful?

Related Articles