Text file format is taking up more space than Excel file format

1143015 pts.
Tags:
Microsoft Excel
text files
In my Microsoft Excel spreadsheet, my data is in roughly 10,000 rows. But when I stored the data as a text file, it's taking way too much space. Why is it different as a text file than an Excel file format?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Different file formats store data differently. Two main reasons for file size differences could be one format is most likely compressing out the blank/whitespace. The other reason is the file has some type of formatting.  How much of a difference in size is based on the size of the Excel data. I ran a quick comparison 2,000 row by 26 columns in Excel. Size 147k Saved as MS-DOS TXT and it’s 228k.. Not  big concern in difference.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TheRealRaven
    Why shouldn't it be larger? Text can be a very inefficient format. But what format was the spreadsheet saved as?
    35,130 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: