Overview
Most collections start life as a spreadsheet. Import brings those rows in as entries, and export gives you a CSV copy whenever you need one.
Who can do this
- Required access: an access level that includes Collections - Standard Access or Collections - Full Access.
- Default access levels that include it: Team Member, Accountant, and System Administrator.
- Owners and admins: always allowed. Workspace owners and admins are not limited by access levels.
- Personal accounts: The Family Admin, Family Member, and Limited Member presets include this access. The space owner and admins can always do it.
Owners and admins review and change access levels in Settings → Administration → Members → Access levels.
Step 1: Get the template
- Open the collection from Collections and select its Settings tab.
- Choose Data in the left menu.
- Under Import Template, click Download template. It has one column per field.
- Paste your data into the template, keeping the column headers.
Step 2: Import
- Under Import Entries, click Import.
- Choose your CSV file and follow the import steps to finish.
Step 3: Check the result
Under Import history, click View history to see each import and any rows that failed. Fix those rows in your file and import them again.
Export
Under Export Entries, click Export to download all entries as a CSV.
Troubleshooting
| Issue | What to check |
|---|---|
| Rows failed to import. | Check the history for the reason. Common causes are dates in an unexpected format or select values that don't match the field's options. |
| Calculated fields are empty in the template. | Formula, Lookup, and Rollup fields are computed by Scrambl and can't be imported. |