# How to reduce time while opening large data workbooks of 800 MB

I work as a data analyst and have to encounter difficulty everyday regarding large data files of almost 800 MB and it takes quite a lot of time to open and my precious time is lost because of that if there is any shortcut to open data quickly kindly share

##### Post Metadata
- Posted at: over 5 years ago
- Author title: Monitoring & Control Officer | Passionate about Data Science 
- Net upvotes: 1


## Comments
### Comment 1

Just to be clear on something: I am COMPLETELY AGAINST having large data files for multiple reasons, data loss because of a faulty connection or hardware failure being the two main ones.
If you are not considering creating multiple files and connecting them via primary/secondary keys, then I strongly advise you to either a) stop saving as XLS/XLSX and use XLSB instead (EXCEL BINARY), or, b) switch to XML.
These are the only two propositions I can think of, short of switching to a SQL database.

##### Comment Metadata
- Posted at: about 5 years ago
- Author title: School Information System Administrator at Champville



### Comment 2

I work as a data analyst and have to encounter difficulty everyday regarding large data files of almost 800 MB and it takes quite a lot of time to open and my precious time is lost because of that if there is any shortcut to open data quickly kindly share

##### Comment Metadata
- Posted at: over 5 years ago
- Author title: --




## Related Product
[Microsoft Excel](https://www.g2.com/products/microsoft-excel/reviews)

## Related Category
[Spreadsheets](https://www.g2.com/categories/spreadsheets)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: about 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: about 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: about 13 years ago
  - Comments: 4