iPhone app to open and edit Excel documents

August 2, 2010 12:47 PM

iPhoneAppFilter: I have an Excel document on my home computer that I would like to be able to open and edit on my iPhone while I'm out and about, on an ongoing basis. The catch: app needs to be able to handle "index" and "match" functions. Without this functionality, the app would be useless to me. List of previous disappointments: DropBox (can't edit), QuickOffice (interfaces with DropBox but can't do index/match functions), Calc Lite (can't open document). I have zero programming skills and not that much more cash. Is my dream app (or combination of apps) out there?
posted by shortskirtlongjacket to Technology (8 answers total)

Google Documents might work for you. You can upload and convert your Excel spreadsheet and view/edit on your iPhone. Index() and Match() will work, but you won't be able to edit the formulas on your iPhone and the default view is "List" view, which may take some getting used to.
posted by hammurderer at 12:51 PM on August 2, 2010

Sorry, and it would be accessed through Safari (http://docs.google.com).
posted by hammurderer at 12:52 PM on August 2, 2010

Google Docs.
posted by goblinbox at 1:05 PM on August 2, 2010

Best answer: I've found the support for Google Docs spreadsheets... uneven. If that doesn't work for you, try DataViz' Documents to Go. It's pricey, but it works really, really well.
posted by OneMonkeysUncle at 2:22 PM on August 2, 2010

Best answer: Here you go, a list of supported functions for Documents To Go. It looks like the app supports both Match and Index.
posted by golden at 2:25 PM on August 2, 2010

PS - you can put it in DropBox to access it both at home and on your iPhone, missed that part.
posted by golden at 2:26 PM on August 2, 2010

Best answer: I don't have an iPhone, but I have Documents to Go for Android and I'd recommend it for this. Google Docs is going to be frustrating, I think, for this. Of course, you'll still need something like Dropbox to sync the file across both places.
posted by me & my monkey at 3:56 PM on August 2, 2010

Response by poster: Docs to Go (Premium) + DropBox for the win! Thanks everyone.
posted by shortskirtlongjacket at 1:45 PM on August 3, 2010