I have a large text file and I want to open it so that it appears as columns in excel 2003. When i open it though the columns are lost and its all one horizontal line? Help
-
What happened to the 1.5 Gb Excel 2003 file that was concerning you only about a day ago (stackoverflow.com/questions/3241039)? You have not responded to questions from people trying to help you ...– John MachinJul 14, 2010 at 21:27
-
1The SO community shakes its collective finger at you!!!– Abe MiesslerJul 14, 2010 at 22:19
-
3@novak You need to learn to use the "edit" button to edit your question. Doing so will cause it to appear at the top of the list of recent questions on the main SO page. Asking the question again with a slightly different wording only irritates the community and creates work for the moderators who have to clean up the duplicate questions. You have several people trying to help you on each of your questions (one of them even wrote the library you are using!) please try to provide them with meaningful and thoughtful responses to their questions. "It doesn't work" is useless to us.– Chris ThompsonJul 15, 2010 at 0:01
3 Answers
It will depend on what version of excel you are using. The basic idea of what you need to do is:
Open a blank Excel doc->Click Data->Import data (Or "Get External Data")->From Text->select the file
Once in there you will use the wizard to specify what the columns are delimited by and it will open the data as a spread sheet.
-
THe problem with that is the file is too large and it doesn't open completely.– novakJul 14, 2010 at 19:24
-
-
2It's probably the same 1.5 GB "Excel 2003 XLS" file he was asking about yesterday but won't reveal any details ...– John MachinJul 14, 2010 at 21:54
-
1
If the file is too large to be opened in Excel 2003 (which has some rather severe limits, like a maximum of 256 columns, that I have run into myself several times), and if it's not really an Excel file anyway but rather a (possibly nonstandard) CSV file, then take a look at CSVed.
This utility can open most any text file with tabular data and help you modify it, for example transforming it into a "real" CSV file. And it's equipped to deal with really large files, too.
Try giving it a .csv extension, and see if it parses it differently. If not, you're most likely going to have to write a macro to import it, or something like regular expressions to insert commas everywhere before you do.
-
Can you give me some more detail on how to do either of those things?– novakJul 14, 2010 at 19:11
-
2@novak: If you would actually answer questions about the structure of the file, we could help you. So far you have asked 5 SO questions about what seems to be the same 1.5 GB file but we are nowhere near getting more than vague clues about the file structure.– John MachinJul 14, 2010 at 21:57
-
2@novak - Yes, if you can give me more detail on the file you need to open.– Daniel RasmussenJul 14, 2010 at 22:03