excel crashing when saving csv to xlsx on mac

%3CLINGO-SUB%20id%3D%22lingo-sub-2738211%22%20slang%3D%22en-US%22%3Eexcel%20crashing%20when%20saving%20csv%20to%20xlsx%20on%20mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2738211%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20running%20Microsoft%20Excel%20for%20Mac%202021%20(macOS%20Catalina%20v%2010.15.7)%20and%20suddenly%2C%20when%20saving%20a%20csv%20file%20to%20xlsx%2C%20Excel%20hangs%20up%2Fstops%20working%20and%20I%20have%20to%20force%20quit%20in%20order%20to%20proceed.%26nbsp%3B%20The%20csv%20never%20saves%20in%20excel%20format%26nbsp%3B%20Help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2738211%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2739839%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20crashing%20when%20saving%20csv%20to%20xlsx%20on%20mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2739839%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1151537%22%20target%3D%22_blank%22%3E%40NAOJKB%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHard%20to%20give%20help%20without%20a%20bit%20more%20info.%3C%2FP%3E%3CUL%3E%3CLI%3ESo%2C%20first%2C%20can%20you%20confirm%3A%26nbsp%3Bthis%20happens%20repeatedly--after%20the%20force-quite%20and%20then%20re-load%20of%20the%20csv%20file%2C%20it%20will%20again%20crash%3C%2FLI%3E%3CLI%3ESecond%3A%20have%20you%20been%20able%20to%20be%20successful%20in%20the%20past%20with%20converting%20csv%20to%20xlsx%2C%20with%20other%20comparable%20files%3F%3C%2FLI%3E%3CLI%3EThird%3A%20could%20%26nbsp%3Byou%20describe%20anything%20unusual%20about%20this%20particular%20csv%20file%20itself%20when%20compared%20with%20others%20you've%20converted%20in%20the%20past--size%2C%20nature%20of%20data%2C%20whatever%3C%2FLI%3E%3CLI%3EFourth%3A%20have%20you%20modified%20the%20file%20in%20any%20way--adding%20formulas%2C%20for%20example--before%20going%20to%20the%20%22save%20as%20xlsx%22%20step%3B%20if%20so%2C%20what%20types%20of%20formulas%20or%20functions%3F%3C%2FLI%3E%3C%2FUL%3E%3CP%3EAnd%20if%20there's%20anything%20else%20that%20might%20help%20define%20the%20situation%20further.%20OS%20Catalina%20is%20not%20the%20most%20current%20version%20of%20Mac%20OS%3B%20I%20don't%20know%20if%20updating%20would%20make%20a%20difference.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2751197%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20crashing%20when%20saving%20csv%20to%20xlsx%20on%20mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2751197%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3Bthanks%20for%20your%20reply%2C%20here%20are%20the%20answers%20to%20your%20questions%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3Eyes%2C%20force%20quit%2C%20re-load%2C%20crash%20again%2C%20repeat%3C%2FLI%3E%3CLI%3Eyes%2C%20successful%20with%20other%20csv%20conversions%2C%20problem%20seems%20to%20have%20started%20randomly%26nbsp%3B%3C%2FLI%3E%3CLI%3Enothing%20unusual%2C%20small%20file%20sizes%2C%20have%20converted%20from%20multiple%20sources%20many%20times%20before%3C%2FLI%3E%3CLI%3Eno%20modifications%2C%20download%20csv%2C%20save%20as%20xlxs%20-%20crash%3C%2FLI%3E%3C%2FUL%3E%3CP%3EI%20can%20try%20updating%20the%20OS%2C%20but%20agree%20it%20may%20not%20help.%26nbsp%3B%20LMK%20if%20you%20have%20any%20other%20thoughts!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am running Microsoft Excel for Mac 2021 (macOS Catalina v 10.15.7) and suddenly, when saving a csv file to xlsx, Excel hangs up/stops working and I have to force quit in order to proceed.  The csv never saves in excel format  Help!

2 Replies

@NAOJKB 

 

Hard to give help without a bit more info.

  • So, first, can you confirm: this happens repeatedly--after the force-quite and then re-load of the csv file, it will again crash
  • Second: have you been able to be successful in the past with converting csv to xlsx, with other comparable files?
  • Third: could  you describe anything unusual about this particular csv file itself when compared with others you've converted in the past--size, nature of data, whatever
  • Fourth: have you modified the file in any way--adding formulas, for example--before going to the "save as xlsx" step; if so, what types of formulas or functions?

And if there's anything else that might help define the situation further. OS Catalina is not the most current version of Mac OS; I don't know if updating would make a difference. 

 

@mathetes thanks for your reply, here are the answers to your questions:

 

  • yes, force quit, re-load, crash again, repeat
  • yes, successful with other csv conversions, problem seems to have started randomly 
  • nothing unusual, small file sizes, have converted from multiple sources many times before
  • no modifications, download csv, save as xlxs - crash

I can try updating the OS, but agree it may not help.  LMK if you have any other thoughts!