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….. 😉
Clio44's Blog 
Thank you.
It worked 🙂
Wish you all the best ! 🙂
Wonderful — glad I could help! 🙂
Worked perfectly! You’re a wonderful person for posting this.
Aww, thanks Geoff. I’m truly glad I could help 🙂
Had the same problem. Apparently I solved it by saving the excel file in 2003-oder format.
sig
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?)
Thanks for the solution! I did the copy solution and didn’t help, but your solution work just fine. =D
Thank you!!!! :-))) and also thanks to the first post which helped me find this one
Thanks a lot! You saved me from a whole (lost)day looking to solve the problem 🙂
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?
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! 🙂
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.
Yeah, Thanks a lot, it really does not work in *.xlsx-Format but in *.xls – Strange, but ok…
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.
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 🙂
That worked great! Thank you so much! Back to analyzing energy savings from bill data…
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!
I’m so glad to have helped! Thank you for commenting, you just made my day! 😀
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
Are you thinking of doing a correlation?
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 😀
Thank you! Just had this problem – and yes, you fixed it!
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)
Add me to the list of people who you helped with this problem. Thank you!
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!
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 😉
Thank you, Thank you , Thank you!!!!
You’re welcome, you’re welcome, you’re welcome! 🙂
it worked! thanks!
So glad to hear it!
Thank you so much! This is a really great help for a typical student who runs late with essay assignments!
You’re welcome 🙂
I understand your pain!! Good luck 🙂
just copy and save as excel 2003 in a new file. It works! Thanks
Thanks Heaps! That was really helpful!
Thank you very much! It worked.
Thank you very much! Really!!!
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.
Sincerely,
Javier Figueroa