Applies ToAccess for Microsoft 365 Access 2021 Access 2019 Access 2016 Access 2013

Important    Access Services 2010 and Access Services 2013 are being removed from the next release of SharePoint. We recommend you do not create new web apps, and migrate your existing apps to an alternative platform, such as Microsoft Power Apps.

You can share Access data with Dataverse, which is a cloud database upon which you can build Power Platform apps, Automate workflows, Virtual Agents, and more for the web, phone, or tablet. For more information, see Get started: Migrate Access data to Dataverse.

The Datasheet view in Access web apps works well when you want to see or work with data in rows and columns, similar to a spreadsheet format.

table data displayed in the datasheet view

Note: This article doesn't apply to Access desktop databases. For information concerning forms and navigation in desktop databases, see create an Access form.

When you create a new table in an Access web app, Access automatically creates a Datasheet view which you can customize. You can also add additional Datasheet views. Here’s how:

  1. Click the Add New View button (the plus sign) on the right side of the View Selector.

  2. In the Add New View box, type a name for the view, and in the View Type list, pick Datasheet.

    adding another datasheet view to a table

If you’d like to rename, copy, change or delete a datasheet view, click the Settings/Actions button to see a list of options available. To modify the datasheet layout, click Edit on this list.

edit datasheet properties for an app

You can customize the view by adding existing fields or even modify existing controls by:

Learn more about customizing a view by creating a user interface macro.

To view or use the datasheet on the web, click Launch App, and open the new Datasheet view in the browser.

Saves your app and launches it in the browser view.

See how you can use other views to filter and find relevant data in an Access web app.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.