How to Microsoft News

You can now download your data from Microsoft Access web app to excel

Share on Facebook
Tweet about this on TwitterShare on Google+Share on StumbleUponShare on LinkedInPin on PinterestShare on Reddit


Almost every Access web app user has this particular complaint. It is was extremely tedious and difficult to import or download their access data onto an excel sheet on their computer. Well, Microsoft listens to you, and has hence announced a new feature, Download to Excel.

This new feature allows all of Access 2013 Office 365 customers to download or open their Access data in the form of a spreadsheet. Announcing the same, Microsoft said,

Currently, the process for viewing your Access web app data within Excel involves many steps. We’re proud to announce that a new feature called, “Download in Excel” is available to all of our Access 2013 Office 365 customers, which makes this process much simpler.

The changes are on the server side which means you do not need to update your Access client program at all. This update is available for customers using Office 365 with Access Services. Keep looking out for that option, as it may appear soon.

So How does this new feature work ? When viewing any datasheet views in your browser for your Access web app on Office 365, you’ll see the new Download in Excel button on the right side of the Action Bar, as shown in the following screenshot:


When you click the Download in Excel button, you are prompted to either open or save the spreadsheet. If you choose to open the spreadsheet, Excel downloads a copy of the data from the datasheet view and then immediately displays it within the familiar Excel interface. You can the use all of Excel’s rich text-editing features, to edit your content.

Currently, you can download up to 10,000 records from a datasheet into Excel. If you do not want to show this option for specific datasheet views, you can hide the Action Bar for that view, which will hide the Download in Excel button.

Editor-at-large and co-founder at The Tech Portal. He is a tech enthusiast with interests in new-age technology fields like Ai, Machine Learning, AR/VR, Outer Space and related stuff. Drop him a mail anytime, very reachable.

Add Comment

Click here to post a comment

Your email address will not be published. Required fields are marked *