Access Web Datasheet provides an Excel-like environment for viewing and editing data. It displays the contents of a list or a document library in a grid of rows and columns. Items and columns in the list appear as rows and columns in Access Web Datasheet. You can add and edit rows and columns, apply filters and sort orders, display calculated values and totals, and more.
The following illustration shows the Employee list in Access Web Datasheet:
A row corresponds to a list item.
A column corresponds to a list field.
The drop-down arrow in the column header is used to filter and sort data.
The Total row is used to display aggregate values for each column.
Most list types can be viewed in Access Web Datasheet. You can do this in two ways:
Note If a Standard view does not support editing in Datasheet view, the Edit in Datasheet command will not be available. For example, the Explorer view of a document library does not support editing in Datasheet view.
A Datasheet view is independent of all other views of a list. If you add or remove a column from a Standard view, the change does not affect the Datasheet view.
Some list types that do not support Datasheet view are as follows.
Rows An Access Web Datasheet contains one or more rows. Each row stores information about an item in the list. For example, a row in the Employee list stores information about an employee.
You can add a row by scrolling to the bottom of the list, and entering data in the star (*) row. You can also edit or delete a row. Your changes are sent to the server after you leave the row and are committed asynchronously. You can continue making changes to different rows, and the view commits your changes in the background. If your changes result in a conflict or error, the view will be updated with information necessary to resolve the conflict or error.
You can change the row height, sort rows based on one or more columns, and hide rows by applying filters.
Columns A view contains one or more columns. Each column stores a particular type of information for all items in the view. For example, the Name column in the Employee list stores the names of the employees.
You can add a column to a list in Datasheet view or Standard view. A column must have a name and must be of a specific data type. You can mark a column as required if you do not want the user to skip the column when entering data. You can also specify additional column settings, such as default value and maximum length. For more information on how to add a column to a list, see Microsoft SharePoint Foundation 2010 Help. To display Microsoft SharePoint Foundation 2010 Help, click Help ().
You can modify an existing column or delete a column. You can customize the appearance of a column by showing or hiding columns, rearranging them, adjusting the width, and filtering and sorting rows based on column values. You can also add calculated columns to a list.
Datasheet group The Datasheet group in the ribbon, under the List tab displays commands for performing common tasks in Datasheet view, such as displaying the task pane or adding a new row.
Status bar The status bar at the bottom of the view displays useful information, such as:
Task pane The task pane allows easy, context-sensitive access to certain actions, without requiring you to move away from the Datasheet view.
The following illustration shows the task pane for a sample list:
At the top of the pane is the toolbar. It displays buttons for common commands, such as Cut, Copy, Paste, Sort, and Help.
Clicking the Net Shade bar hides or displays the task pane. You can drag the bar to resize the pane.
Hover over the scroll bar to scroll the pane vertically.
The interior of the pane displays various commands.
Your computer must meet a set of software requirements before you can view a list in Access Web Datasheet.