SPSSX Discussion

SPSS data export to excel problem

Classic

List

Threaded

4 messages Options

wsu_wright

SPSS data export to excel problem

I'd like to know whether others are having this problem or whether its
just me (although I had the same issue on 3 different machines I've
tried it on).

Open SPSS (I'm using 17.01) and enter some data values into the data
editor (one column, 5 cells values will do). Perform a 'save as' saving
as an excel version 2007. Exit SPSS. Open the excel file in excel.
Copy the entire set of cells with data (ctrl-c), then move to a
new/blank worksheet and perform a paste (ctrl-v). I get an error
message noting excel cannot paste the data. Stranger yet, redo the copy
& paste & it works the second time. When I export data from SPSS to
excel in earlier versions of excel, I do not have this problem.

I have reported this to SPSS & had a response (see below) but I want to
know whether others are having the same problem to rule out my local
environment, thanks.

David

SPSS tech support:

David,
More likely that after the exporting to excel is complete and you able
to see the exact data in Excel, spss is no longer involved. If you are
having problem copy from excel to a new excel you are best to contact
Microsoft for support. The troubleshooting we can help is when you are
having problem export from spss to Excel. Even though you are thinking
that this process is working in the early release of spss, but the
process you are doing about copy / paste is out of spss. It is between
copy / paste from excel data to a new data within excel. You can try to
copy and paste from spss to excel but when doing copy / paste from excel
to new excel data sheet, that’s more with Microsoft Excel not spss.

DeJay Leang
SPSS Tech Support

Wichita State University
Company ID: 100076375
David Wright

Error Message: none
Case Description:
SPSS 17.01 & Excel version 2007 (xlsx). Open data editor & enter values
for test data. Select "save as" and choose excel version xlsx. Close
SPSS & open the excel file saved from SPSS. Open a second new workbook
in excel. Try copying selected cells of data from the excel file created
by SPSS into the second workbook, excel cannot copy/paste data. When I
"save as" in SPSS with an earlier versions of excel the copy/paste
functions correctly.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

SPSS Support

Re: SPSS data export to excel problem

Hello David and all,
SPSS Development has looked at this issue further and it seems that SPSS may be adding noise to the Excel file in a way that affects the subsequent cut-and-paste operations within Excel. A product defect has been filed and this will be investigated further. David, your Technical Support case has been reopened and you should be hearing from your support representative shortly.

David Matheson
SPSS Statistical Support

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of David Wright
Sent: Monday, January 19, 2009 12:55 PM
To: [hidden email]
Subject: SPSS data export to excel problem

I'd like to know whether others are having this problem or whether its
just me (although I had the same issue on 3 different machines I've
tried it on).

Open SPSS (I'm using 17.01) and enter some data values into the data
editor (one column, 5 cells values will do). Perform a 'save as' saving
as an excel version 2007. Exit SPSS. Open the excel file in excel.
Copy the entire set of cells with data (ctrl-c), then move to a
new/blank worksheet and perform a paste (ctrl-v). I get an error
message noting excel cannot paste the data. Stranger yet, redo the copy
& paste & it works the second time. When I export data from SPSS to
excel in earlier versions of excel, I do not have this problem.

I have reported this to SPSS & had a response (see below) but I want to
know whether others are having the same problem to rule out my local
environment, thanks.

David

SPSS tech support:

David,
More likely that after the exporting to excel is complete and you able
to see the exact data in Excel, spss is no longer involved. If you are
having problem copy from excel to a new excel you are best to contact
Microsoft for support. The troubleshooting we can help is when you are
having problem export from spss to Excel. Even though you are thinking
that this process is working in the early release of spss, but the
process you are doing about copy / paste is out of spss. It is between
copy / paste from excel data to a new data within excel. You can try to
copy and paste from spss to excel but when doing copy / paste from excel
to new excel data sheet, that's more with Microsoft Excel not spss.

DeJay Leang
SPSS Tech Support

Wichita State University
Company ID: 100076375
David Wright

Error Message: none
Case Description:
SPSS 17.01 & Excel version 2007 (xlsx). Open data editor & enter values
for test data. Select "save as" and choose excel version xlsx. Close
SPSS & open the excel file saved from SPSS. Open a second new workbook
in excel. Try copying selected cells of data from the excel file created
by SPSS into the second workbook, excel cannot copy/paste data. When I
"save as" in SPSS with an earlier versions of excel the copy/paste
functions correctly.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

Ian Martin-2

Re: SPSS data export to excel problem

In what may be a related issue, I have in the past reported that SPSS
16.0.1, and now 17.0.1, will not paste properly into Excel X SR1 (Mac
OS). For instance, a correlation table pastes into a single column
in Excel.

The SPSS response was that this must be an Excel problem, but now
perhaps there is some evidence that SPSS may be the problem?

regards,
Ian.

Ian D. Martin, Ph.D.

Tsuji Laboratory
University of Waterloo
Dept. of Environment & Resource Studies

On 22 Jan, 2009, at 6:24 PM, SPSS Support wrote:

> Hello David and all,
> SPSS Development has looked at this issue further and it seems
> that SPSS may be adding noise to the Excel file in a way that
> affects the subsequent cut-and-paste operations within Excel. A
> product defect has been filed and this will be investigated
> further. David, your Technical Support case has been reopened and
> you should be hearing from your support representative shortly.
>
> David Matheson
> SPSS Statistical Support
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On
> Behalf Of David Wright
> Sent: Monday, January 19, 2009 12:55 PM
> To: [hidden email]
> Subject: SPSS data export to excel problem
>
> I'd like to know whether others are having this problem or whether its
> just me (although I had the same issue on 3 different machines I've
> tried it on).
>
>
> Open SPSS (I'm using 17.01) and enter some data values into the data
> editor (one column, 5 cells values will do). Perform a 'save as'
> saving
> as an excel version 2007. Exit SPSS. Open the excel file in excel.
> Copy the entire set of cells with data (ctrl-c), then move to a
> new/blank worksheet and perform a paste (ctrl-v). I get an error
> message noting excel cannot paste the data. Stranger yet, redo the
> copy
> & paste & it works the second time. When I export data from SPSS to
> excel in earlier versions of excel, I do not have this problem.
>
> I have reported this to SPSS & had a response (see below) but I
> want to
> know whether others are having the same problem to rule out my local
> environment, thanks.
>
> David
>
>
>
> SPSS tech support:
>
> David,
> More likely that after the exporting to excel is complete and you able
> to see the exact data in Excel, spss is no longer involved. If you are
> having problem copy from excel to a new excel you are best to contact
> Microsoft for support. The troubleshooting we can help is when you are
> having problem export from spss to Excel. Even though you are thinking
> that this process is working in the early release of spss, but the
> process you are doing about copy / paste is out of spss. It is between
> copy / paste from excel data to a new data within excel. You can
> try to
> copy and paste from spss to excel but when doing copy / paste from
> excel
> to new excel data sheet, that's more with Microsoft Excel not spss.
>
> DeJay Leang
> SPSS Tech Support
>
>
> Wichita State University
> Company ID: 100076375
> David Wright
>
> Error Message: none
> Case Description:
> SPSS 17.01 & Excel version 2007 (xlsx). Open data editor & enter
> values
> for test data. Select "save as" and choose excel version xlsx. Close
> SPSS & open the excel file saved from SPSS. Open a second new workbook
> in excel. Try copying selected cells of data from the excel file
> created
> by SPSS into the second workbook, excel cannot copy/paste data. When I
> "save as" in SPSS with an earlier versions of excel the copy/paste
> functions correctly.
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text
> except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text
> except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD

SPSS Support

Re: SPSS data export to excel problem

Hi Ian,
I could not find a record of this problem, but a colleague in Technical Support will be investigating this. As a general rule, the File->Export menu is a surer way to move a table from SPSS output to an Excel file, so I suggest trying this approach. Let us know if this approach is more successful for you.

David Matheson
SPSS Statistical Support

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Ian Martin
Sent: Monday, January 26, 2009 9:17 AM
To: [hidden email]
Subject: Re: SPSS data export to excel problem

In what may be a related issue, I have in the past reported that SPSS
16.0.1, and now 17.0.1, will not paste properly into Excel X SR1 (Mac
OS). For instance, a correlation table pastes into a single column
in Excel.

The SPSS response was that this must be an Excel problem, but now
perhaps there is some evidence that SPSS may be the problem?

regards,
Ian.

Ian D. Martin, Ph.D.

Tsuji Laboratory
University of Waterloo
Dept. of Environment & Resource Studies

On 22 Jan, 2009, at 6:24 PM, SPSS Support wrote:

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD