Importing big text file into separate excel sheet

[Sridharmak]

Hi friends,

This is sridhar. Actually I am facing a problem while importing big text file into excel sheet. Please any one help me on this.

Thanks in Advance,

[adyteo]

I am not sure I totally understand the problem you are facing. It would be good if you can detail it. Also, a sample file would really help.

[Sridharmak]

Hi,

Thanks a lot for your quick reply. Actually I have got the data with 408,192 kb data with 40 different fields.
I wouldlike to dump it in excel. when I was trying to dump it in excel it's dumping only 65,536 . Remaining I am not able to.

Thanks,
Sridhar

[adyteo]

Only Excel 2010 and newer allow for more than 65,535 rows (Excel 2010 allows for more than a million rows). What you need is a code to parse the input file (csv, txt?) and create different sheets each one with max 65,535 rows.
In order for a forum member to help you, we would probably need to see an example of the raw file (not the complete one, but a sample).

[Sridharmak]

Hi,

I have attached Sample Data.xls for your reference.

[millz]

Only Excel 2010 and newer allow for more than 65,535 rows

Just to correct this, Excel 2007 also supports 1048576 rows.

@Sridhar, you are most likely using a .xls file, which is limiting your rows to only 65536. Try saving your file as .xlsx, close and reopen it, and then try importing again.

[apo]

There is no attachment...