1. Log onto Studioware with a user that has administrative security.
2. Click on Students in the main menu
3. Click on "Add Student" and select "Import Students" from the drop down menu
4. The first step of the Student Import Wizard allows you to upload a file that contains your student data.  The file must be a Comma Separate Values file, or CSV.  If you student data is currently in a Microsoft Excel Spreadsheet for example, you can simple save your spreadsheet as a CSV file by clicking "Save As" in Excel and selecting CSV.  
5. If the first row in your spreadsheet already contains headers, click on the check box "The first row of the import file contains headers"
6. After your file has been uploaded, you will be shown a sample of the first 15 records in the file.  You need to map every column in the uploaded spread sheet to a field in Studioware by clicking the drop down list and selecting a Studioware field.  For example, from the sample records that are displayed from you file, search for the "student first name" field.  Indicate to Studioware that the column contains all the student's first names:  

    

   Field Name	Description
   Do Not Import	Studioware will ignore this column from your uploaded spreadsheet and the data will not be imported
   Add as a Student Note	The value will only be added as a Student Note
   Account Balance	Every student
   Title
   First Name
   Last Name
   Family Name	You can group students/siblings together into a family, for example, the "Anderson" family.  Simply enter the family name in the "Family Name" columns.  Studioware will group together students as siblings where the family name matches.
   Suffix
   Status
   Full Name (first, last)
   Full Name (last, first)
   Address 1
   Address 2
   City
   State/Province
   Zip/Postal Code
   Address List
   Phone
   Phone List
   Phone/Home
   Phone/Work
   Phone/Cell/Mobile
   Email
   Email List
   BarCode
   Allergies
   BirthDate	Optionally, you can add a pipe parameter to specify the date format.   If no parameter is provided, the date format is assumed to be mm/dd/yyyy.   For example, enter in "10/31/1997" for October 31st, or "31/10/1997|dd/mm/yyyy"
   Citizen
   Disability
   Drivers License
   Education Level
   Gender
   Health Insurance
   Hospital Preference
   Immunized
   Marital Status
   Medications
   School Name
   Special Needs
   Web Sites
   Tags
   Reference Id
   Contact First Name
   Contact Last Name
   Contact Full Name
   Contact Type
   Contact Address List
   Contact Street Address
   Contact City
   Contact State/Province
   Contact Zip/Postal
   Contact Phone
   Contact Email

    

7. Before saving the imported students, you will have the option to override "Do not add the Registration fee for imported students" and "Add the import record as a Student Note"
8. Click on the Save button after all the fields have been mapped, and the student data will be imported into Studioware. There will be a pop-up message with the count of the number of students that have been successfully imported. 
9. If any students fail to import, you will see the following pop-up:
10. The import result page could potentially display errors and warnings. An error indicates the student record was not imported into Studioware. The error description will indicate which row in your spread sheet contains the bad student data. A warning indicates the student record was imported, however it did contain some bad data. For example, Nate was an error because the last name is required and was missing in the import file

Please Note:

Studioware 2 can automatically import Studioware 1 export data 

You can add up to four contacts information 

Reference Items:

1. Sample Import File: Student Import.csv