ImportFile
Import CSV or XLSX files into Smartsheet, specifying the target folder or workspace.
Input
| Name | Type | Required | Description |
| SheetName | String | True | Required. Specifies the name of the new sheet to be created in Smartsheet. This will appear as the title of the sheet. |
| HeaderRowIndex | String | False | Optional parameter. A zero-based integer that identifies the row to use as column headers in the imported file. Rows before this index are ignored during the import. If omitted, columns are assigned default names such as Column1, Column2, etc. |
| PrimaryColumnIndex | String | False | Optional parameter. A zero-based integer indicating which column to set as the primary column in the new sheet. The primary column is used for unique identifiers and critical data. Defaults to 0 if not specified. |
| FileName | String | True | Specifies the name and extension of the file to upload, including the optional full file path if the Content parameter is not used. For example: 'C:/Users/Public/Desktop/Departments.csv'. |
| FolderId | String | False | Specifies the folder where the new sheet will be created. If provided, the imported data is saved into a new sheet within this folder. |
| WorkspaceId | String | False | Specifies the workspace where the new sheet will be created. If provided, the imported data is saved into a new sheet within this workspace. |
| Overwrite | String | False | Indicates whether to overwrite an existing sheet with the same name. If true, FolderId or WorkspaceId is required and the existing sheet will be replaced with the new data.
The default value is false. |
Result Set Columns
| Name | Type | Description |
| Id | String | The unique identifier of the newly created or updated sheet. |
| Name | String | The name of the newly created or updated sheet as it appears in Smartsheet. |
| AccessLevel | String | The access level of the current user on the new sheet, such as 'Viewer', 'Editor', or 'Admin'. |
| Permalink | String | The direct URL link to access the newly created or updated sheet in Smartsheet. |
| Success | String | Indicates whether the deletion operation was successful. Returns 'true' for success or 'false' if the operation failed. |