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
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.