# Site Collection
Creates or updates site collections by processing rows from an Excel file. Each row references a named configuration template that defines all site collection settings, with per-row columns providing identifying data or overrides.
Filename pattern: filename must contain sitecollection (case-insensitive) but must not contain deletesitecollection or archivesitecollection.
Example: 20240115 sitecollection provisioning.xlsx
# Columns
| Name | Required | Description |
|---|---|---|
| Code | No | Code that identifies the site collection. Used as the final path segment when constructing the site URL. |
| Title | No | Display title for the site collection. Passed to the template when resolving configuration. |
| SiteCollectionSet / Set | No | Name of a SiteCollectionCfg template defined in config.json. Drives all site collection settings such as owner, language, time zone, and site template. |
| RootServerRelativeUrl / Url | No | Server-relative root path under which the site collection is created (e.g. /sites). Overrides the root URL from the service configuration for this row. |
| Update | No | Boolean. When true, updates an existing site collection instead of creating a new one. Defaults to false. |
| DocIDPrefix / DocNumberPrefix | No | Document ID prefix to set on the site collection. |
Any additional columns are passed as properties available for variable substitution in the configuration template.
# Behavior
No column is strictly required. However, meaningful execution requires at least a SiteCollectionSet so the template can be resolved and a Code so the site URL can be constructed.
When Update is true, the handler combines RootServerRelativeUrl (or the configured root URL) with Code to build the URL of the existing site collection to update.
When RootServerRelativeUrl is provided, it overrides the SharepointRootServerRelativeUrl from the service configuration for that row only.
After creating or updating the site collection, the handler applies any pages and navigation defined in the resolved configuration template.
# Related links
- Permission Set handler — apply permissions after site collection creation
- Doclib Set handler — provision document libraries within the site collection
- Matter List handler — register the site URL for matter resolution by other handlers