SPSS Statistics

SPSS Statistics

Your hub for statistical analysis, data management, and data documentation. Connect, learn, and share with your peers! 


#Analytics
#SPSSStatistics
#Analyticstools
 View Only
  • 1.  How to export selected variables to excel

    Posted 07/22/20 04:55 PM

    I want to export my dataset to excel, but only a subset of variables. When I go to File > Export... > Excel, it immediately goes to where I want to save the file and doesn't bring up the export dialogue to allow me to select which variables i want to export.

    I'm running SPSS 26.0 (I think) on a Mac (v. 10.15.6 - Catalina)






    #SPSSStatistics
    #Support
    #SupportMigration


  • 2.  RE: How to export selected variables to excel

    Posted 07/22/20 05:59 PM

    When you go to that link, you should see a Variables button that will let you select the variables. However, if you are actually on V27 on a Mac, it uses native Mac file dialogs by default. In Edit > Options you can turn off that behavior, and then you should see the full functionality including variable selection.






    #SPSSStatistics
    #Support
    #SupportMigration


  • 3.  RE: How to export selected variables to excel

    Posted 07/22/20 06:01 PM