CODEWITHSUNDEEP
exceltextfilesizediskdiskspace
Ghanshyam Dabhi
Ghanshyam Dabhi

Reputation: 5

Why same data take more space in text file then excel file?

I have data around 100000 rows. If I stored this data in text file format, it takes more space than if I stored it in Excel file format.

Upvotes: 0

Views: 92

Answers (1)

smartobelix
smartobelix

Reputation: 748

Because internally in xslx file data are compressed. They are stored in XML format by later complete file is compressed.

This could be easily checked by changing .xslx extension to .zip and opening by any zip software including Windows Explorer - just double click on it.

So data inside your text file seems to have high compression ratio.

Upvotes: 2

Related Questions