{"id":28546,"date":"2020-04-02T17:07:16","date_gmt":"2020-04-02T21:07:16","guid":{"rendered":"https:\/\/mjtsai.com\/blog\/?p=28546"},"modified":"2020-04-02T17:07:16","modified_gmt":"2020-04-02T21:07:16","slug":"opening-large-csv-files-in-numbers-10-0","status":"publish","type":"post","link":"https:\/\/mjtsai.com\/blog\/2020\/04\/02\/opening-large-csv-files-in-numbers-10-0\/","title":{"rendered":"Opening Large CSV Files in Numbers 10.0"},"content":{"rendered":"

Apple<\/a>:<\/p>\n

\n

Numbers 10.0 is optimized for the best possible performance when working with large data sets.<\/p>\n

Numbers 10.0 features improved performance for data import, export, and charting. In Numbers 10.0 on iPhone, iPad, iPod touch, and Mac, you can create, edit, and view spreadsheets with tables that contain up to 1,000,000 rows and 1,000 columns. In Numbers for iCloud, you can create and edit spreadsheets with tables that contain up to 65,535 rows or 256 columns, and open and view spreadsheets and tables larger than that.<\/p>\n<\/blockquote>\n

Previously, the Mac and iOS versions only supported 255 columns<\/a>. Alas, 1,000 columns still isn’t enough<\/a> for some people.<\/p>\n\n

To check out Apple’s performance claims, I tried opening a 34 MB CSV file. Numbers 10.0 took 47 seconds and used 2.18 GB of private memory. Microsoft Excel 16.36 took 5 seconds and used 220 MB of private memory.<\/p>\n\n

So Numbers took 9.4 times as long as Excel, which isn’t great. But it’s an improvement over my test of Numbers ’13 and Excel 2011, where Numbers took 102 times as long as Excel.<\/p>\n\n

See also: MacRumors<\/a>.<\/p>\n\n

Previously:<\/p>\n