Bulk user import allows you to create hundreds or thousands of guest WiFi accounts at once using a CSV file, eliminating tedious manual account creation. This is essential for hotels assigning accounts to rooms, conferences distributing credentials to attendees, or organizations provisioning WiFi access for large groups.
This guide walks you through preparing a CSV file with account parameters and importing it into Spotipo. Each account can have custom settings for duration, data limits, and speed restrictions.
What you'll accomplish:
Prepare a CSV file with guest account credentials and parameters
Configure duration, data limits, and speed restrictions per account
Import multiple accounts simultaneously
Generate unique WiFi credentials for distribution
What you'll need:
Spotipo account with username/password login enabled
CSV template file (download from Spotipo)
Spreadsheet software to edit CSV (Excel, Google Sheets)
Spotipo supports username & password login where you can create accounts for your Guests. If you have a large number of accounts to be created, instead of manually creating them one by one, you can use the CSV import functionality.
Here are the steps:
Prepare the CSV file.
Please download this template. And fill in the account values.
duration_valSpecifies how long this account should be valid. Type the Integerduration_typeSpecifies the unit forduration_typetype Integar values1 for Minutes
2 for Hours
3 for Days
bytes_tHow much data should this account have type Integer use 0 for unlimitedbytes_type= Specifies the unit forbytes_ttype Integer1 for the Total limit
2 for Daily limit
3 for Weekly limit,
4 for Monthly limit
speed_dl= Download speed (Kbps), Use 0 for unlimitedspeed_ul= Upload speed (Kbps), Use 0 for unlimited
Import Accounts
Once the file is ready, navigate to the right site using the site selector. Go to the Guest accounts tab and use the import option
Accounts Successfully Imported
After uploading your CSV file, all accounts are created with the specified parameters. You can now distribute credentials to guests via printed cards, email, or your preferred method.
What to do next:
Export the account list if you need to print credentials
Test a few accounts to verify duration and limits work correctly
Create a distribution system for delivering credentials to guests
CSV parameter quick reference:
duration_type: 1=Minutes, 2=Hours, 3=Days
bytes_type: 1=Total, 2=Daily, 3=Weekly, 4=Monthly
Speed limits: Enter value in Kbps (0=unlimited)
Common import errors:
Invalid CSV format: Ensure file matches template structure exactly
Missing required fields: Username and password are mandatory
Invalid parameter values: Use integers for duration_type and bytes_type
Still having trouble importing users? Contact Spotipo support via live chat or email us at [email protected].