Importing excel

[Rajeshms]

Hi all,

I am facing problem while importing excel sheet data. Lets say for example, In excel we have labels and other unwanted names and texts , so while importing we have to clean the excel sheet and make ready to get it imported into spss.Is there any option so that I can over come this time consuming procedure.

thanking you for comments,

--

Rajesh M S

[J. R. Carroll]

I'm going to pull a David M and say:

Don't screw up your Excel? 

=P

Then I'm going to pull a Justin (me) and say:

Excel is great for exporting out in csv or some other delimited format, I always default to Python as a knee-jerk solution because I work a lot with it and feel comfortable work in it - I know there exists Syntax solutions for parsing - but Python could delete unwanted data and save the resulting data to a flat file for easy importing into SPSS.  The script would take ~20 min to write (and that includes watching TV in the background), and would take about 2 sec to run (depending on the size of your datafile).  It's another step, but if the Excel file is being pulled from a database with garbage in it that you dont want (or someone is preparing it for you and cannot deliver it in the format you want) this would be a easy solution and save you time.  

-J

----


J. R. Carroll

Cell:  [phone]

Email: [hidden email]

          [hidden email]

          [hidden email]

          [hidden email]

On Fri, Jun 29, 2012 at 1:29 PM, Rajeshms <[hidden email]> wrote:

Hi all,

I am facing problem while importing excel sheet data. Lets say for example, In excel we have labels and other unwanted names and texts , so while importing we have to clean the excel sheet and make ready to get it imported into spss.Is there any option so that I can over come this time consuming procedure.

thanking you for comments,

--

Rajesh M S

[David Marso]

I believe you need to be more specific re what it actually looks like before and what it should look like later.  What does it look like if you don't clean up the excel and read it straight up.
Might be somewhere between VERY easy (or a royal PIA) to clean it afterwards within SPSS dependent upon the actual structure of the file.

Rajeshms wrote

Hi all,

I am facing problem while importing excel sheet data. Lets say for example,
In excel we have labels and other unwanted names and texts , so while
importing we have to clean the excel sheet and make ready to get it
imported into spss.Is there any option so that I can over come this time
consuming procedure.

thanking you for comments,

--
Rajesh M S