Templates for Excel Web App on iPad

by on December 18, 2012

7 Comments |  
 |   Email |  
 Print |  
 Share |  
Post image for Templates for Excel Web App on iPad

Like so many other people, I’ve been waiting a long time for Microsoft to get an Office app to work on the iPad that will allow me to EDIT spreadsheets. But, did you know that the Excel Web App can already be used via your iPad’s web browser? Microsoft has made the Office Web App with a touch interface in mind and after a few hours of testing I can say that I really like it.

Like Google Docs, the Excel Web App provides a very easy to use Survey feature. In a matter of minutes I was able to create the following survey from scratch using the Excel Web App on iPad:

Take the Survey: Excel vs. Numbers on iOS

Use Excel Templates on iPad

There are still many limitations of the Excel Web App (it being only an online tool for one). I wouldn’t want to create a complex spreadsheet from scratch using the iPad (the same goes for the Numbers app, by the way).

The really good news is that most of the Excel templates on vertex42.com will work well in the Excel Web App. And as you know, the purpose of a template is to make it unnecessary to create a spreadsheet from scratch.

After uploading and testing many of my current Excel Templates, I am very happy to report that there are fewer incompatibility problems than I expected.

The image below shows Vertex42′s .xlsx version of the Family Budget Planner template being edited using the Excel Web App on the iPad in the Safari web browser.

Excel Web App Template on the iPad

Getting Started with the Excel Web App via SkyDrive

It’s easy to get started using the Excel Web App. Just follow these steps:

  1. Get an account on skydrive.live.com – If you have a Windows Live account, that will do.
  2. Log in to SkyDrive
  3. Upload .XLSX files to SkyDrive
  4. Click on one of the files you’ve uploaded

The image below shows some of the Excel templates I’ve uploaded to my SkyDrive account:

SkyDrive Listing of Excel Templates for the Excel Web App

Excel Web App Compatibility Issues

I haven’t tested ALL of my templates yet, but here is a list of the main compatibility problems I’ve come across so far:

  • No support for comments – Comments will be completely removed when editing via the Excel Web App. A large number of my templates use comments to provide help content, so I hope Microsoft adds the commenting feature soon.
  • No data validation – AAARRRGGGHHHH!!! This means no convenient drop-down selection boxes. Google Docs recognized the importance of drop down lists via data validation … hopefully Microsoft will. I use data validation in a lot of my templates.
  • No shapes and other objects – A lot of the instructions in my templates are in text boxes, so those won’t show up when editing in the Excel Web App. Although the Office Web App doesn’t support the text box and shape objects, it DOES display chart objects and images.
  • No workbook or sheet protection – In fact, if you have a workbook or sheet protected, you can’t even open the file via the Excel Web App.
  • No vertical oriented text – You won’t get a compatibility warning, but vertical text will be automatically changed to horizontal.

When you click (or touch) one of the spreadsheet files in SkyDrive, the default is to open and edit the file using the Office Web App. But, if there are any compatibility issues, you’ll see a window pop up like this one:

Excel Web App Compatibility Warning

Excel Web App Compatibility Warning

You can select “Edit a Copy” to create a new copy of the file to edit with the web app. Until I make a few changes to my .XLSX templates on vertex42.com, if you edit any of the templates from vertex42.com using the Excel Web App, you’ll see this window pop up.

Performance – Calculation and Refresh Speed

I expected there to be a serious performance problem with the Office web app, especially when using templates that have a lot of data and formulas, but it looks like Microsoft has really focused on the performance (see this blog post). I haven’t used the web app long enough to know whether the delays will end up being too annoying, but so far the performance seems sufficient.

What about editing an Excel spreadsheet on the iPhone?

SkyDrive on the iPhone

For those that are using an iPhone, there is no great news yet – the SkyDrive app still only allows you to VIEW spreadsheets – not EDIT them. The image to the right shows the family budget planner viewed using the SkyDrive app.

Templates for Excel Web App vs. Numbers

A while ago, I announced the app that we made for providing spreadsheet templates for the Numbers app on the iPad. The problem with Numbers is the HUGE compatibility problem. I pretty much have to recreate my templates from scratch in order to create a version optimized for Numbers. That’s just not fun.

I’m considering putting that project on hold and focusing on optimizing templates for the Excel Web App instead. So, in case you missed the survey link at the start of this article, here it is again:

Take the Survey: Excel vs. Numbers on iOS

I am still trying to figure out how the most convenient way to make my templates available for the Excel Web App. How much work I put into it may depend on how much response I get to this post. So, if you have any particular templates that you would REALLY like to use in the Excel Web App on your iPad, let me know which ones, so I can work on those first.

Related Info

VN:F [1.9.22_1171]
Rating: 0.0/5 (0 votes cast)

{ 7 comments… read them below or add one }

John Brush December 18, 2012 at 11:42 pm

I don’t own an IPad so i have no use for Templates for Excel Web App on iPad but i can say that i discovered your Excel templates for my desktop and find them very very useful and helpful. I very much appreciate your quality work.

John

Reply

RITA January 2, 2013 at 3:11 pm

i have the software number on my mini ipad, own 4s iphone and have a desktop pc. i have excel on my pc and numbers softeware numbers on ipad, but have now used numbers yet. i have only used excel on pc.

Reply

maria March 23, 2013 at 8:10 pm

I have tried many Excel template. yours “personal budget spreadsheet” is the best, very easy to customize, i am trying to have the same template on my phone.

Reply

Nancy March 29, 2013 at 6:43 am

I think your spreadsheets are wonderful for budget managing. I have spreadsheets on my laptop and on my ipad. I know that the ipad will have some limits. I am not able to enter anything on the spreadsheet on my ipad. The ipad keyboard will not appear! Am I doing something wrong? Thank you for all you do.

Reply

Jon Wittwer March 29, 2013 at 7:43 am

@Nancy … If you are using the Excel Web App on the iPad, I’m not sure why you the keyboard does not appear when you edit a cell. There are many apps that allow you to just VIEW a spreadsheet, so perhaps you are using one of those apps.

Reply

Brent Stiles August 17, 2014 at 9:40 am

Looking for template to print excel spread sheets on a 5 x 8 index card front and back. Printer is HP 8100 with duplex printing capability. this requires that the spread sheet be broken into 2 pages for the print to
Recognize page 2.
If not a template what’s the process to accomplish printing a spread sheet on the front and back of the index card?

Reply

Jon Wittwer August 18, 2014 at 10:19 am

@Brent, printing on specific paper is a page layout and printer setting. You can select the range of cells to print and go to Page Layout > Print Area > Set Print Area. Then open the Page Setup dialog box. Under Scaling, choose Fit to 1 page wide by 2 page tall. Choose the appropriate Paper Size from the dropdown box. Excel gets its list of paper sizes from your print driver (Word allows you to specify a custom paper size). Another thing to try would be to pick a paper size larger than 5×8 and then adjust margins to make your content fit (I found that recommendation on excel.tips.net here).

Reply

Leave a Comment

Previous post:

Next post: