Note: Excel is a third-party program. Any differences may be based on version/OS. We do not provide support related to Excel or any other third-party program programs.
ControlByWeb devices send log files that can be opened in Excel to keep a longer log history, store multiple logs in a single place, and provide advanced data analysis with graphing. To learn about log files and how they are created in the device’s firmware, read more here.
The log file of your device can be found at deviceip/log.txt (example: 192.168.1.2/log.txt), where you can right click and “Save As” to save the text file. After you have exported or saved your log file, follow the steps below:Windows
- Open Excel and go to the “Data” tab.
- Select “From Text/CSV.”
- Browse your computer and select the log file(s) that you want in Excel.
Mac
- Open Excel and go to the “Data” tab.
- Select “Get Data (Power Query).”
- Select “Text/CSV.”
- Browse your computer and select the log file(s) that you want in Excel.
You will see that the Excel sheet is created and includes columns for Date/Time and Inputs/Outputs and rows for each individual log.
If you only need part of a log file, or you are going to copy/paste the text into an Excel file, use the Text to Columns button in the “Data” tab. Set your delimiter to commas only.
If you have any additional questions about using our devices, contact our support team.