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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
There are 256 columns and 65536 rows in any excel worksheet.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel/XML File Limitations 2
Excel And Notepad 3
Import large number string 1
xml import....Size limit?? Can the XML file be split?? 0
Excel CSV Files; Creating Of 3
Access Importing csv daily files into access 2007 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Import more than one .csv file into the same Excel file. 1

Back
Top