You can manage calendar data using CSV files.
The following data can be managed using CSV files:

• Events
• Office Information
• Office Name

You can manage events using CSV files.

You can import events from a CSV file.
Data imported from a CSV file is added as new events. Events that have been added to Garoon are not overwritten by the contents of the file.
If an error occurs while importing a CSV file, the import process will be terminated. The data which has been imported will be eliminated.

1. Create a CSV file to import data.

   For information on items that can be managed using CSV files, refer to the CSV format in Calendars.

2. Click the Administration menu icon (gear icon) in the header.

3. Click "System settings".

4. Select "Basic system administration" tab.

5. Click Calendar.

6. Click Calendar Settings.

7. On the "Calendar settings" screen, select a calendar to import events.

8. Click Import events data.

   

9. On the screen to "import events step 1/2", select the CSV file that you created in step 1.

10. Set the required items for the data to import, and then click Next.

    The setting fields are as follows:

    • Character encoding:
      Encodes data from a CSV file with the selected character code.
      The following character encoding can be selected:
      • Unicode (UTF-8)
      • Japanese (Shift-JIS)
      • ASCII
      • English (Latin1)
      • Simplified Chinese (GBK/GB2312)
      • Thai (TIS-620)
    • Skip the first row:
      If the header row contains information other than data such as an item name and a comment, select "Yes".
    

11. On the screen to "import events step 2/2", check the contents of the CSV file, and click Import.

You can export events to a CSV file.

1. Click the Administration menu icon (gear icon) in the header.

2. Click "System settings".

3. Select "Basic system administration" tab.

4. Click Calendar.

5. Click Calendar Settings.

6. On the "Calendar settings" screen, select a calendar to export events.

7. Click Export events data.

   

8. On the screen to export events, set the required items for the exported data.

   The setting fields are as follows:

   • Period to export:
     Specify all periods or a period to export.
   • Character encoding:
     Encodes data from a CSV file with the selected character code.
     The following character encoding can be selected:
     • Unicode (UTF-8)
       You can select with BOM as required.
     • Japanese (Shift-JIS)
     • ASCII
     • English (Latin1)
     • Simplified Chinese (GBK/GB2312)
     • Thai (TIS-620)
   • Include header row:
     To export an item name to the header row of a CSV file, select "Yes".
   

9. Confirm your settings and click "Export".

10. Save the file with a function provided by your Web browser.

You can manage office information and office names using CSV files.

You can import office information and office names from a CSV file.
If an error occurs while importing a CSV file, the import process will be terminated. The data which has been imported will be eliminated.

1. Create a CSV file to import data.

   For information on items that can be managed using CSV files, refer to the CSV format in Calendars.

2. Click the Administration menu icon (gear icon) in the header.

3. Click "System settings".

4. Select "Basic system administration" tab.

5. Click Calendar.

6. Click Import from CSV file.

7. On the "Import from CSV File" screen, select data to import from a CSV file.

8. Select the CSV file that you created in step 1.

9. Set the required items for the data to import, and then click Next.

   The setting fields are as follows:

   • Character encoding:
     Encodes data from a CSV file with the selected character code.
     The following character encoding can be selected:
     • Unicode (UTF-8)
     • Japanese (Shift-JIS)
     • ASCII
     • English (Latin1)
     • Simplified Chinese (GBK/GB2312)
     • Thai (TIS-620)
   • Skip the first row:
     If the header row contains information other than data such as an item name and a comment, select "Yes".
   

10. Confirm the CSV file contents and click Import.

You can export office information and office names to a CSV file.

1. Click the Administration menu icon (gear icon) in the header.

2. Click "System settings".

3. Select "Basic system administration" tab.

4. Click Calendar.

5. Click Export to CSV file.

6. On the "Export to CSV File" screen, select data to export to a CSV file.

7. Set the required items for the data to export.

   The setting fields are as follows:

   • Character encoding:
     Select the character code that you want to use for encoding.
     The following character encoding can be selected:
     • Unicode (UTF-8)
       You can select with BOM as required.
     • Japanese (Shift-JIS)
     • ASCII
     • English (Latin1)
     • Simplified Chinese (GBK/GB2312)
     • Thai (TIS-620)
   • Include header row:
     To export an item name to the header row of a CSV file, select "Yes".
   • Language in which the data is exported:
     This item is displayed when you export the display name of the office.
     The office name will be exported to a CSV file in the language that you select.
     You can select multiple languages. The following languages can be selected:
     • All
     • 日本語
     • English
     • 中文（简体）
     • 中文（繁體）
       Exported in Traditional Chinese.
   

8. Confirm your settings and click "Export".

9. Save the file with a function provided by your Web browser.