SPSS reporting values are shown wrong


Hi guys,

after trying for the last two hours I am trying now to reach out to you.

I have a ‘radio button’ question, using ‘custom reporting values’.


When doing the ‘SPSS Export’, even when choosing ‘String (100)’ I only get SKUs back as ‘10029’ etc.

What I need to get back is e.g. ‘Computer’, ‘Tablet’ or ‘Smartphone’. I am really out of ideas how to solve this. Can anyone help we with this?

– Marc

Loren answered

    As others have said, if you don’t give numeric reporting values, Gizmo will automatically give a numeric SKU when exporting to SPSS.  If you are planning to use a SPSS export, I would strongly recommend either assigning a numeric value to the data yourself, or tell gizmo to use sequential numbers.  The SKUs the use are annoying.  Text reporting values work for Excel, but not SPSS.  However, Gizmo DOES export the value label into SPSS.  So while you do have a reporting value of 1, SPSS will know that 1 = computer.  Being able to use reporting values, is a big reason why you would want to use SPSS.  Otherwise, simply doing an Excel export (which can use your value labels as text) would be just as useful.

    Out of curiousity, if you are using SPSS, why do you want the values to be reported as text?  While SPSS can work with text, it doesn’t do it all that well.  If you are using defined choices, you are much better off using a numeric reporting value, with the appropriate value label assigned to it.  SPSS will still use your label (computer/tablet/phone) on the output (either running frequencies or in custom tables).  The numeric value is just used in the backend.  You can even export to Excel from SPSS using the value label instead of the numeric value if you want.  You can even switch back and forth between viewing the actual value and the value label on your main data screen on SPSS.  I just can’t see a benefit to using text as opposed to a numeric value with labels in SPSS if you don’t have to.


    Loren answered
      Lola Gill 6.99K Rep.

      To add on to what IS said, I was taking a look at SurveyGizmo’s documentation on the SPSS export and it states the numeric reporting values should be used rather than text reporting values:


      Hope this helps!

      Lola Gill answered
        IS 2.21K Rep.

        Those values should have Value Labels in SPSS. If I remember right, the value labels show up in most SPSS output by default.

        If that is inconvenient for you, on a survey page after the page with the radio button question, you could create a Hidden Field and pipe the value from the from the radio button into the hidden field. This would be text and work more like what you were expecting the results to be.

        See: https://help.surveygizmo.com/help/simple-piping for more info about piping. 

        IS answered


          Question stats

          • Active
          • Views7756 times
          • Answers3 answers
          • Followers1 follower