User Bulk Upload
Add Members in Bulk with CSV Upload
Upload all your users in one go with our “Bulk Add” feature of Roomzilla.
What’s CSV? A CSV is a comma-separated values file, which allows data to be saved in a tabular format. CSVs look like a garden-variety spreadsheet but with a .csv extension. CSV files can be used with most spreadsheet programs, such as Microsoft Excel or Google Sheets.
1. Create the file – start off by creating either a Google spreadsheet or Microsoft Excel file to prepare your list. While formatting your list correctly is really important, it shouldn’t take long to prepare the list.
For each user you want to add, enter the following required information in columns A-D:
- [A] FIRST NAME,
- [B] LAST NAME,
- [C] EMAIL,
- [D] USERS ROLE (in Roomzilla – admin or member).
Your CSV file must precisely match the following format:
2. Download CSV – now you have prepared your list in a spreadsheet, you need to download the file as a CSV.
- Google Sheets: Select “File” [1], “Download” [2], then choose: Comma-separated values (.csv) [3].
- Microsoft Excel: Select “File” [4], then “Export” [5] and “Change File Type” [6], then choose “CSV (Comma delimited)” [7] and hit “Save As” [8].
3. Upload to Roomzilla – now you have prepared your list and downloaded it in the correct format, you simply have to upload it to Roomzilla (max file size is 1 MB).
Head to the “Users” tab [9], where you will see the “Bulk Add” button [10]. Upload the CSV file you prepared [11] and confirm [12].
4. Done! All new users will receive invitation emails to set up their accounts in Roomzilla.
The following aspects are worth noting:
- The maximum file size allowed is 1 MB.
- If someone is already on your user list, we won’t send them another invitation.
- The invitation will not be sent if any of the required cells [A-D] is left blank or filled with an invalid format (e.g., jwilliams@@example.com, jwilliams@example,com).