Overview

StudioCloud allows for several methods of importing calendar information, including through a CSV file. The instructions below will explain how to import calendar information from a CSV file. Please note that importing calendar information from CSV is limited to the name, number, and notes for the event, along with the start and end time.  Information like clients or calendar types cannot be imported via this method.

How to Import Your Calendar from a CSV File

1. Go to the Calendar component
2. Select the Settings tab
3. Click the Import Calendar button
4. Click the Import Options menu button
5. Click the Import from CSV (Comma Separated) option
6. Find and select the file you want to import
7. Click the Open button
   • This will populate the table with the information available
8. To match existing clients refer to the "Matching Clients With Sessions/Events" header below
9. Once you have verified the information click the Save button

CSV File Column Headers Format

If you are importing a generic CSV file with event data then your CSV should have the following format to import correctly

• Column 1: Session/Event Name
• Column 2: Session/Event Number
• Column 3: Client First Name
• Column 4: Client Last Name
• Column 5: Start Date(MM/DD/YYYY)
• Column 6: Start Time (H:M AM/PM)
• Column 7: End Date (MM/DD/YYYY)
• Column 8: End Time (H:M AM/PM)
• Column 9: Notes