SPSS Statistics

SPSS Statistics

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

 View Only
Back to discussions
Expand all | Collapse all

How to export selected variables to excel

  • 1.  How to export selected variables to excel

    Posted Wed July 22, 2020 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 Wed July 22, 2020 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 Wed July 22, 2020 06:01 PM

    That did it! Thank you.






    #SPSSStatistics
    #Support
    #SupportMigration