Can I use Excel to import my devices and group addresses?
KNXCan I Use Excel to Import My Devices and Group Addresses?
Yes, Thinka fully supports the use of Excel for importing and exporting your devices and group addresses!
- Exporting Data: Easily back up your Thinka configuration by accessing the web interface. Navigate to Backup and Restore in the menu and select Export to Excel. Your configuration will be downloaded as a CSV file, ready to open in Excel.
- Importing Data: You can prepare your own Excel file for import. Ensure your file contains the following 11 columns:
- Room Name
- Device Name or Unique Number
- Service Name (as shown in HomeKit)
- Service Type (e.g., Switch, LightBulb, Thermostat)
- Type: Characteristic or Parameter
- Name of Characteristic or Parameter
- Listen (Read) Address
- Set (Write) Address
- (Optional) Manufacturer
- (Optional) Model
- (Optional) Serial Number
After filling out your Excel sheet, save and export it as a CSV file. Then, simply click Import CSV in the Thinka web interface to upload your configuration.
Need help getting started? Download a sample Excel file here for your reference.