Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!
Subscribe for Free Excel tips & more!

What Is The Maximum Number Of Rows In An Excel Spreadsheet ?

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

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 ?

View Answers     

Similar Excel Tutorials

Return the Max Number from a Range That is Within a Minimum and Maximum Target Value in Excel - UDF
Return the highest number between two numbers that is in a range of cells with this UDF (user defined function) in ...
Delete Rows in Excel if Completely Empty
This macro will delete only completely blank rows in an excel spreadsheet. It allows you to make a selection of ro ...
Delete Hidden Rows in a Workbook
This macro will delete hidden rows from every worksheet in an entire workbook. However, note that this will only d ...
Highlight Every Other Row in a Selection in Excel - Table Formatting
This free Excel macro will highlight every other row in a selection of cells with a color that is specified within ...

Helpful Excel Macros

Delete Rows in Excel if Completely Empty
- This macro will delete only completely blank rows in an excel spreadsheet. It allows you to make a selection of rows, ru
Delete Hidden Rows in a Workbook
- This macro will delete hidden rows from every worksheet in an entire workbook. However, note that this will only delete
Delete Blank Rows in Excel
- This is a macro which will delete blank rows in excel. This version will delete an entire row if there is a blank cell
Delete Entire Rows Based on Predefined Criteria (Text)
- This macro will allow you to specify certain criteria and then to delete rows based upon that criteria. You will choose
Delete Duplicate Rows
- This macro will delete rows that appear twice in a list or worksheet. If two cells are identical, this macro will delete

Similar Topics

I need to import a csv file that has more than 65536 rows of data and 20
columns, is there a way of setting up a vba macro so that once the 65536 has
been reached, the continuation moves onto the next sheet?

the maximum of number of rows that are available in an excel sheet are only
65536,i would like to enhance it to my choice. Plase mail me how can i do it
,either by writing a macro , or other way. please also mail me the entire
procedure, where to correct and where to run the macro etc.


In Excel the maximum number of rows i can get is 65536. Is it possible to
extend this so i can get about 67000 rows?

Kind regards

Allan Bach


I have a 10MB .csv file having some 200,000+ rows and 3 columns.
I obviously can open the file in any other plain text editor.
But when I open this in MS Excel 2003, I get the msg File Not Loaded Completely.
The details are

This error is usually encountered when an attempt to open a file with more than 65,536 rows or 256 columns is made. Excel is limited to 65,536 rows of data and 256 columns per worksheet. You can have many worksheets with this number of rows and columns...

So how would I go abt saving this entire .csv file as .xls ? The latter part (after 65536) is getting truncated.
Is there any solution to this ?


I am working w/Excel 2007, and the maximum number of rows available is defaulting to the older excel 2003 allowable rows of 65536, instead of the over 1 million rows. I'm looking for where the default is maintained, and haven't had any luck. Any ideas?

Hello guys, I need to know is there a way to have Excel Go beyond 65536 when generating from other files? I heard there's a method where it creates a new sheet when the 65536 is filled up but I'm using these data for analysis, so i'd need to plot graphs etc so is it possible to plot 1 graphs for all the data gathered in few worksheet?

Anyone can tell me why Excel limited the max rows to 65536?

hi membes,

i wan t to import data of about 800000 rows from a data base to ms excel but there are just 65536 rows in excel sheet.
is there any way thrrough which i could import data or could increase the row from 65536 to 80000.

hi membes,

i wan t to import data of about 800000 rows from a data base to ms excel but there are just 65536 rows in excel sheet.
is there any way thrrough which i could import data or could increase the row from 65536 to 80000.

I've got several workbooks with more than 65536 rows. When I try to open it in excel, i am informed via pop-up message that it will not open a document with more than 65536 rows. (They are in CSV format). It tells me to try to open it in word and then copy it into excel. Has anyone ever experienced this? Is there an efficient way to circumvent it with Excel 2003 and microsoft word? What should I do?

Thank You,


Hi i need have 50 000 data in one column.. so meaning 50 000 rows flowing down.. excel has the limit to 65536 rows..

I need to plot the normal distribution curve of the 50 000 datas in matlab.. these data are now in separate files in excel.. but i need them to be combined into a file so i can do my curve.. is there any way i can have a flow if 50 000 data in a excel file?




How can we put in data on more than the limit for excel - 65536 rows. I don't want to put them in another worksheet coz I have to link this with another one using vlookup- which is very convenient for a single table

please help.


As I know the number of the rows in one sheet in excel is 65536. The question is can we increse the rows of the sheet more than 65536.

Using Excel 2003 I have a macro to run the Text Import Wizard.

How do I code the error trap and reporting prior to terminating the macro when the file to be imported exceeds the maximum allowed number of rows, 65536.

Your help is appreciated.

Hi All

I'm struggling to import data into Excel 2003 from a text file which will produce more than 65536 rows of data...

Normally when this occours I use a routine that has served me well in the past from, but it's not working for me this time.

The format of the file appears to be both TAB and , (comma) delimited, when I try to import the file from the 'Data > Import External Data' and select 'TAB' and / or 'Comma' as the delimeters the file imports fine up to the row limit.

When I tried to use the code linked to above the results where just one row of data upto Column IV and nothing else. (It should only produce two columns of data)

I changed the line;


SplitChar = ","



SplitChar = vbTab

And this gave me an Out of Memory error on the section;


            If Colndx + C_START_COLUMN

I have to generate a piviot table based on excel data,but the data is crossing more than 65536 rows,which is maximum an excel sheet can hold.

Is there any alternative to generate pivot table?

Believe it or not I need and excel sheet with more than the given 65536 rows. Is there a way to get more rows or is that the maximum available?

I am trying to write a macro that will allow me to open a .csv file that has more than 65536 rows. Is there a way to open this file in which lines beyond row 65536 will open in a separate tab?

Hello, I am using Excel 2003 on Windows XP. I need to import over 71,000 rows of data from a text file.

Currently, I open Excel 2003 and select: Data \ Import External Data \ Import Data

Then I select H:\My Documents\Data.txt file.

I then use the Text Import Wizard to finish importing my data.

I can also create a macro to do this by using the Macro Recorder.

Please Login or Register  to view this content.

However, I have over 71,000 employees to be added to my workbook and my Excel 2003 only has 65536 rows in each worksheet.

Can someone be please kind enough to help me with some VBA code so that when I import my data using the Text Import Wizard (as shown in my code above), it will firstly populate "Sheet1" and when it is full (i.e. over 65536 rows), the remainder of the data will automatically populate into "Sheet2" as shown in my attached example workbook.

Any help would be greatly appreciated.

Kind regards,



I am using Excel97 and I try to create a pivot table getting external data form Ms Access. In Access, my database has over 120,000 records equivalent to 120,000 rows in Excel. I noticed that Excel has only 65536 rows in each worksheet. How can I increase this maximum rows so that could I paste the 120,000 records onto the worksheet?


Using Excel 2003.
?Sheet2.UsedRange.Address gives $1:$65536; i.e., all rows

But there's nothing below row 200.
I've tried Activesheet.UsedRange (followed by Save),
deleting all rows below 200 (actually deleting the rows, not just the contents),
checking for Shapes and Merged cells, etc.

The UsedRange remains $1:$65536.

Any ideas?

Hi can someone solve my problem?

I use following code to post values of textboxes into cells:

Private Sub CommandButton_Add_Click()

Cells(65536, 2).End(xlUp).Offset(1, 0) = TextBox_Briefing.Value
Cells(65536, 2).End(xlUp).Offset(0, 1) = TextBox_Status.Value
Cells(65536, 2).End(xlUp).Offset(0, 2) = TextBox_Client2.Value
Cells(65536, 2).End(xlUp).Offset(0, 3) = TextBox_Technical.Value
Cells(65536, 2).End(xlUp).Offset(0, 4) = TextBox_StartingDate.Value
Cells(65536, 2).End(xlUp).Offset(0, 5) = TextBox_TargetDate.Value
Cells(65536, 2).End(xlUp).Offset(0, 6) = TextBox_SalesRep.Value
Cells(65536, 2).End(xlUp).Offset(0, 7) = TextBox_TypeIndustry2.Value
Cells(65536, 2).End(xlUp).Offset(0, 8) = TextBox_Origine2.Value
Cells(65536, 2).End(xlUp).Offset(0, 9) = TextBox_Repeat.Value
Cells(65536, 2).End(xlUp).Offset(0, 10) = TextBox_ActionMarketing.Value
Cells(65536, 2).End(xlUp).Offset(0, 11) = TextBox_TO.Value
Cells(65536, 2).End(xlUp).Offset(0, 12) = TextBox_PL.Value

End Sub

I want them to be posted 1 row down. A17 in stead of A16.
What do I do wrong?

I have attached the file: code is on sheet "StatusReport"

Morning all,

Can someone tell me if Excel 2000 has a maximum sort limit in terms of
number of rows? The reason I ask is that the spreadsheet we are currently
using is 17000 or so rows and when it is sorted there is still a large number
of rows that appear to be unsorted.

Thanks in advance for any assistance

Hi All,

i am stuck in a problem here. i have a csv file which has more than 65536 rows and i want macro that import the csv file into excel and after 30000 rows the data should go to the next sheet and if sheet is not there it should insert a new sheet and then import the next data.

thanks in advance

I'm currently using the sumproduct function to sum data with multiple criteria.. The data I am using increases in size (range) each week. Currently I have my formula using references to row 65536... this results in each change taking a couple of minutes to calculate...

Could someone tell me a formula I can use in place of $A$2:$A$65536 so that the calculation only calculates rows with data and not the thousands of blank rows below...

Many thanks for any help.


Hi guys,

Not so much a vba question but a puzzling on nonetheless.

I have a huge text file, way over 65000 rows, probably fill a few dozen

Obviously the text import wizard will only fill down to 65536. However when
I actually import I get a message saying I can carry on the import in a new
sheet telling the wizard to not import rows that I've already imported.

But I cannot find any facility to do this anywhere in the wizard.

Anyone come accross this and gotten over this hurdle?