Menu
SharePoint Workflow Extensions Kit

Import CSV file into SharePoint list

This activity allows importing records from CSV file into SharePoint list.

SharePoint Workflow Designer Phrase

Import CSV file this file url into SharePoint list this list url using default mapping . Delimiter: , Text Qualified: “. Trigger create event: No.

Parameters

Parameter Description
this file url URL for the file containing the document to load. The URL can be either a local file or an HTTP URL (a Web address). Ex: c:\Task.csv Ex: http://externalsite.com/Task.csv Ex: http://sharepoinportal/ Shared%20Documents/CSVTest.csv
this list url Full list url or folder url in the list Ex: http://mysharepoint/Lists/Tasks Ex: http://mysharepoint/Lists/Tasks/Folder
default mapping Optional. Defines SharePoint field and CSV column pair. [SharePointFieldName1]=[CsvColumnName1] … [SharePointFieldNameN]=[CsvColumnNameN] If mapping is empty, the activity will try to copy each CSV column into SharePoint fields. If SharePoint field doesn’t exist in the list, the activity will skip the column. Note: Use vti_titlte field to update title Use ModerationInformation.Status field to update content approval status for an item. Use ModerationInformation.Comment field to update comment that addresses why the item was approved or rejected. **Note: ** Use [SharePointFieldName1]=DefaultValue:[DefaultValue] to set default value into SharePoint field. **Example: ** Ex: copy Title CSV column to Title SharePoint field Title=Title Ex: copy Begin Date CSV column to Start Date SharePoint field Start Date=Begin Date Ex: set Status SharePoint field to In Progress Status=DefaultValue:In Progress Ex: set Start Date SharePoint field to 2010-12-10 12:30:00 Start Date=DefaultValue:2010-12-10T12:30:00 Ex: set Publushed SharePoint field to true Published=DefaultValue:1
Delimiter The delimiter character separating each field: - ; - , - Tab - [Space]
Text Qualifier The quotation character wrapping every field: - “ - ‘