Need to export to a CSV but my file has more than 65536 rows

[laredotornado]

Hi,

I'm using MS Excel 2003 on Win XP. I have a very large file and when
I open it I only see 65,536 rows. I want to save it to CSV (text) but
I'm afraid if I do "Save As..." I'll only be saving out the first
65,536 rows.

Is there a way to export to CSV and keep all rows?

Thanks, - Dave

 

[Pete_UK]

Do you mean that you have follow-on rows in a second sheet in the same
file?

Pete

 

[Niek Otten]

Hi Dave,

In Excel 2003 there are just 65536 rows (per sheet).
What makes you think you have more?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
|
| I'm using MS Excel 2003 on Win XP. I have a very large file and when
| I open it I only see 65,536 rows. I want to save it to CSV (text) but
| I'm afraid if I do "Save As..." I'll only be saving out the first
| 65,536 rows.
|
| Is there a way to export to CSV and keep all rows?
|
| Thanks, - Dave

 

[Earl Kiosterud]

Dave,

First of all, the problem isn't a save problem -- the problem is that Excel 2003 and prior
only hold 65K rows per sheet. Using Excel 2007, with its million rows per sheet, is one
solution. Presumably your data came from some file -- you don't say anything about it.
Another would be to write a macro that reads your input file, whatever that is, and filled a
sheet, then next sheet, then the next, etc. But then you'd need a macro to write the CSV,
since Save As only saves one sheet. You can use the code in the Text Write Program at
www.smokeylake.com/excel to handle the CSV formatting issues -- you'd just have to modify it
to write consecutive sheets to one file.

Say more about the input file.

 

[laredotornado]

Dave,

First of all, the problem isn't a save problem -- the problem is that Excel 2003 and prior
only hold 65K rows per sheet.  Using Excel 2007, with its million rows per sheet, is one
solution.  Presumably your data came from some file -- you don't say anything about it.
Another would be to write a macro that reads your input file, whatever that is, and filled a
sheet, then next sheet, then the next, etc.  But then you'd need a macroto write the CSV,
since Save As only saves one sheet.  You can use the code in the Text Write Program atwww.smokeylake.com/excelto handle the CSV formatting issues --you'd just have to modify it
to write consecutive sheets to one file.

Say more about the input file.

--
Regards from Virginia Beach,

Earl Kiosterudwww.smokeylake.com









- Show quoted text -

Thanks all for your responses. The file was auto-generated by a Java
program that read rows from a database and then created a row in the
Excel file for each of them. While I'm not sure yet if there are more
than 65536 rows, the file is 40MB, so I'm guessing there are. Hope
that clarifies things.

Earl, your suggestion about upgrading to Excel 2007 is a good one, but
I may not be able to do that in the short term.

Thanks again, - Dave

 

[Fred Smith]

We can assure you you don't have more than 65,536 rows in your Excel file.
Just hit Ctrl-End to find out.

Regards,
Fred

Dave,

First of all, the problem isn't a save problem -- the problem is that
Excel 2003 and prior
only hold 65K rows per sheet. Using Excel 2007, with its million rows per
sheet, is one
solution. Presumably your data came from some file -- you don't say
anything about it.
Another would be to write a macro that reads your input file, whatever
that is, and filled a
sheet, then next sheet, then the next, etc. But then you'd need a macro to
write the CSV,
since Save As only saves one sheet. You can use the code in the Text Write
Program atwww.smokeylake.com/excelto handle the CSV formatting issues --
you'd just have to modify it
to write consecutive sheets to one file.

Say more about the input file.

--
Regards from Virginia Beach,

Earl Kiosterudwww.smokeylake.com

----------------------------------------------------------------------"laredotornado"








- Show quoted text -

Thanks all for your responses. The file was auto-generated by a Java
program that read rows from a database and then created a row in the
Excel file for each of them. While I'm not sure yet if there are more
than 65536 rows, the file is 40MB, so I'm guessing there are. Hope
that clarifies things.

Earl, your suggestion about upgrading to Excel 2007 is a good one, but
I may not be able to do that in the short term.

Thanks again, - Dave

 

[laredotornado]

We can assure you you don't have more than 65,536 rows in your Excel file.
Just hit Ctrl-End to find out.

Regards,
Fred









Thanks all for your responses.  The file was auto-generated by a Java
program that read rows from a database and then created a row in the
Excel file for each of them.  While I'm not sure yet if there are more
than 65536 rows, the file is 40MB, so I'm guessing there are.  Hope
that clarifies things.

Earl, your suggestion about upgrading to Excel 2007 is a good one, but
I may not be able to do that in the short term.

Thanks again, - Dave- Hide quoted text -

- Show quoted text -

I did as you said and it took me to row 65536 and column AM, which
happened to be the last column in my spreadsheet. - Dave