Export this view to a CSV file

This action downloads the rows of a view to a CSV file. Export only works for applications that require sign-in. It is not supported for public applications.

Invoke an "export this view to a CSV file" action

Once you have created the Export action as described in the sections below, you can invoke it as follows:

  1. Open the application in a desktop browser. Export only works when the app is running on a desktop browser, not when it is running on a iOS or Android device.
  2. Navigate to the table view having the Export action.
  3. Click the Export button. (If you do not see the Export button, you may need to edit the Export action and choose a different Prominence on the Appearance tab.)
  4. The Exported CSV file should appear at the bottom of the browser screen.

Create an "export this view to a CSV file" action

To create an Export This View to a CSV File action:

  1. In the Editor, go to the Behavior > Actions tab.
  2. Click New Action.
  3. Give the action a meaningful name by setting the Action name property.
  4. Use the For a record of this table dropdown to select the table from which the records should be downloaded. Views based on the table you select are eligible for export.
  5. In the Do this dropdown, select App: export this view to a a CSV file (not a row-level action)
  6. Set the CSV file locale property as described in configure the CSV locale.
  7. Expand the Appearance tab.
  8. Give the Export button a meaningful name by setting the Display name property.
  9. Select an Action icon for the Import button.
    You can enter export in the search window and hit Enter to narrow down the list of icons. One of the icons showing an arrow leaving a document is often a good choice.
  10. Select a Prominence to control how prominently the Export button is displayed.
  11. Click Save.

Row filtering

The app creator and app user can control which rows are exported by:

  • The app creator can base the View on a Slice having a Row filter condition. Only rows that match the Row Filter Condition are exported.
  • The app creator can specify a LINKTOFILTEREDVIEW() with a filter expression. Only rows that match the filter expression are exported.
  • The app user can specify a Search Term in the Search box for the view while running the app. The app user can search any field for which Search? is true. Only rows that contain the Search Term are exported.
  • The app user can specify one or more Search Filter conditions using the Filter drop-down in the Search box while running the app. The app user can search any field for which Search? is true. The app user can apply Search Filter conditions for any combination of searchable fields. Only rows that match all of the Search Filter conditions are exported.

These row filtering techniques can be combined. For example, the app creator could define a View on a Slice having a Row Filter Condition. The app creator could then define a LINKTOFILTEREDVIEW() using that slice which has its own filter expression. Finally, the app user could use the Search box to specify a Search Term or one or more Search Filter conditions while running the app. Only rows that match all of these filtering conditions are exported.

Exported row sort ordering

You can control the exported row sort ordering by specifying Sort by for the View.

Column filtering and column ordering

You can control which columns are exported and the order of those columns by basing the View on a Slice and specifying Slice Columns for the Slice.

Specifying Column Order for a Table View currently has no effect on which columns are exported or the order of those columns.

Private tables

CSV Export can be used to export data from private tables.

The app creator must first create an App: export this view to a a CSV file action for the Private table, as described above.

The app user can then sign-in to AppSheet using their account, invoke the application, and invoke the App: export this view to a a CSV file action, as described above. AppSheet will locate the Private table belonging to the signed-in user and export the contents of the Private table to the CSV file.

Sample applications with an export action

Troubleshoot

If CSV export fails see Troubleshoot CSV export.

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false