Managing Events in CSV Files

Manage event data for My Calendar in CSV files.

Importing Data from a CSV File

Import the event data from CSV files.

Steps:

  1. Create a CSV file to import data.

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

  2. Click the user name in the header.

  3. Click "Personal settings".

  4. Select "Common settings" tab.

  5. Click "Calendar".

  6. Click "My Calendar Settings".

  7. On the "My Calendar Settings" screen, click the item to import events.

    Image of the action link for importing events

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

  9. Set the data to import, and 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
      • Latin1 (ISO-8859-1)
      • Simplified Chinese (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".
    Screen to import events

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

Exporting Data to a CSV File

Export the e-mail data to a CSV file.

Steps:

  1. Click the "User name" in the header.

  2. Click "Personal settings".

  3. Select "Common settings" tab.

  4. Click "Calendar".

  5. Click "My Calendar Settings".

  6. On the "My Calendar Settings" screen, click the item to export events.

    Image of the action link for exporting events

  7. 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.
      Following character codes can be selected.
      • Unicode (UTF-8)
      • Japanese (Shift-JIS)
      • ASCII
      • Latin1 (ISO-8859-1)
      • Simplified Chinese (GB2312)
      • Thai (TIS-620) 　
    • Include header row:
      To export an item name to the header row of a CSV file, select "Yes".
    Screen to export events

  8. Confirm your settings and click "Export".

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