With Skyra, you can easily export responses from your surveys to a CSV file. This export gives you access to all your survey responses in raw data format, giving you the flexibility to further analyze the data in Excel, Google Sheets or other tools.
Data included in the export
The export contains the following information:
Created at: The time when the response was submitted.
Visitor ID (Visitor ID): A unique identifier for the respondent.
Session ID (Session ID): A unique identifier for the respondent's session.
Device (Device): The type of device that was used.
Labels (Labels): Any labels associated with the response.
URL: The URL where the answer was provided.
Questions and answers: All questions in the survey together with the respondent's answers.
The table
When you import the CSV file into a spreadsheet, the data will have the following structure in the table:
Columns show the data type or question in the survey
Rows shows answers and data provided by a respondent.
How to export responses
Option 1: Survey Page
Go to Surveys > Click on the name of the survey you want to export responses from.
Select Responses as CSV which appears in the top right corner when you are in the survey.
The file is downloaded and is ready for use in Excel or other analysis tools.
Option 2: Survey List
Go to Surveys Find the survey you want to export answers from
Click on the three dots (...) next to the survey.
Select Export responses (CSV).
The file is downloaded and is ready for use in Excel or other analysis tools.
How to import CSV to Google Sheets or Excel
To work further with your data, you can import the CSV file into Google Sheets or Excel:
Google Sheets
Open Google Sheets and select File > Import.
Select the CSV file you downloaded
Select settings for import, such as how data should be separated (e.g. comma separated).
Click Import data to see your answers in Google Sheets.
Excel
Open Excel and select File > Open.
Navigate to where the CSV file is stored and select it.
Excel will automatically import the data, but you can adjust settings for text to columns if needed.
Your data is now available for analysis in Excel.
Tips: Customize the table to focus on relevant data.
Remove irrelevant columns. Often both visitorID and sessionID can be deleted.
Make data more readable with the "Wrap" function so that text is not broken, but kept within a cell.
Make date format (createdAt) more readable by writing as day-month, without time.
Add filters to be able to sort the list in the desired order or hide irrelevant rows.
Filter gir følgende valg i Google Sheets
Examples: Use of exported data
Once you have downloaded the CSV file, you can open it in Excel, Google Sheets or similar tools. Here are some suggestions for what you can do:
Sort data: Sort alphabetically or chronologically to get a useful structure in the overview.
Filter data: Use filter to see only answers that match a criterion such as keyword, top task name, segment, time period, etc.
Visualize data: Create charts and graphs to present your results in a clear way.
