Write Data to SharePoint
Microsoft SharePoint Connectors in Designer
This page covers the capabilities of the new version of SharePoint connectors. For the older version, visit Microsoft SharePoint, 
SharePoint Input Tool , or SharePoint Output Tool.
Use the Output Data tool to write data to your Microsoft SharePoint. Go to Microsoft SharePoint for general information.
Supported Formats
These are the supported formats and options to write data:
If File Already Exists: Select the action Designer takes when writing data.
Abort Operation: Cancels the running workflows if a file with the same name already exists.
Rename: Renames the file and appends a unique number to the end of the file name.
Overwrite Existing File: Overwrites the existing file.
No Spatial Index: Omits creating a spatial index for the output file.
Save Source & Description: Saves the input source and field descriptions with the metadata.
Suppress Output if No Records: Select to cancel the workflow if there are no records to write.
If File Already Exists: Select the action Designer takes when writing data.
Abort Operation: Cancels the running workflows if a file with the same name already exists.
Rename: Renames the file and appends a unique number to the end of the file name.
Overwrite Existing File: Overwrites the existing file.
Enable Compression (Deflate): Compress the output using the Deflate codec.
Support Null Values: Supports null values in the output.
If File Already Exists: Select the action Designer takes when writing data.
Abort Operation: Cancels the running workflows if a file with the same name already exists.
Rename: Renames the file and appends a unique number to the end of the file name.
Overwrite Existing File: Overwrites the existing file.
Delimiters: Enter the delimiter character.
First Row Contains Field Names: Select the checkbox to indicate the first row of the data as field names.
Quote Output Fields: Select to add quotes to fields.
Code Page: Select the code page of the file.
Line Ending Style: Select the line ending style. Available options are Windows, Unix, and Mac.
Write BOM: Select the checkbox to include the byte order mark.
Suppress Output if No Records: Select to cancel the workflow if there are no records to write.
If File Already Exists: Select the action Designer takes when writing data.
Abort Operation: Cancels the running workflows if a file with the same name already exists.
Rename: Renames the file and appends a unique number to the end of the file name.
Overwrite Existing File: Overwrites the existing file.
Append to Existing Table: Appends records to an existing table instead of creating a new file.
Create Int32 Fields as Binary: Stores 32-bit integer fields as binary data.
Code Page: Select the code page of the file.
If File Already Exists: Select the action Designer takes when writing data.
Abort Operation: Cancels the running workflows if a file with the same name already exists.
Rename: Renames the file and appends a unique number to the end of the file name.
Overwrite Existing File: Overwrites the existing file.
Code Page: Select the code page of the file.
If File Already Exists: Select the action Designer takes when writing data.
Abort Operation: Cancels the running workflows if a file with the same name already exists.
Rename: Renames the file and appends a unique number to the end of the file name.
Overwrite Existing File: Overwrites the existing file.
Modify Existing File: Overwrites the data in the existing file.
Sheet Name: Enter the name of the sheet to which to write data.
Skip Field Names: Select the checkbox to omit field names.
Suppress Output if No Records: Select to cancel the workflow if there are no records to write.
Sensitivity Label ID: Enter the sensitivity label ID to apply to the file.
Specify a Range (cells, rows or columns): Select the checkbox to further specify the range from which to read data. The From and To fields accept alphabetical characters for columns, numbers for rows, and combinations of alphabetical characters and numbers for specific cells. Example: A, 1, A1.
If File Already Exists: Select the action Designer takes when writing data.
Abort Operation: Cancels the running workflows if a file with the same name already exists.
Rename: Renames the file and appends a unique number to the end of the file name.
Overwrite Existing File: Overwrites the existing file.
If File Already Exists: Select the action Designer takes when writing data.
Abort Operation: Cancels the running workflows if a file with the same name already exists.
Rename: Renames the file and appends a unique number to the end of the file name.
Overwrite Existing File: Overwrites the existing file.