This article explains how to export, edit, and import CSV files, including field selection, unwind feature, and best practices.
Export
Export process
To export the selected items, select the items, click Actions and then Export.
To export all items click the three dots next to the catalog name and select Export.
A new window opens where entities and fields for export can be defined.
Previewing section
In the Previewing section, select the schema to export and click Show preview.
All schema options are selected by default. To deselect all options, click Clear all. Individual options can be deselected using the checkbox.
The export format can be set to CSV or JSON.
In the Fields selection section, a template can be chosen for the selected field.
| Template | Description |
| Translations | Exports all fields with language tags for translation purposes (names, descriptions, feature and option descriptions, etc.) |
| Classification | Exports item classification information such as baseItemType, characteristics, and fullItemType |
| Options Attributes | Exports selected feature's options with attributes. Recommended for one feature at a time. Works only for Feature options |
| Insertion Offsets | Exports insertion offset data. Available only for Items |
| Attributes | Exports attribute and value data. Available only for Items |
| SubItems | Exports all subitem information except attributes. Available only for Items |
| SubItems Attributes | Exports attributes used on subitems. Available only for Items |
| Custom | Customizable template—fields can be added manually as explained below |
For each selected field in Fields Selection, a list of exported information appears in Selected fields and in Preview. This list depends on the selected schema in Previewing and the selected field.
Additional fields can be added from the list by scrolling down or using the filter by name. All fields can be cleared by clicking the Clear all button.
Select the required fields in the Fields section. The selected fields are displayed in the preview. The export format (CSV or JSON) can also be selected.
After all settings are ready, click Download and the files will be downloaded.
Field Types in CSV
Different field types appear differently in CSV files based on their structure in the schema:
| Field Type | Format | Example |
| Simple string fields | Plain text | B12L |
| Object fields | JSON with curly brackets { } | {"main":"Cabinet Base"} |
| Array of strings | Square brackets [ ] | ["group1","group2"] |
| Array of objects | Brackets and curly brackets | [{"code":"width","value":"600"},{"code":"height","value":"720"}] |
Using unwind for arrays
The Unwind feature splits array fields into separate rows, making them easier to read and edit.
Without Unwind
Without Unwind, all attributes appear in a single cell as JSON, separated by commas.
With Unwind
With Unwind, each attribute becomes a separate row with an index column.
Unwind best practices
Do not mix multiple array fields in unwind. Unwind only one array field per export.
Mixing multiple unwind fields creates a multiplication of rows (e.g., 10 subitems × 77 attributes = 770 rows), resulting in unnecessarily complex files.
CSV delimiters for export
Depending on your regional settings, CSV files may use different separators/delimiters to divide data into columns.
When exporting CSV data in Authoring Hub, you can choose the delimiter used to divide the columns. This allows you to select the appropriate delimiter based on the regional settings used on your computer.
Import
To import data:
- Click the three dots (
) next to the Catalog's name
- Select Import
A new window will appear with two options for adding files.
Import Methods
Drag and Drop
You can drag and drop:
- A single CSV file
- An entire folder (as a .zip file)
Simply drag the file or folder into the import area.
Browse
- Click on the import field
- A file browser will open
- Select the file or folder you want to import
- Click Open
Managing Imported Files
Once files are uploaded, you can:
- Change category: Use the category dropdown bar to reassign files
- Delete files: Click the X icon to remove unwanted files
Completing the Import
When everything is ready click Import.
A success message will appear at the top middle of the screen if the import succeeds
If an incorrect file is uploaded the system will prevent the import and display an error message.
Important: File References in CSV
When the CSV file references images or other files:
- The referenced files must be included in the import
- Files should have the exact same names as referenced in the CSV
- File paths in CSV should use local references (e.g., image.png or folder/image.png)
- Missing or misnamed assets will cause import errors
Ways to include referenced files:
Option 1: ZIP file
- Package the CSV and all referenced files into a single .zip folder
- Import the .zip file
Option 2: Multiple files
- Import the CSV file along with all referenced files at the same time
- Ensure filenames match exactly
Example
Files to import:
- items.csv
- chair_image.png
- desk_texture.jpg
All three files must be imported together (using .zip or drag-and-drop import method).
CSV delimiters for import
When importing a CSV file, Authoring Hub automatically detects the delimiter from the file content. If the detected delimiter is incorrect, you can manually select a different delimiter during the process.
How to edit CSV files
There are two ways to edit CSV files:
Editing simple fields
String or formula fields can be modified directly in the cell. Do not change the format – only update the values within it.
Using headers for nested fields
To edit a nested field:
-
Add a column with the full path as the header (e.g.,
names.main - Enter the value directly
- Import the updated CSV file.
The platform will update the nested field correctly.