Home

Size increase when saving spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-856380%22%20slang%3D%22en-US%22%3ESize%20increase%20when%20saving%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-856380%22%20slang%3D%22en-US%22%3EI%20am%20working%20in%20a%20new%20company%20and%20I%20have%20noted%20the%20excel%20file%20sizes%20are%20ridiculously%20big.%20Just%20for%20an%20example%20to%20prove%20my%20point%2C%20I%20work%20with%20SAS%20and%20export%20data%20into%20excel%20files%2C%20a%201M%20file%20output%20from%20SAS%20when%20I%20just%20open%2C%20save%20it%20and%20close%20it%20with%20excel%202016%2064bits%2C%20turns%20into%20a%20size%20of%202.7M.%20Is%20there%20any%20thing%20I%20could%20do%20to%20fix%20this%3F%20...%20power%20pivot%20and%20data%20models%20is%20exactly%20the%20same%20with%20160k%20records%2C%2020%20Columns%20are%2038M%20file%20...%20when%20working%20in%20another%20place%20with%20more%20complex%20data%20model%20over%20800k%20records%20was%20only%208M.%20I%20would%20really%20appreciate%20any%20insight%20you%20could%20provide%20on%20this%20regards%2C%20thanks%20in%20advance%2C%20Irene%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-856380%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-856425%22%20slang%3D%22en-US%22%3ERe%3A%20Size%20increase%20when%20saving%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-856425%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F409037%22%20target%3D%22_blank%22%3E%40IPF_au%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20data%20model%20size%20will%20depend%20on%20the%20uniqueness%20of%20data.%26nbsp%3B%20The%20more%20columns%20with%20more%20unique%20items%20will%20be%20harder%20to%20compress%20and%20therefore%20a%20200k%20row%20table%20of%20unique%20data%20would%20be%20much%20bigger%20in%20MB%20than%20a%201%20million%20row%20table%20with%20less%20unique%20data.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20terms%20of%20your%20non%20data%20model%20Excel%20file%20growing%20to%202MB%20from%20a%201MB%20file%2C%20I'm%20not%20sure.%26nbsp%3B%20If%20it's%20a%20single%20sheet%20you%20could%20try%20pressing%20End%20then%20Home%20to%20check%20that%20unused%20columns%2Frows%20aren't%20being%20used.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMight%20be%20expected%20that%20a%201MB%20text%20file%20becomes%20a%202MB%20Excel%20file.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
IPF_au
Visitor
I am working in a new company and I have noted the excel file sizes are ridiculously big. Just for an example to prove my point, I work with SAS and export data into excel files, a 1M file output from SAS when I just open, save it and close it with excel 2016 64bits, turns into a size of 2.7M. Is there any thing I could do to fix this? ... power pivot and data models is exactly the same with 160k records, 20 Columns are 38M file ... when working in another place with more complex data model over 800k records was only 8M. I would really appreciate any insight you could provide on this regards, thanks in advance, Irene
1 Reply

Hi @IPF_au 

 

The data model size will depend on the uniqueness of data.  The more columns with more unique items will be harder to compress and therefore a 200k row table of unique data would be much bigger in MB than a 1 million row table with less unique data.

 

In terms of your non data model Excel file growing to 2MB from a 1MB file, I'm not sure.  If it's a single sheet you could try pressing End then Home to check that unused columns/rows aren't being used.  

 

Might be expected that a 1MB text file becomes a 2MB Excel file.

 

 

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies