How can we help?

The Bulk Import tool lets Facilities Managers create multiple buildings and spaces at once by uploading a CSV file, rather than adding each one individually. This is especially useful for initial platform setup or large-scale updates.

Before You Begin

• Administrative access to Rooms is required to use Bulk Import.
• A user with role Facilities Manager or Platform Admin
• Each platform's CSV template is unique — it reflects the Space Capabilities configured for your platform. Do not use a template from another platform.

Step 1: Download Your Platform's CSV Template

1. Log in to Rooms Admin.
2. Navigate to Buildings > Bulk Import Buildings & Spaces.
3. Click Download Template.

The template is generated specifically for your platform and includes all required columns, plus one column for each Space Capability your platform has configured.

Step 2: Fill Out the Template

Building and space columns

Fill in the standard details for each building and space. Required fields include building name, space name, and address. Latitude and longitude are optional — if left blank, they will be automatically calculated from the address during import.

Space Capability columns

Each Space Capability configured for your platform appears as its own column. Refer to the help text on the Bulk Import page to see the valid options for each capability on your platform.

Note: For Multiple Choice capabilities, do not include spaces around the semicolons (e.g., Projector;Whiteboard, not Projector; Whiteboard).

Step 3: Validate Your File

1. On the Bulk Import page, select your completed CSV file.
2. Click Validate.
3. Review the results. Rows with errors will be identified with details on what needs to be corrected.

Common validation errors include:

• Missing required columns or values
• Invalid Space Capability values (e.g., a value not in the accepted list for that capability)
• Incorrect formatting for Multiple Choice capabilities (e.g., using commas instead of semicolons)

Correct any errors in your file and validate again before uploading.

Step 4: Upload

Once validation passes:

1. Click Upload.
2. The system will process your file and create all buildings and spaces, including their Space Capability values.

Tips

• Download a fresh template before each bulk import. Space Capabilities may change as your platform is configured.
• If you receive unexpected validation errors, confirm you are using your own platform's template and not a shared or generic file.