Bulk Import Records

Using the data import tool, a site administrators are able to import multiple records from an excel spreadsheet into your ShareVision site.

Data must be arranged within the Excel sheet with column header titles that match the receiving list column titles.

Instructions

Navigate to the site administrator section of the site and select 'Data Import' in the Utilities section
Select the list you wish to import records into.
Select the date format which march the dates specified in your spreadsheet.
Select the Choose File button or Drop the Excel spreadsheet into the box that appears

Your spreadsheet must contain all columns that are required by the list, regardless of the Content Type settings.
Your spreadsheet row 1 must be the Exact Name of the column from the list your are importing into.
The importer uses the First Sheet in your spreadsheet.
For multi-pick Fields: The delimiter must be a simicolon ; or SharePoint's standard delimiter ;#
Import Limit: Start at 1000 Items. This limit is solely based on the number of columns requiring validation, such as User Fields, Lookups, and Date Time fields. Start at 1000 and if it takes under 1 minute, bump up your next import to 2000.