troubleshooting Question

Convert a GIGANTIC Excel (.xls) file

Avatar of jeremyspringer
jeremyspringer asked on
Microsoft ExcelMicrosoft Applications
2 Comments1 Solution223 ViewsLast Modified:
I just received an excel file containing data (there shouldn't be any formulas) from the MIS department of a company I'm working with. Unfortunately the file is 1.3 gb and I can't open it without crashing my computer. Does anybody know of any utilities that convert excel files to text files without having to open the file in Excel. Something that converts the file line by line would be ideal as I think the crash is caused by trying to open the entire dataset in memory.

Thanks
ASKER CERTIFIED SOLUTION
folderol

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros