Exporting data

Updated at June 23rd, 2020

You can get data out of Protobi by exporting elements to PowerPoint or Excel. First, select the elements or groups that you want to export. To select, press the heading (selected items are highlighted light blue). You can press the Esc key to clear selections.


After you've selected the relevant elements, press the Export button on the toolbar. From the dropdown menu choose the export format. Protobi exports to PowerPoint as editable charts and to Excel as tables or raw data. 


Export to PowerPoint

This type of export will generate a PowerPoint with each selected item on its own slide. Aside from using the Export button from the toolbar, you can export to PowerPoint by using the key board shortcut XP (Shift + X + P).

Most charts will export as native, editable chart objects with the data embedded inside an Excel file. 

Non-standard chart types

Even chart types like Word Cloud will generate as text shapes with the same color, position, etc. that you see online.

This is what the Word Cloud export looks like as an editable chart in Powerpoint.


Export to Excel as tables

Exports in this format have a "main" worksheet, and each selected element is on its own worksheet within the Excel file. For groups, its worksheet will contain tables for each element within the group.

For your convenience, exports to Excel as tables will generate data tables in both counts and percents. This makes it easy to select and chart the data in either variation. 


Export as data

Exporting as data to CSV will generate a file with respondent-level data. The resulting worksheet contains columns for just the elements you select, and rows for just your current scenario. 

Labeled vs raw 

You can export the data either labeled or raw. Below (on the left) we exported psraid, q1 and q2 as a labeled CSV. This will include the element title and format. On the right, we exported the same elements as a raw CSV. This will generate a file with the raw data values. 


Export the entire dataset

If you want to export the entire dataset, with all rows and columns, press the trigram in the upper right and choose either Excel or CSV format.

Video tutorial

There are many ways to export data from Protobi into your presentation. 

Select one or more charts and press the Export button from the toolbar, or select Shift + X + P to export to PowerPoint. 

Export to PowerPoint to see your data in native, editable charts in PowerPoint. 

Export to Excel to see your data as tables. Tables with percentages on the left, and tables with counts on the right. 

Export to CSV, either raw or labeled to download a spreadsheet. This has one row per respondent with column names and titles at the top.



Was this article helpful?