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:

GET DATA /TYPE=XLSX  /FILE=*****
/SHEET=name ‘RawData’
/CELLRANGE=full
/READNAMES=on
/ASSUMEDSTRWIDTH=32767.
>Error.  Command name: GET DATA
>(2063) Error reading information for sheet.
>* Sheet Name: “RawData”
>This command not executed.
DATASET NAME DataSet1 WINDOW=FRONT.

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…..  ;)

About these ads

September 29, 2010. Tags: , , , , , , , , , , , , , , , . Compy Stuff, Ms. Compy Fix-It.

33 Comments

  1. Eduard replied:

    Thank you.
    It worked :)
    Wish you all the best ! :)

    • clio44 replied:

      Wonderful — glad I could help! :)

    • Geoff replied:

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

      • clio44 replied:

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

  2. Sig replied:

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

    • clio44 replied:

      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 replied:

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

  3. Eline replied:

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

  4. Eline replied:

    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 replied:

      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 replied:

    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 replied:

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

  6. Erinn replied:

    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 replied:

      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 replied:

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

  8. Quinton replied:

    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 replied:

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

  9. Peter replied:

    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 replied:

      Are you thinking of doing a correlation?

  10. Elsa replied:

    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 :D

  11. Anne replied:

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

  12. xof replied:

    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 replied:

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

  14. Melody replied:

    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 replied:

      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 replied:

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

    • clio44 replied:

      You’re welcome, you’re welcome, you’re welcome! :)

  16. MJ replied:

    it worked! thanks!

  17. LW replied:

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

    • clio44 replied:

      You’re welcome :)
      I understand your pain!! Good luck :)

  18. Nata Chaipichit replied:

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

  19. Nik replied:

    Thanks Heaps! That was really helpful!

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Trackback URI

Follow

Get every new post delivered to your Inbox.

Join 165 other followers

%d bloggers like this: