Add a Datasheet view in an Access app

Important    Microsoft no longer recommends creating and using Access web apps in SharePoint. As an alternative, consider using Microsoft PowerApps to build no-code business solutions for the web and mobile devices.

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.

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×