Good Spreadsheet app

thefredelement

macrumors 65816
Original poster
Apr 10, 2012
1,142
559
New York
I'm working on a bunch of pretty intensive spreadsheets... they're some pretty big output from a database dump (the db is pretty terminal in terms of data quality, making a traditional re-import into another database not worth the time of fixing it)

I've been trying to use Excel and Numbers, they both seem to really choke up handling this kind of data, especially with formulas.

I have a Mac Pro 4,1 2x 2.93 Xeons and 16GB of RAM. I need a spreadsheet program that will use this hardware and not get all choked up, any advice?

(In MenuStats I see both Excel & Numbers don't take advantage of any of the hardware really).
 

maflynn

Moderator
Staff member
May 3, 2009
66,802
33,761
Boston
I have to say the best spreadsheet app out there is MS excel, so I'm not sure who else to recommend.

Did you check out Libraoffice - the open source competitor to MS Office?
 

Bear

macrumors G3
Jul 23, 2002
8,088
4
Sol III - Terra
I'm working on a bunch of pretty intensive spreadsheets... they're some pretty big output from a database dump (the db is pretty terminal in terms of data quality, making a traditional re-import into another database not worth the time of fixing it)

I've been trying to use Excel and Numbers, they both seem to really choke up handling this kind of data, especially with formulas.
...
How big a spreadsheet are you talking about? From your comments, it almost sounds like you need a database program.

I have to say the best spreadsheet app out there is MS excel, so I'm not sure who else to recommend.

Did you check out Libraoffice - the open source competitor to MS Office?
Pretty much this, but I dount LibreOffice will be able to handle it either.

maflynn do you think FileMaker might be an option here?
 

ozaz

macrumors 65816
Feb 27, 2011
1,276
285
(In MenuStats I see both Excel & Numbers don't take advantage of any of the hardware really).
If you are able to, maybe try Excel 2013 on a Windows machine. I would imagine it can handle large spreadsheets better than Excel 2011 for Mac.
 

MacUserUK

macrumors member
Oct 25, 2012
93
88
Give OpenOffice.org a go

Other than that MS have the office suite pretty wrapped up
 

GGJstudios

macrumors Westmere
May 16, 2008
44,428
796
I'm working on a bunch of pretty intensive spreadsheets... they're some pretty big output from a database dump (the db is pretty terminal in terms of data quality, making a traditional re-import into another database not worth the time of fixing it)

I've been trying to use Excel and Numbers, they both seem to really choke up handling this kind of data, especially with formulas.
I've used Excel for about the past 20 years, including extensive use of highly complex formulas and very large data sets. I've never had it "choke" unless the computer being used was not sufficient in terms of RAM or processor speed. Your Mac Pro should be more than sufficient. I couldn't recommend anything more powerful or capable than Excel.
 

ApfelKuchen

macrumors 68040
Aug 28, 2012
3,679
2,274
Between the coasts
Just to be clear -
You exported data from a DB (XLS, CSV...??), and are trying to apply formulas to it in Excel/Numbers? If so, how did the spreadsheet behave prior to applying formulas?

Just how many rows/records and columns/fields are involved?

(the db is pretty terminal in terms of data quality, making a traditional re-import into another database not worth the time of fixing it)
Poor-quality data can be just as much a problem for a spreadsheet as it is for a DB. You just may have to clean it up before applying the formulas.
 

exegete77

macrumors 6502a
Feb 12, 2008
529
5
If Excel is choking, then you need database. Consider two alternatives from ProVue Panorama and Panorama Sheets

When I worked full time as an analyst for a Fortune 100 company, I imported huge mainframe data on demand, and Excel (Windows) handled it very well. I used VBA code to do that. I could downloaded hundreds of thousands of data points, automatically set up for viewing data for 99 markets, with nine outlets on a 13 week view. One cell could change all 99 worksheets.

That download and updates into Excel, then into PowerPoint took a total of 22 minutes.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.