Solution for “SPSS Error Code 2063 Getting Data”

Hello all.

Just troubleshot (haha) my way out of an SPSS issue, and since the Interwebs couldn’t help me out, I’ll post it here for anyone else who might need it.

I was trying to import an Excel file that was basically a copy and paste from a different file.  So the file itself was pretty new, not like it’d been worked over a lot.  I tried to import it, however, and got the following error message:

/SHEET=name ‘RawData’
>Error.  Command name: GET DATA
>(2063) Error reading information for sheet.
>* Sheet Name: “RawData”
>This command not executed.

The error, as I could figure out, was probably due to me having calculations lower down in my sheet.  I copied and pasted values into a brand new sheet, and that imported just fine.  If you’re having the same issue, try copy and pasting Values only into a new sheet and see if that helps.

The More You Know…..  😉


37 thoughts on “Solution for “SPSS Error Code 2063 Getting Data”

  1. Eduard October 13, 2010 / 7:11 pm

    Thank you.
    It worked 🙂
    Wish you all the best ! 🙂

    • clio44 October 13, 2010 / 8:30 pm

      Wonderful — glad I could help! 🙂

    • Geoff January 12, 2011 / 5:31 pm

      Worked perfectly! You’re a wonderful person for posting this.

      • clio44 January 12, 2011 / 5:42 pm

        Aww, thanks Geoff. I’m truly glad I could help 🙂

  2. Sig October 28, 2010 / 12:33 am

    Had the same problem. Apparently I solved it by saving the excel file in 2003-oder format.

    • clio44 October 28, 2010 / 4:14 pm

      Interesting! I’ll try that next time and see if that does anything to the equations….. Thanks for the idea!

      By the way, your name/e-mail looks really familiar….. did you by chance post somewhere else about this? (Or have you visited my site before?)

    • Koori June 24, 2013 / 6:48 am

      Thanks for the solution! I did the copy solution and didn’t help, but your solution work just fine. =D

    • Alicia April 18, 2017 / 8:26 am

      Thank you!!!! :-))) and also thanks to the first post which helped me find this one

  3. Eline November 2, 2010 / 10:32 am

    Thanks a lot! You saved me from a whole (lost)day looking to solve the problem 🙂

  4. Eline November 2, 2010 / 10:51 am

    Can you perhaps solve my next problem? I have numbers like 0,7890437 in excel, but SPSS gives them as 0,0000
    Do you know what happened here?

    • clio44 November 2, 2010 / 3:28 pm

      First of all, thanks so much for writing — I’m very glad to help 🙂

      As to your other issue, I’m wondering if it might have to do with the decimal (these are decimal entries, right?) being represented as a comma. Try readjusting your number format in Excel first, copy-pasting values only into a new file or sheet, and importing that way. Good luck, and let me know how it goes! 🙂

  5. matS November 16, 2010 / 7:10 pm

    This has often to do with importing an Excel 2007 file. In case this is true, just open your Excel file and store it in the Excel 97-2003 format.
    Then try importing it with SPSS… it always worked for me.

    • Ed Hindess May 24, 2013 / 6:30 pm

      Yeah, Thanks a lot, it really does not work in *.xlsx-Format but in *.xls – Strange, but ok…

  6. Erinn December 2, 2010 / 7:55 pm

    I googled help for this error and I got your post! What are the odds? Thanks so much! It’s so weird that copying and pasting values into the same sheet doesn’t work.

    • clio44 December 2, 2010 / 10:31 pm

      That’s funny! Although I’ve found a lot of SPSS help is in the form of posts from users (versus actual company help)….. that’s why I post when I come up with a solution! Glad to help Erinn, hope you’re doing well 🙂

  7. brenden December 5, 2010 / 12:38 am

    That worked great! Thank you so much! Back to analyzing energy savings from bill data…

  8. Quinton February 12, 2011 / 3:46 am

    After messing with syntax for 6+ hours today, then all of a sudden running into an issue with an excel file not reading (after it has been reading fine for months) words cannot express how relieved I am to have found such a quick fix. THANK YOU!

    • clio44 February 12, 2011 / 7:23 pm

      I’m so glad to have helped! Thank you for commenting, you just made my day! 😀

  9. Peter February 25, 2011 / 9:46 am

    Please anyone help – I administered a survey with two 4 point likert scale reponses to one statement – one demand and the other supply – I want to use SPSS Ver 18 to analyse the Gap – Using Julie Pallant book but to no avail.

    Thanks in anticipation

    • clio44 February 25, 2011 / 3:00 pm

      Are you thinking of doing a correlation?

  10. Elsa March 2, 2011 / 9:39 pm

    Hi! Interesting, what works for me, was to save spreadsheet as 97-2003. I´m new at using spss. And this blog was really helpful!

    Thanks 😀

  11. Anne March 9, 2011 / 2:21 pm

    Thank you! Just had this problem – and yes, you fixed it!

  12. xof June 1, 2011 / 6:35 am

    Try saving your excel files as txt tab delimited – if you have bigger data (more than 65k rows and smth about 256 cols) than you cannot do it as xls (97/2003)

  13. Elaine June 21, 2011 / 4:22 pm

    Add me to the list of people who you helped with this problem. Thank you!

  14. Melody July 12, 2011 / 8:56 am

    Thanks for all the pointers of help – another person to add to the list of people you have helped with this problem of error code 2063. Saving to a text tab file helped for me!

    • clio44 July 12, 2011 / 4:09 pm

      Great to hear! Glad I could also help you, Elsa, Anne, and Elaine! I had no idea this many people would have this issue, so I’m very glad I posted it. Kinda draws all us SPSS-ers together in a way 😉

  15. Alli November 4, 2011 / 9:26 pm

    Thank you, Thank you , Thank you!!!!

    • clio44 May 24, 2012 / 7:40 pm

      You’re welcome, you’re welcome, you’re welcome! 🙂

  16. MJ May 1, 2012 / 3:15 pm

    it worked! thanks!

    • clio44 May 24, 2012 / 7:40 pm

      So glad to hear it!

  17. LW May 24, 2012 / 7:16 pm

    Thank you so much! This is a really great help for a typical student who runs late with essay assignments!

    • clio44 May 24, 2012 / 7:41 pm

      You’re welcome 🙂
      I understand your pain!! Good luck 🙂

  18. Nata Chaipichit December 4, 2012 / 12:18 am

    just copy and save as excel 2003 in a new file. It works! Thanks

  19. Nik February 1, 2013 / 11:44 pm

    Thanks Heaps! That was really helpful!

  20. Minella June 26, 2014 / 11:36 am

    Thank you very much! It worked.

  21. Olena June 1, 2017 / 1:43 pm

    Thank you very much! Really!!!

  22. Javier Figueroa October 1, 2020 / 3:49 pm

    I had the same error but with me the solution was different and that is that in SPSS 26 when you import or want to open an excel database, a dialog box appears and asks you for various parameters.

    I was including the parameter: Remove leading spaces from string values.

    Just disable it and it ran fine.

    Another possible solution.


    Javier Figueroa

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s