> ## Documentation Index
> Fetch the complete documentation index at: https://hc.saas-manager.biz.nuro.jp/llms.txt
> Use this file to discover all available pages before exploring further.

# 3. [Directory] How to Create a Directory CSV for Import

> Steps to import your directory HR ledger as a CSV file.

#### Recommended Environment and Prerequisites

The following environment and format are recommended for CSV imports.

| Item               | Details                                                                                                  |
| ------------------ | -------------------------------------------------------------------------------------------------------- |
| Character encoding | UTF-8 (UTF-8 BOM + CRLF)                                                                                 |
| File format        | CSV (comma-separated values) (.csv)                                                                      |
| File name          | Avoid environment-dependent characters (old kanji forms, special symbols, etc.) and half-width katakana. |

#### Import the Directory Ledger via CSV

1. Go to Directory > **Import** and download the template. You can also export existing data from **Export** as a CSV and then import it.

   <img src="https://mintcdn.com/admina-sbn/EytLyhMZXkzPYa2d/images/it-management/1xtq0cxipa/2026-06-07-16-06-10.png?fit=max&auto=format&n=EytLyhMZXkzPYa2d&q=85&s=0f41510c426dc9b4eda08ec31e3d26a5" alt="Downloading the template on the Directory import screen" width="2080" height="880" data-path="images/it-management/1xtq0cxipa/2026-06-07-16-06-10.png" />
2. Organize the items you want to manage according to the template.
3. Import the template to finish.

#### Notes on CSV Import

Existing data is overwritten when you import a CSV. Review the following notes carefully before proceeding.

| Item                             | Details                                                                                                                                                                                                                                                                                                                                                       |
| -------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Backup                           | Always export a backup before overwriting data with a CSV. Data cannot be restored.                                                                                                                                                                                                                                                                           |
| Overwriting existing data        | The CSV data overwrites existing data. If a CSV cell is blank, the corresponding field is overwritten with a blank value.                                                                                                                                                                                                                                     |
| Partial updates                  | When updating only part of the data, edit only the fields you want to change. Do not delete columns for unchanged fields — import with data present in all columns. (Deleting a column causes that field to be overwritten with a blank value.)                                                                                                               |
| Data you do not want to change   | If there is account information you do not want to change, we recommend deleting the corresponding row from the CSV.                                                                                                                                                                                                                                          |
| Environment-dependent characters | Not supported.                                                                                                                                                                                                                                                                                                                                                |
| Maximum records                  | You can register up to 1,000 records in a single import.                                                                                                                                                                                                                                                                                                      |
| Daily sync                       | Directory information updated via CSV import may be updated by daily synchronization with SaaS. For fields that should not be updated by daily sync, set the data source in Directory Settings to this service. For details, see [Directory Settings](/en/it-management/directory/gqqdb2621q-edit-uid#data-source-settings) to set or change the data source. |

#### Bulk Edit to "ID Type: Unmanaged ID and Status: Untracked" via CSV Import

<Info>
  Even if you change the ID type to Unmanaged ID, the ID type and type will be updated to match the employee master the next time employee master sync runs, as long as the status remains Draft.
  To prevent this, set the status to Untracked by updating employeeStatus.
</Info>

1. Go to Directory > **Export** to export the CSV data.
2. Keep only the employee rows you want to change and delete all other rows.
3. Update the relevant data as follows:
   * **employeeType**: `unregistered`
   * **managementType**: `unregistered`
   * **employeeStatus**: `untracked`
4. Go to Directory > **Import** to import the CSV data.

#### Registration Template

The following fields and specifications are available when registering information using the template.

<table>
  <colgroup>
    <col style={{ width: "20%" }} />

    <col style={{ width: "8%" }} />

    <col style={{ width: "14%" }} />

    <col style={{ width: "58%" }} />
  </colgroup>

  <thead>
    <tr>
      <th>Field name</th>
      <th>Required/Optional</th>
      <th>Input example</th>
      <th>Input specification</th>
    </tr>
  </thead>

  <tbody>
    <tr>
      <td><strong>ID</strong></td>
      <td>Optional/Required</td>
      <td>Blank or 10-digit alphanumeric</td>
      <td>New registration: leave blank (generated automatically)<br />When editing: the exported value contains a 10-digit string</td>
    </tr>

    <tr>
      <td><strong>employeeID</strong></td>
      <td>Optional</td>
      <td>CODE111</td>
      <td>Employee ID</td>
    </tr>

    <tr>
      <td><strong>employeeType</strong></td>
      <td><strong>Required</strong></td>
      <td>full\_time\_employee</td>
      <td>Type (specify the <code>English parameter</code>)<br />・Executive→<code>board\_member</code><br />・Full-time employee→<code>full\_time\_employee</code><br />・Contract employee→<code>fixed\_time\_employee</code><br />・Temporary employee→<code>temporary\_employee</code><br />・Part-time employee→<code>part\_time\_employee</code><br />・Seconded employee→<code>secondment\_employee</code><br />・Contract worker→<code>contract\_employee</code><br />・Collaborator→<code>collaborator</code><br />・Group address→<code>group\_address</code><br />・Shared address→<code>shared\_address</code><br />・Test address→<code>test\_address</code><br />・Other→<code>other</code><br />・Unknown→<code>unknown</code><br />・Unmanaged (only when ID type is Unmanaged ID)→<code>unregistered</code></td>
    </tr>

    <tr>
      <td><strong>managementType</strong></td>
      <td>Optional</td>
      <td>managed</td>
      <td>ID type (export data only); specify the <code>English parameter</code><br />・Internal ID→<code>managed</code><br />・External ID→<code>external</code><br />・System ID→<code>system</code><br />・Unknown ID→<code>unknown</code><br />・Unmanaged ID→<code>unregistered</code></td>
    </tr>

    <tr>
      <td><strong>employeeStatus</strong></td>
      <td><strong>Required</strong></td>
      <td>active</td>
      <td>Status (specify the <code>English parameter</code>)<br />・Active→<code>active</code><br />・On leave→<code>on\_leave</code><br />・Draft→<code>draft</code><br />・Pre-hire→<code>preactive</code><br />・Retired→<code>retired</code><br />・Untracked (only when ID type is Unmanaged)→<code>untracked</code><br />・Archived (only when SaaS and devices are 0)→<code>archived</code></td>
    </tr>

    <tr>
      <td><strong>firstName</strong></td>
      <td>Optional</td>
      <td>Taro</td>
      <td>First name</td>
    </tr>

    <tr>
      <td><strong>lastName</strong></td>
      <td>Optional</td>
      <td>Kimura</td>
      <td>Last name</td>
    </tr>

    <tr>
      <td><strong>displayName</strong></td>
      <td><strong>Required</strong></td>
      <td>Taro Kimura</td>
      <td>Display name</td>
    </tr>

    <tr>
      <td><strong>primaryEmail</strong></td>
      <td>Optional</td>
      <td>[user@example.com](mailto:user@example.com)</td>
      <td>Primary email address</td>
    </tr>

    <tr>
      <td><strong>secondaryEmails</strong></td>
      <td>Optional</td>
      <td>[user+1@example.com](mailto:user+1@example.com); [user+2@example.com](mailto:user+2@example.com)</td>
      <td>Secondary email addresses. Separate multiple entries with ";".</td>
    </tr>

    <tr>
      <td><strong>avatar</strong></td>
      <td>Optional</td>
      <td>[http://example.com/image.png](http://example.com/image.png)</td>
      <td>Avatar URL</td>
    </tr>

    <tr>
      <td><strong>jobTitle</strong></td>
      <td>Optional</td>
      <td>Manager</td>
      <td>Job title</td>
    </tr>

    <tr>
      <td><strong>companyName</strong></td>
      <td>Optional</td>
      <td>Example, Inc.</td>
      <td>Company name</td>
    </tr>

    <tr>
      <td><strong>workLocation</strong></td>
      <td>Optional</td>
      <td>Tokyo</td>
      <td>Location</td>
    </tr>

    <tr>
      <td><strong>lifecycleContractStartAt</strong></td>
      <td>Optional</td>
      <td>2022-08-09</td>
      <td>Employment start date (yyyy-mm-dd)</td>
    </tr>

    <tr>
      <td><strong>lifecycleContractEndAt</strong></td>
      <td>Optional</td>
      <td>2025-08-09</td>
      <td>Employment end date (yyyy-mm-dd)</td>
    </tr>

    <tr>
      <td><strong>lifecycleSuspensionStartAt</strong></td>
      <td>Optional</td>
      <td>2023-08-09</td>
      <td>Leave start date (yyyy-mm-dd)</td>
    </tr>

    <tr>
      <td><strong>lifecycleSuspensionEndAt</strong></td>
      <td>Optional</td>
      <td>2023-11-15</td>
      <td>Leave end date (yyyy-mm-dd)</td>
    </tr>

    <tr>
      <td><strong>departmentName</strong></td>
      <td>Optional</td>
      <td>Customer Success Department</td>
      <td>Department name</td>
    </tr>

    <tr>
      <td><strong>managerName</strong></td>
      <td>Optional</td>
      <td>Jiro Yamamoto</td>
      <td>Manager name</td>
    </tr>

    <tr>
      <td><strong>Note</strong></td>
      <td>Optional</td>
      <td>Converted from intern to full-time</td>
      <td>Notes</td>
    </tr>
  </tbody>
</table>
