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
Highlighted
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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 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
30 Replies