Import data into your app
Updated Jun 25, 2026
Use Import to load records into your App.
How to import data into your app?
- Open the app and click Import.
- Upload an Excel or Google Sheets file whose columns match the form's fields.
- For forms / transactions containing header and line items, data is imported from multiple sheets
Keys and updates
- If your app defines a key field, importing a row whose key already exists updates that record instead of adding a duplicate (an upsert).
- With a sub-key, the update is scoped within the key — handy for line items.
Tip
- App Owners/ Editors should use the Export file layout as a template for Import file. This will ensure data is imported without any data layout inconsistencies.
Good to Know
- App users with roles Owner or Editor can export App data.
- SheetApps supports MS Excel (.xlsx), Google Sheets, JSON and CSV (only for forms without header/ line items). Recommendation is to use Excel or Google Sheets.