Is it possible to export/import field data in a table to/from a CSV file?
You can export fields in a table to a CSV file or Excel file, as well as import data from a CSV file or Excel file to fields in a table.
For the steps to do so, refer to the following pages.
Exporting data to a file
Importing record data from a file into an app
Make sure to keep in mind the following points when you export or import records that include a table.
-
To import data from a file to an app, the "Import from file" permission must be granted in the Permissions for app settings. Similarly, to export data to a file, the "Export to file" permission must be granted.
By default, the "Export to file" and "Import from file" permissions are granted only to app creators.
Reference: Configuring permissions for apps -
If the table has an Attachment field, you cannot perform a bulk update.
If you are adding new records in bulk, you can import data into the fields in the table except for the Attachment field. -
If a table contains a Lookup field, you cannot bulk add/update data in the table in the following situations.
- The user who carries out the Import from file operation has not been granted the "View records" permission in the app that is specified as Datasource app in the settings of the Lookup field.
- The user who carries out the Import from file operation has not been granted the "View" permission for the field that is set as Key Field in the Lookup field settings.