---
title: Preparing Data for Import (Default)
description: "These rules apply to importing records into any module. Some modules have extra rules: see [Preparing Data for Import (Risks)](https://support.symbiant.co.uk/kb/preparing-data-for-import-risks/) and [Preparing Data for Import (Users)](https://support.symbiant.co.uk/kb/preparing-data-for-import-users/). **Warning:** Follow these rules carefully. Symbiant has safeguards against bad imports, but a file…"
url: "https://support.symbiant.co.uk/kb/preparing-data-for-import/"
updated: "2026-10-30"
category: Importing Data
tags:
  - Add
  - Import
---

# Preparing Data for Import (Default)

These rules apply to importing records into any module. Some modules have extra rules: see [Preparing Data for Import (Risks)](https://support.symbiant.co.uk/kb/preparing-data-for-import-risks/) and [Preparing Data for Import (Users)](https://support.symbiant.co.uk/kb/preparing-data-for-import-users/).

**Warning:** Follow these rules carefully. Symbiant has safeguards against bad imports, but a file that gets past them can overwrite or lose data. If you're unsure, raise a support ticket and we'll help you through it.

## An Example File

Each row is one record and each column is one field. Here is a small file ready to import into Incidents:

![An example incidents import file](https://support.symbiant.co.uk/wp-content/uploads/2026/10/preparing-data-for-import-01-prep-incidents-csv.png)

## The Rules

1. **Save the file as CSV (UTF-8).** In Excel, choose **File > Save As** and pick **CSV UTF-8 (Comma delimited) (*.csv)**.
2. **One column per field.** Multi-level data, such as reviews and actions, can't be imported in a CSV file.
3. **Fill in every required field.** Reference and Summary are always required. To find a module's other required fields, open a new record and look for the red asterisks (*). If you try to save an empty record, the required fields show a warning.

![Required fields are marked with a red asterisk](https://support.symbiant.co.uk/wp-content/uploads/2026/10/preparing-data-for-import-02-prep-required-asterisk.png)

1. **Make references unique.** Use only letters, numbers, underscores (_), dashes (-) and dots (.), up to 15 characters, with no spaces.
2. **Match the case exactly.** Values are case sensitive, so `Company/UK` is not the same as `company/uk`.
3. **Avoid commas and special characters** in column headings and drop-down values. Free-text fields can contain them, as long as the file is saved as UTF-8. Copying and pasting between Office programs can change special characters (such as curly quotes), so check them.
4. **Write divisions as full paths** with a forward slash (/) between levels, for example `Company/UK/Sales`. - Include the top (root) division, for example `Company`. - Don't include the permission group name, for example not `Divisions/Company/UK`.
5. **Write dates in UK format**, DD/MM/YYYY.
6. **You can only import into divisions you have access to.** To import a record into `Company/UK`, your own account must be assigned to `Company` or `Company/UK`.
7. **Keep free text under 4,096 characters** per field.
8. **Give checkbox fields a value on every row**, for example `true` or `false`.
9. **Owners are optional**, but they must already exist as users. Use their full name or email address. Some features, such as reminders, only work once a record has an owner.

**Critical:** Importing a reference that already exists **overwrites** that record with the imported version.

## Related Articles

- [Importing Data (Generic)](https://support.symbiant.co.uk/kb/importing-data-generic/)
- [Imports with Hierarchical Data](https://support.symbiant.co.uk/kb/imports-with-hierarchical-data/)
- [Importing Errors & Issues](https://support.symbiant.co.uk/kb/importing-errors-issues/)
