ArticlesExport full feedback data as a CSV file

Explore other articles on this topic.

17.2.2026•Knowledge

Feedback data CSV export is a limited offline alternative to using the HappyOrNot API for extracting full feedback data for BI and other external analytical purposes. The CSV (comma-separated values) file can be opened by any spreadsheet program, such as Microsoft Excel or Google Spreadsheets.

In HappyOrNot Analytics, you can export either filtered data or unfiltered raw data to a CSV file, which is then sent to you in the form of a link in an email. The link is valid for 2 days.

The file shows the feedback data from Smiley Terminals and Smiley Touches one response per row, and from Smiley Digital two rows per response.

There is a 1-million row limit to the file, so if the export does not go through, please choose a shorter time period. We recommend using an export period of one month. 

  1.      Go to Details and choose the filters you need (Experience point/group, survey question, and time period). 
  2.      Click Export (top-right corner) and choose Feedback data (CSV).
  3. Select the type of report you want to export:
    • Feedback data - report where feedback classified as misuse have been filtered out (all open feedback is included even if it has been marked as spam)
    • Raw feedback data  - includes all responses.
  4. Select Export. You will be notified of the successful start of the export.  If the size of the export is too big, select a shorter time period for the export.   

Opening the CSV file

You can import the CSV report to the spreadsheet software of your choice, like you would a text file. For further information, please consult the help pages of the software that you are using.

Instructions for opening a CSV file in some common software (external links):

Microsoft Excel
Google Sheets
PowerBI   

 NOTE: If you have exported large amounts of feedback data as a CSV file, we recommend importing it into Excel by using Power Query (external link).

Reading the report

The CSV file includes the following information for each individual feedback:

  • Time when the feedback was given (utc_datetime, local_datetime, local_date, local_time,  local_year, local_month, local_iso_week_number, local_weekday, local_hour, local_minute, local_second,  local_millisecond)
  • Location of the survey where the feedback was given (path, group/exp.)
  • Type of the Smileys product that was used to give the feedback (response_ui, followup_ui, open_feedback_ui). The options for the Smileys type are following:
    • physical - regular feedback via Smiley Terminal or Smiley Touch 
    • touchless - Gesture-based feedback on Smiley Touch
    • link - feedback given via web address
    • qr - feedback given via QR code
    • nfc - feedback given via NFC tag
    • digital - Smiley Digital Pop-up or Embed for web
    • email - Smiley Digital Embed for email
  • Feedback scale (feedback_scale)
  • Follow-up question (followup_question)
  • Feedback responses (response, followup, open_feedback)
  • Open feedback categories
 NOTE: Spam and open feedback containing harmful language are only included in the export if the user doing the export has permission to view them. For more information, read Hide profanity and harmful content from open feedback.

Topics
SmileysExportsFollow resultsGetting StartedDetails pageHappyOrNot Analytics

Can't find the information you're looking for? Email support@happy-or-not.com to contact our Support.