Home

Excel for Mac dropping data? 16384 rows only

%3CLINGO-SUB%20id%3D%22lingo-sub-689096%22%20slang%3D%22en-US%22%3EExcel%20for%20Mac%20dropping%20data%3F%2016384%20rows%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-689096%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%20for%20Mac%2016.26%3CBR%20%2F%3EMAC%20OS%2010.14.4%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EDoing%20some%20contract%20work%20where%20I%20retrieve%20data%20files%2C%20download%20to%20Excel%2C%20clean%20and%20transform%20data.%2C%20and%20upload%20to%20our%20company%20database.%3CBR%20%2F%3E%3CBR%20%2F%3EToday%20I%20downloaded%20a%20large%20file%2C%20over%20200K%20records.%20I%20was%20required%20to%20download%20in%20csv.%20Then%20converted%20this%20to%20xls.%20I%20checked%20that%20it%20had%20200K%20records.%20After%20doing%20my%20work%20on%20it%2C%20I%20save%20it%20and%20go%20to%20upload%20to%20our%20company%20database.%20My%20excel%20file%20has%20dropped%20data.%26nbsp%3B%20From%20over%20200K%20rows%20it%20now%20has%20only%2016%2C384.%26nbsp%3B%20Not%20sure%20when%20or%20how.%3CBR%20%2F%3E%3CBR%20%2F%3EIt%20also%20happened%20on%20a%20separate%20file%20today%2C%2096K%20rows%20to%2016%2C384.%26nbsp%3B%20That's%20when%20I%20realized%20there%20was%20a%20pattern%20here%20and%20it%20was%20most%20likely%20an%20Excel%20for%20Mac%20issue.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EWhat's%20going%20on%20here%3F%3CBR%20%2F%3E%3CBR%20%2F%3ESeems%20to%20be%20specific%20to%20the%20csv%20converted%20files.%20Haven't%20noticed%20similar%20problems%20with%20regular%20Excel%20files.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-689096%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-689103%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20for%20Mac%20dropping%20data%3F%2016384%20rows%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-689103%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F359343%22%20target%3D%22_blank%22%3E%40ascott72%3C%2FA%3Eyou%20might%20be%20better%20saving%20your%20data%20in%20CSV%20format%20and%20then%20uploading.%20use%20extension%20TXT%20and%20upload%20it%20as%20a%20TEXT%20file.%26nbsp%3B%20XLS%20is%20the%20old%20extension%20and%20under%20windows%20there%20is%20a%20limit%20of%20around%2064%2C000%20rows.%20Maybe%20on%20a%20MAC%20is%2016%2C384.%26nbsp%3B%20A%20text%20file%20shouldn't%20have%20any%20restrictions.%3C%2FP%3E%3C%2FLINGO-BODY%3E
ascott72
Occasional Visitor

Excel for Mac 16.26
MAC OS 10.14.4


Doing some contract work where I retrieve data files, download to Excel, clean and transform data., and upload to our company database.

Today I downloaded a large file, over 200K records. I was required to download in csv. Then converted this to xls. I checked that it had 200K records. After doing my work on it, I save it and go to upload to our company database. My excel file has dropped data.  From over 200K rows it now has only 16,384.  Not sure when or how.

It also happened on a separate file today, 96K rows to 16,384.  That's when I realized there was a pattern here and it was most likely an Excel for Mac issue. 

What's going on here?

Seems to be specific to the csv converted files. Haven't noticed similar problems with regular Excel files.



1 Reply

@ascott72you might be better saving your data in CSV format and then uploading. use extension TXT and upload it as a TEXT file.  XLS is the old extension and under windows there is a limit of around 64,000 rows. Maybe on a MAC is 16,384.  A text file shouldn't have any restrictions.

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies