Numbers is the most innovative spreadsheet app ever designed for a mobile device.
Numbers is the most innovative spreadsheet app ever designed for a mobile device. Created exclusively for iPad, iPhone, and iPod touch, Numbers includes support for Multi-Touch gestures and Smart Zoom so you can create powerful spreadsheets using just your fingers. Start with one of over 30 Apple-designed templates for your home budget, checklist, invoice, mortgage calculator, and more. Choose from over 250 powerful functions. Tap to add tables, charts, text, and images anywhere on the free-form canvas. Touch and drag your finger to reorder columns and rows and to resize tables. Double-tap a cell to bring up the intelligent keyboard that helps you enter text, formulas, dates and times, or duration. Animate your data with interactive column, bar, scatter, and bubble charts. And with an all-new calculation engine, Numbers is faster than ever before. With iCloud built in, your spreadsheets are kept up to date across all your devices. And with the release of real-time collaboration, your team will be able to work together at the same time on a Mac, iPad, iPhone, or iPod touch -- even on a PC using iWork for iCloud. Collaborate with others at the same time. With real-time collaboration, your whole team can work together on a spreadsheet at the same time. Collaboration is built right in to Numbers on the Mac, iPad, iPhone and iPod touch. PC users can collaborate too, using Numbers for iCloud. Share your document publicly or with specific people. You can easily see who's currently in the document with you. View other people's cursors to follow their edits. Get started quickly. Over 30 Apple-designed templates give your spreadsheets a beautiful start. Double-tap a cell to access the intelligent keyboard to add text, formulas, dates and times, and more. New action menu keeps most common tasks one tap away. Reorder columns and rows, and resize tables, with a touch and a drag. Import and edit Microsoft Excel and CSV files using Mail, a WebDAV service, or iTunes File Sharing. Quickly open password-protected spreadsheets using Touch ID on supported iPhones. Beautiful spreadsheets. Place tables, charts, text, and images anywhere on the free-form canvas. Update tables, charts, text, and images using beautiful preset styles. Insert photos and video with the Media Browser. Create a form to quickly enter data on the go. Edit down to the pixel with rulers, alignment guides, and powerful graphics tools. Data uncrunched. Choose from over 250 powerful functions. Get built-in help and sample formulas for each function. Easily add stock information to spreadsheets. Sort columns in ascending or descending order. Hide or unhide rows and columns. Turn filters on and off in imported spreadsheets. Insert gorgeous 2D and 3D charts. Animate data with new interactive column, bar, scatter, and bubble charts. Change values in cells using sliders, steppers, checkboxes, pop-ups, and star ratings. Use Undo to go back through your previous changes. iCloud. Turn on iCloud so you can access and edit your spreadsheets from your Mac, iPad, iPhone, iPod touch, and iCloud.com. Access and edit your spreadsheets from a Mac or PC browser at www.icloud.com with Numbers for iCloud. Numbers automatically saves your documents as you make changes. Share a copy of your work. Use AirDrop to send your spreadsheet to anyone nearby. Quickly and easily share a link to your work via Mail, Messages, Twitter, or Facebook. Export your spreadsheet to CSV, PDF, and Microsoft Excel. Use "Open in Another App" to copy spreadsheets to apps such as Dropbox. Print wirelessly with AirPrint, including a single tab, or all tabs. Some features may require Internet access; additional fees and terms may apply. Numbers does not include support for some Chinese, Japanese, or Korean (CJK) text input features such as vertical text.
Unable to handle large spreadsheets. No toolbar across the top of the screen. No letters above the columns or numbers on the rows.
Summary
Should be called Numbers Lite (and Numbers itself is sort of Excel Lite to start with if you're a power user of spreadsheets).. Numbers chokes on larger spreadsheets. I started with a spreadsheet that is relatively small to me (20,000 lines and 30 columns) and when attempting to open it a few minutes would pass and I would receive a message that my sheet had "too many cells". I then started cutting down the size and retrying to open progressively smaller and smaller spreadsheets but even at 10,000 lines and less than 25 columns Numbers chokes and gives the "too many cells" message. I cannot find where Apple provides information on how many cells Numbers can handle.
I was able to open a 2500 line and 20 column xls spreadsheet in Numbers after about a 30 second wait. Scrolling was acceptable though far from smooth. Selecting one cell and then tapping on another to select it would sometimes result in a 3 second wait for the new cell to be highlighted. Resizing columns or rows would result in a lag of a second or two as well. Enough to make you wonder if you'd done it right.
These problems with Numbers occur whether I used xls or Numbers files generated on a macbook pro with both excel and Numbers installed. The fact that my year old Dell Mini 10 can open a huge spreadsheet in a few seconds while other apps are running has me wondering why the iPad struggles, and often fails, to open much smaller spreadsheets. Perhaps Apple has placed constraints on the processor to save power?
I wasn't expecting to be able to create pivot tables from 60,0000 row, 240 column spreadsheets like I can in Excel on a desktop but I did think I could sort and edit large spreadsheets for work and that just isn't a pleasant experience with Numbers.