when opening a csv in excel

  • Thread starter Thread starter Victoria
  • Start date Start date
V

Victoria

is there a size limitation? I am getting an erro message
that says "file not loaded completely"

any help would be greatly appreciated.

Victoria
 
I'm not aware of a size limitation, see Excel help? Does
your csv file have an end-of-file marker? Is the file
corrupted yet readable. Excel may be saying it can't find
the end of file.
 
You are limited to excels 65,536 rows by 256 columns.

There are some macro's floating around that will split
files to multiple sheets.

Dan E
 
Excel has 65536 rows and 256 columns.

If your data needed 65537 rows, you'd get the error. (same thing with too many
columns, too.)

I'd use my favorite text editor and split it into smaller pieces. Then import
each piece separately.

but MS developed a macro that imports each line if you have too many rows:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q120596
XL: Importing Text Files Larger Than 16384 Rows
(written for xl95, but has a note to change stuff for xl97+)
 
Back
Top