Export/Import

The CMS lets you export a collection to an Excel (.xlsx) file and import data back from Excel. Exchange happens per collection and uses a field mapping that you control.

In the top‑right corner of a collection there is an Export/Import button. Clicking it opens a menu with three actions — Export, Import and Settings.

Export/Import menu

• Export — exports the current collection to an .xlsx file using the saved field settings. The file downloads automatically when it is ready.
• Import — opens a file picker so you can upload an Excel file and update the collection from it.
• Settings — opens the Excel Settings panel where you configure how CMS fields map to columns in the Excel file.

Excel Settings

1. Sheet configuration List Name — the name of the sheet (list) inside the Excel file. Title Row — the row number that holds the column titles. Content Start Row — the first row that contains data.
2. Key field The field used to match records during import and export. On the left you pick the Flexim Field (its type icon is shown next to the name); on the right you type its column title in Excel (Excel Field (title)). Records are compared by this field, so it should be unique.
3. Field list The other fields included in export/import. Drag a row by the grip handle to reorder it, or remove it with the ✕ button. Each row maps one Flexim field to one Excel column title.
4. Add Field Adds a new mapping row.
5. Reset / Apply Reset clears the field list. Apply saves the configuration. Save the settings before running an export or import so they take effect.

Fields that can be exported/imported

1. Text
2. Rich text
3. Numbers
4. Date
5. Boolean
6. Array
7. E-mail
8. Select

Import

1. Choose Import from the Export/Import menu and select an Excel file from your device. Excel files (.xlsx, .xlsb) and .csv are supported.

   The maximum import file size is 50 MB.

   The sheet name inside the imported file must match the List Name value in Excel Settings. Otherwise the data will not be updated.

2. Progress is shown as notifications in the top‑right corner: first the file upload (Uploading file …%), then Updating data… Please wait with a reminder not to close or reload the page.

3. After the records are written, related collections are updated (Updating related collections… Please wait).

4. When everything is finished you see Import completed successfully. Refresh the page to see the updated records.

Export

1. Choose Export from the Export/Import menu. Progress is shown as notifications in the top‑right corner: Sending data…, then Processing documents… N processed, and finally Preparing file… while the document is assembled.
2. When the file is ready it downloads automatically and Export completed successfully appears. Open the downloaded .xlsx to see all the mapped fields as columns.