• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 606
  • Last Modified:

how to open excel file size more than 2 GB

I download files generated by our company ERP reporting system, i downloaded a file which has more than 2 million rows data.  the file downloaded in .xls file but when i open it excel cannot open it, because it goes beyond the limit that excel can handle. even excel 64bit cannot help here.  

what i need is to be able to change the file format to text or some other type that i can import this to any other program and then split the file in chunks that can be opened.

can anyone please share how to handle this issue?

what tool or software should i use to accomplish what i need to achieve described above?

2 Solutions
Rob HensonFinance AnalystCommented:
Do you have MS Access? That does not have a limit to the number of rows of data.

If you import into access you could then set queries or filters to extract data in chunks or even just leave in Access and then use that as the data source for work in Excel.
Zaheer IqbalTechnical Assurance & ImplementationCommented:
Have you tried to exporting xlsx instead of xls ?
nathanielIT ConsultantCommented:
try generating in .csv format from ERP or if you are familiar with Access you can import the excel file there (in External Data menu) and manipulate it thru the Query, like what Rob is suggesting.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now