How big can files be to import to excel, and is there a rec limit?

M

MHayashisan

I am having problems importing a very large .csv file into excel and keep
getting an error message saying that the file is too big. What's up with that?
 
F

FastLiveHelp

Hello,

The worksheet limits on Excel are: 65,536 rows by 256 columns.

If your csv has more than 65,536 lines of text in it that is most
likely your problem.

You could either get a program to split your file into chunks or do it
with an Excel macro and then import the chunks into separate
worksheets.
 
D

Dave Peterson

There are 256 columns and 65536 rows in any excel worksheet.

How many lines/fields are in your .csv file?
 
Top