Can I use Excel to import my devices and group addresses?

KNX

Can 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.