What is the maximum number of rows in an Excel spreadsheet ?

[Guest]

I have a csv file that I try to import into Excel and the number of rows is
larger thatn 65536. The Excel 2000 seemed to be only capable of loading 65536
rows. Is there a way to overcome this ?

 

[Dave Patrick]

Me thinks you need an Access solution.

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
|I have a csv file that I try to import into Excel and the number of rows is
| larger thatn 65536. The Excel 2000 seemed to be only capable of loading
65536
| rows. Is there a way to overcome this ?

 

[Guest]

Nope... 65,536 rows and 256 columns are written in stone. See the hundreds
of other posts with this exact subject.

 

[Timothy L]

Description of Excel 2000 specifications
http://support.microsoft.com/kb/264626/


Start another Worksheet and then import the remaining portion of your CSV file by using the Text Import
Wizard.

Please note: The instructions below are for Microsoft Excel 2003, but should work in Microsoft Excel 2000.


Insert a new worksheet
http://office.microsoft.com/en-us/assistance/HP052008891033.aspx


Import a text file
http://office.microsoft.com/en-us/assistance/HP052573861033.aspx

When you get to step 5, you should have the "Text Import Wizard - Step 1 of 3" dialog up. In Step 1 of the
Text Import Wizard, change the value next to "Start import at row" to 65537.



In addition, you might want to take a look at this program called CSVed. It is an easy and powerful CSV file
editor.
http://home.hccnet.nl/s.j.francke/t2t/text2table.htm

 

[Ron Rosenfeld]

On Tue, 20 Sep 2005 08:54:01 -0700, Larry Liu <Larry

I have a csv file that I try to import into Excel and the number of rows is
larger thatn 65536. The Excel 2000 seemed to be only capable of loading 65536
rows. Is there a way to overcome this ?

If you must load the data into Excel, you will have to either load only a
sample of your data (e.g. every tenth record); or use multiple worksheets.

Both of those solutions require VBA programming.

If this is a large DB, you should look for a different solution (e.g. Microsoft
Access).


--ron

 

[Gord Dibben]

Larry

One way to oversome this limitation is to split your csv file into smaller
files which can be imported to separate worksheets.


Gord Dibben Excel MVP

On Tue, 20 Sep 2005 08:54:01 -0700, Larry Liu <Larry