SPSS Statistics

SPSS Statistics

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

 View Only
Expand all | Collapse all

Error (2052): Excel data is not importing into SPSS

  • 1.  Error (2052): Excel data is not importing into SPSS

    Posted Thu March 18, 2021 02:02 PM

    I'm using IBM SPSS statistics 24 & Excel 2008. I'm trying to import survey data of about 350 cases into SPSS. However, spss is giving me the error (2052), stating that the excel file is still open, when it is not.

    I've tried restarting my laptop, renaming and moving the file, turning the xlxs file into a csv file, but nothing has worked.

    What else could i try to fix this issue?






    #SPSSStatistics
    #Support
    #SupportMigration


  • 2.  RE: Error (2052): Excel data is not importing into SPSS

    Posted Fri March 19, 2021 06:35 AM

    Dear Support Member​ 

     

    It might be worth to read the following IBM Tech-Note in order to try to fix this issue:

     

    https://www.ibm.com/support/pages/error-2052-when-opening-excel-file-spss

     

    Best regards.

    Support Member​ 






    #SPSSStatistics
    #Support
    #SupportMigration


  • 3.  RE: Error (2052): Excel data is not importing into SPSS

    Posted Fri March 19, 2021 08:12 AM

    Hi Jorge,


    This Tech-note states that I should close the excel file & try again, which I have done several times. Yet, this hasn't worked.

    What else could I do?






    #SPSSStatistics
    #Support
    #SupportMigration