How to take your data to QGIS

If you want to conduct further analysis on the data you have collected with Maptionnaire on a GIS program, exporting the data is easy due to the Well-known text (WKT) format. WKT is the format Maptionnaire uses to save geographical data from surveys. It is a markdown language used to represent geographic objects such as points, lines, and polygons.

How to import your geographic data to QGIS:

1. Go to the results Excel and to the tab with the map question that you want to take to a GIS programme. Copy the information in that tab to another Excel worksheet. Save the new worksheet as in the CSV (comma-separated values) format. 

2. Open QGIS and choose Add delimited text from the tool panel. 

   

3. Choose Custom delimiters as the file format and check Semicolon from the list. Choose WKT as the Geometry definition and define geometry field as ‘wkt’ if you are using data from Maptionnaire results spreadsheet. Choose the geometry type (point, line, polygon) from the drop-down list.
   
   

   Note! QGIS can only read the first tab from an Excel file so if you have data on multiple tabs you need to export the data to a separate sheet. 

4. 

   If you scroll down to the sample window, the data presented there should now look like an Excel sheet. Click Add to finish importing WKT.

   

5. Finally, click Add to finish importing WKT.

In QGIS you can further edit, analyse, and visualize the data as you wish. You can, for example, filter the test questionnaire’s results by routes that respondents use for leisure (in cycling data “for leisure” = true). Please note that if you want to export responses to multiple different map questions to QGIS, you need to repeat this process for each tab in the Maptionnaire results sheet.