Preparing Data in Excel to Import into SPSS

[@rosasutton8472]

It is good to know that SPSS supports Excel and that data can be exported from Excel to SPSS with such ease. I like how you explain how to clean up data before export and the most common scenarios that can occur.

[@mic4308]

This is a super helpful sharing with comprehensive and clear examples what we really face in preparing data importing into SPSS. Especially for the substring thing, thank you very much Dr.

[@cherylchance904]

This was certainly a valuable video Dr. Grande. I appreciated the insight on how to prep the data in excel so that it can be easily transferred into SPSS. The recoding feature is especially valuable.

[@sarahburrous7374]

This was a really great walk through on how to scrub the Excel data before bringing into SPSS. I especially liked all the examples of what may come up in different situations. As suggested, keeping a comments column for reference would be helpful.

[@cardinalgrad11]

Such a helpful video. Helps to make sense of how to integrate SPSS and Excel when gathering data. I wish this video had been presented sooner, in the first module even, which would have helped make sense of the videos prior which switched from SPSS to Excel and back to SPSS. I like the idea of coding the worded data into numerical data sets. Excel makes this very easy!

[@cassieperoulis4881]

+Ashley Kilpatrick I agree 100% with you on this! Excel makes this a lot easier, I love Excel for its numerous abilities!

[@cherylchance904]

So true Ashley. I never had experience setting everything up in Excel ahead of using SPSS but I can certainly see where it is most valuable to do so.

[@karanchilli]

What if the coding data had 100s of variables??

[@ΚωστήςΔρόσος]

Thank you !!! I was searching for that for a long time !!!

[@carinahibberd8701]

Really helpful. I'm going to email this to a student but with a couple of health warnings: 1. Be very cautious of sorting, if you don't bring the rest of the columns along with the sort; 2. Be very cautious of correcting data without going back to the source material to check and of not recording that you have updated the values in this and the original dataset.

[@aprilbrooks8672]

I wish this video would have been presented sooner, I did not understand why we went back and forth in these programs. It makes sense now that it is easier to manipulate recorded data in EXCEL and analyze it in SPSS. Having accurate information in one will lead to more accuracy in the other!

[@amandachaffin6636]

+April Brooks I agree! EXCELL is much easier to record and change, I found it interesting that EXCEL picked up on the find and replace tool male being inside female so female had to be done first. Lots of adjustments to make before importing it to SPSS.

[@veronicante]

Thanks for the video!

[@janainasill9481]

Thank you! Your video was very helpful!

[@MarkVanderley]

Nice video Helpful for for understanding the importance of accurate data collection

[@AnnessiaAMLewis]

Hi Dr. Grande! Thanks for this video. Question, how would i represent time? Time is an important part of this my study but how do i format it for analysis in spss?

[@manovriksha]

Thanks a lot u saved my time

[@calbuckley9100]

Mr. Grande, what a grande ol' job. HE.HE HE HE. Thanks for the wisdom, buddy.

[@DrGrande]

You're welcome!

[@aliyugarba7208]

Thank you very much Dr. Todd Grande. Very helpful.

[@DrGrande]

You're welcome, thanks for watching -

[@darrellkavan_93]

Thank you Dr clear and informative I love it

[@MountainRaven1960]

Can you select specific variables/data in excel to import into SPSS, instead of data dumping the lot?

[@michelesimms-burton208]

Thank you Dr. Grande. This was very helpful.

[@DrGrande]

You're welcome, thanks for watching -

[@anjaschultheiss3621]

Is it better to leave a blank space in the data set for inapplicable data or to give it a code such as 999 or -99

[@asmaqudayr4447]

Greatly appreciated thank you!

[@lucutes2936]

what would happen if I don't rename the data in a column like Gender? Can SPSS read Male Female, or it must have a number instead?

[@merinanepali9164]

how to transform multiple response data from google forms to excel to spss??

[@ajay101ification]

🤔😁

[@ΚωστήςΔρόσος]

same way ... ctrl + H ... I just tried it... but i guess it's too late for my response ...

[@syadaniriyadfatema9148]

Very helpful, thank you

[@sabrayahya89]

thank you so much Sir..

[@laxmanbisht2638]

how to do it for categorical variables more than two levels?

[@jelenavelemir5379]

Thank you Dr Grande!!

[@eugenesmith9109]

Hi Dr. G. I need help with a data set, can I email it to you with the instructions. I've taken 2 days to figure it out, and so far cannot...

[@seupires4931]

Good informations, very helpfull too. I have another question, very necessery to me. Would you please tell me how to import data from excel do mplus (step by step, please....) Thank you

[@brittanygoodwin1556]

I like that data can be exported from Excel to SPSS, I feel that Excel is easier to use.

[@tiagodossantos348]

Very helpful - thank you Dr. Todd L. Grande!

[@oaetk]

Thank youuuuu!

[@sanaali6621]

Thank you sir

[@Darjasa]

Kindly show how to enter data from Excel to spss in short

[@absalatkerebih1404]

thanks so much

[@welekidanwelu9985]

THANKYOU

[@DrGrande]

You're welcome.

[@agbebiayomiku3401]

Pls Your video is not clear enough for beginners to pick on ur explanations... When u point the arrow i cant see clearly where its pointed

[@karinalohana3157]

Bruh i need help like now

[@mic4308]

This is a super helpful sharing with comprehensive and clear examples what we really face in preparing data importing into SPSS. Especially for the substring thing, thank you very much Dr.