Doing this will save just the current worksheet and the current text formatting of the data, with a comma between each cell value, and with double quote marks around every cell value that itself contains a comma. The most common of these is the Comma-Separated Values (CSV) file, which may be saved with a *.CSV file extension or a *.TXT one.Īn Excel worksheet can be saved in this format using the Save As command and the option “Save as type: CSV (Comma delimited) (*.csv)”. If so, each line must represents a reading/case/observation, and the variables are delimited (separated) by a tab, comma or other character. Approach 3: Read text data via Comma-Separated Values format Please read Part 2 of this blog post before proceeding, which covers preparing an Excel document and the direct but limited way to import data into SPSS. Perhaps you just want to open a very large text document that is too big for Excel. There are many ways to bring your data into IBM SPSS Statistics, for whatever manner of analysis or reorganisation you wish to perform.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |