Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Transfer CSV file from Winzip to Excel
How do I transfer a zipped csv file to Excel where the zipped file contents
are too large to fit into the 65k+ rows in Excel? I get the message "File not loaded completely" when I open the file. What do I have to do to load the complete contents fo the file? thanks Glenda |
#2
|
|||
|
|||
Maybe you can open it in Notepad (or your favorite text editor) and save it into
smaller bite size pieces. Then import each smaller piece into its own worksheet/workbook. kookaburra wrote: How do I transfer a zipped csv file to Excel where the zipped file contents are too large to fit into the 65k+ rows in Excel? I get the message "File not loaded completely" when I open the file. What do I have to do to load the complete contents fo the file? thanks Glenda -- Dave Peterson |
#3
|
|||
|
|||
You could open the .csv file in Notepad (I don't think Notepad has a size limit), delete the first 65,536 lines (the data already loaded into Excel), save the .csv file as Part 2 and open that into Excel. You can probably locate the correct line in Notepad by a search on the data shown in the last row of the partial load. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=390432 |
#4
|
|||
|
|||
Thanks, Dave
It wouldn't open in wordpad (file too big) but I opened it in the Winzip suggested text editor. Data of course appeared as comma delimited and, whilst I copied it in sections and pasted to Excel, it is still in csv format. I tried saving data as a CSV file and thought that if I reopened it would allow a data conversion process. It didn't. Any ideas? thanks Glenda "Dave Peterson" wrote: Maybe you can open it in Notepad (or your favorite text editor) and save it into smaller bite size pieces. Then import each smaller piece into its own worksheet/workbook. kookaburra wrote: How do I transfer a zipped csv file to Excel where the zipped file contents are too large to fit into the 65k+ rows in Excel? I get the message "File not loaded completely" when I open the file. What do I have to do to load the complete contents fo the file? thanks Glenda -- Dave Peterson |
#5
|
|||
|
|||
If you saved the smaller files as .csv files, then you excel should have
imported it ok. But if you have a different list separator in your control panel|regional settings applet than what shows up in those .csv files, you could have trouble. For instance, I use comma to separate my fields. I have that windows setting to comma. It works ok. If you use a semicolon as your separator and the data contains commas, you could have trouble. If you have your data in excel already (each worksheet has just one used column, right???). You can use the Data|Text to columns for each worksheet and specify the field separator. That dialog will look just like the import text wizard. kookaburra wrote: Thanks, Dave It wouldn't open in wordpad (file too big) but I opened it in the Winzip suggested text editor. Data of course appeared as comma delimited and, whilst I copied it in sections and pasted to Excel, it is still in csv format. I tried saving data as a CSV file and thought that if I reopened it would allow a data conversion process. It didn't. Any ideas? thanks Glenda "Dave Peterson" wrote: Maybe you can open it in Notepad (or your favorite text editor) and save it into smaller bite size pieces. Then import each smaller piece into its own worksheet/workbook. kookaburra wrote: How do I transfer a zipped csv file to Excel where the zipped file contents are too large to fit into the 65k+ rows in Excel? I get the message "File not loaded completely" when I open the file. What do I have to do to load the complete contents fo the file? thanks Glenda -- Dave Peterson -- Dave Peterson |
#6
|
|||
|
|||
I had saved the files as .csv and, as you suggested, used Data/Text to
columns and specified the field separator - comma delimited. It worked! Thank you so much. Glenda "Dave Peterson" wrote: If you saved the smaller files as .csv files, then you excel should have imported it ok. But if you have a different list separator in your control panel|regional settings applet than what shows up in those .csv files, you could have trouble. For instance, I use comma to separate my fields. I have that windows setting to comma. It works ok. If you use a semicolon as your separator and the data contains commas, you could have trouble. If you have your data in excel already (each worksheet has just one used column, right???). You can use the Data|Text to columns for each worksheet and specify the field separator. That dialog will look just like the import text wizard. kookaburra wrote: Thanks, Dave It wouldn't open in wordpad (file too big) but I opened it in the Winzip suggested text editor. Data of course appeared as comma delimited and, whilst I copied it in sections and pasted to Excel, it is still in csv format. I tried saving data as a CSV file and thought that if I reopened it would allow a data conversion process. It didn't. Any ideas? thanks Glenda "Dave Peterson" wrote: Maybe you can open it in Notepad (or your favorite text editor) and save it into smaller bite size pieces. Then import each smaller piece into its own worksheet/workbook. kookaburra wrote: How do I transfer a zipped csv file to Excel where the zipped file contents are too large to fit into the 65k+ rows in Excel? I get the message "File not loaded completely" when I open the file. What do I have to do to load the complete contents fo the file? thanks Glenda -- Dave Peterson -- Dave Peterson |
#7
|
|||
|
|||
Thanks very much Bryan.
The file ended up having approx 160,000 lines - wouldn't open in word pad. I could use the view option "Internal ACSII Text Viewer" but wouldn't allow cut and paste or changes. I copied and pasted by section into separate files that I saved as .csv and then received advice (refer above comment) that I should use the 'Date/Text to columns' option to convert from the comma delimited format. It worked. Thanks again "Bryan Hessey" wrote: You could open the .csv file in Notepad (I don't think Notepad has a size limit), delete the first 65,536 lines (the data already loaded into Excel), save the .csv file as Part 2 and open that into Excel. You can probably locate the correct line in Notepad by a search on the data shown in the last row of the partial load. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=390432 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Saved *.csv file gives SYLK file type warning upon Excel 2003 open | Excel Discussion (Misc queries) | |||
Double-clicking .xls file opens Excel but doesn't open the file | Excel Discussion (Misc queries) | |||
Can anyone tell me how to transfer an Excel file to a Pocket PC? | Excel Discussion (Misc queries) | |||
Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) |