<

Run Excel on your iPad - no downloads, no apps, no fees.

Published on
23,713 Points
9,913 Views
38 Endorsements
Last Modified:
Awarded
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Love data viz with Excel and Power BI. Power Query rocks. Have you tried it?
Did you know that you can use your iPad to view and edit Excel files? It’s really easy to do and the best thing is that it’s free. You don’t need any apps, you don’t need to install anything. All you need is your iPad, an internet connection and a free Windows Live ID and SkyDrive folder.

You need:

an iPad
a Windows LiveID account
a Microsoft SkyDrive folder
(Note: the following has been tested on an iPad2 running iOS 5.0.1. Earlier versions of iOS may not produce the results described below.)

On your PC or Mac, point your browser to www.skydrive.com. Sign in with your Windows LiveID in the dialog that appears on the right hand side of the screen, or, if you do not yet have a LiveID, sign up for one with the button in the left hand panel and follow the instructions.

Microsoft gives you 7GB of SkyDrive storage space for free. In your SkyDrive space you can store all kinds of documents. You can create folders, you can share folders with everyone, or just selected people that you invite, or keep folders private. Learn more about SkyDrive in the SkyDrive Help Center.

Now, for the purpose of this exercise, copy or move some of your Excel files to a SkyDrive folder. There are many ways to do this, for example via the “Add files” command in your SkyDrive home page.

Once you have uploaded a file, you can click it and it will open for viewing in the browser with the Excel web app. There is also a command to “Edit in Browser”. This makes the spreadsheet editable. The browser based editing is called “light editing”, and it includes many more features than most Excel users will ever need. You can edit data, use formulas, insert charts, format cells, etc.

All this works in your desktop browser, so of course, all this will also work in the iPad Safari browser, right?

Yes, it will, but you may be a bit disappointed at first.

Fire up your iPad and point Safari to your SkyDrive folder. (Note: You can ignore any prompts to download the Skydrive App, since it does not affect the functionality described below.)

You will see something like this:iPad Skydrive screenTap the Excel file and you’ll find yourself looking at something like this:
iPad standard Skydrive with ExcelYou can’t manipulate the data, you can’t manipulate the pivot table. Scroll down and below row 50 you’ll find a panel with some commands:
iPad Skydrive Excel commandsTap the command to switch to a different sheet and you can see a list of sheets in the workbook:
iPad Skydrive Excel sheetsThe Dashboard sheet has a chart, and when it is active it displays this:
Chart in iPad Excel viewerIn order to see the chart, you need to scroll down and tap the command “View charts in current sheet”, then you can see something like this:
Display chart in iPad Excel viewer
Anyone impressed so far? Well, I wasn’t. Why can’t I see on the iPad what I can see on my desktop computer, i.e. an interface where I can see the sheet tabs, edit the file in the browser and all?

Now comes the good part.

Navigate back to your SkyDrive home folder and tap on the link “PC site” at the bottom of the page:
Skydrive start screenIf nothing seems to happen, tap again, and then refresh the page in Safari. You should now see something like this:
Skydrive PC siteNow we’re cooking!

To the right of the Bing search box, you can tap the icons for list view or icon view.
Skydrive viewsTap on the Excel file name to view the workbook in the Excel web app:
Excel web app on iPad - view sheetsYou can click on the + icons to expand the pivot table groups, you can use the pivot table filters, you can tap on the sheet tabs to change to the other sheets and view the data and the chart.

If you tap the “Edit in browser” link, you will get the same interface as on your desktop machine: you can edit cells, use formulas, and even do things like adding a chart title to the chart.
Pivot tableManipulate chart elementsFile menuSo, there you have it: create and edit Excel files with Excel web apps on your iPad — for free. No apps required, no downloads required.

That sure impressed me!

cheers, teylyn

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If you liked this article and want to see more from this author,  please click here.

If you found this article helpful, please click the Yes button below.

Thanks!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
38
Comment
  • 3
  • 2
  • 2
  • +3
10 Comments
 
LVL 38

Expert Comment

by:lherrou
Nice tip! This'll come in handy.

I voted "Yes" above.
0
 
LVL 70

Expert Comment

by:Jason C. Levine
Interesting.

Do you think the behavior displayed by switching to the "PC Site" is actually a bug or a feature that Apple or MS will work to remove?
0
 
LVL 50

Author Comment

by:Ingeborg Hawighorst (Microsoft MVP / EE MVE)
I guess it's due to the fact that the mobile version of Skydrive cannot show Office Web Apps and uses just a viewer app instead.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 50

Author Comment

by:Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Just put my dibs on a 1st gen iPad with iOs 4.1 .x  or 4.2.x, can't remember. First thing I did was fire up Safari and log into my SkyDrive. Guess what? It worked, even on that older version. And it continues to work after upgrading to iOS 5.1.1.
0
 
LVL 38

Expert Comment

by:lherrou
I've gotten it to work on my iPad 1stGen, too, but it usually takes 2-3 tries, flips to home screen, relaunch Safari, etc.
0
 
LVL 50

Author Comment

by:Ingeborg Hawighorst (Microsoft MVP / EE MVE)
I think that the crucial part is after tapping "PC site" once or twice, you need to refresh the page. From my experience with different iOS versions it then shows the desired Skydrive interface.
0
 
LVL 5

Expert Comment

by:dani gammon
I need to try this! I wonder if it would work on an iPhone.... Thanks for the tip!  I up voted as well.
0
 

Expert Comment

by:kojaqs
Has anyone tried to do the same with Google Drive and Google Apps? Just curious...
As for the article, that's an absolute yes. Great tip!
0
 

Expert Comment

by:Bright01
Teylyn,

Great article!   I will definitely try it on my iPad.

I have posted a question about hosting an Excel Workbook.  The reason is due to constant compatibility issues; 32 bit vs. 64 bit; Excel 2007 vs. 2010, and now I have users who cannot use it due to macro conflicts with Win 8.  I'm looking at hosting the Excel App. (.exe via LockXLS) and potentially eliminating the compatibility issues.  If you get a chance, take a look at the question.... would love your input.

Hope all is well..... cheers,

B01
0
 

Expert Comment

by:Bright01
Teylyn,

Will it work with XLSM files?  Will it allow macros to run (since it may be actually running on MS Skydrive?

B.
0

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

Join & Write a Comment

This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month