csv load 64K workaround

G

Guest

Can anyone help me with the following problem?

I have a csv file that I'm trying to load into excel, it has about 80000
rows but I know the row limit of excel is 65536 has anyone been able to load
more than that?

Any help would be appreciated

Thanks

Rodrigo
 
N

N Harkawat

open it in Word or wordpad
cust and paste 65K lines in one sheet
and the rest in other sheet
 

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

CSV loading incorrect 2
CSV decoding line-by-line 15
Excel Excel CSV file 6
100Ah 12v Battery voltage under load 7
CSV file containing Thai characters does not load into right colum 2
opening text files that have more rows than 65536 3
Sorting a csv 2
Adding a header to a CSV file 4

Top