csv load 64K workaround

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
open it in Word or wordpad
cust and paste 65K lines in one sheet
and the rest in other sheet
 
You must log in or register to reply here.

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
100Ah 12v Battery voltage under load 7
Importing CSV data 2
What is the maximum number of rows in an Excel spreadsheet ? 5
CSV file containing Thai characters does not load into right colum 2
opening text files that have more rows than 65536 3
Excel And Notepad 3

Back
Top