The readings of the Shelly EM are stored in a .csv-file. To open this file in about Excel, it is advantageous to save them first on the disk. Opening directly while in Windows Explorer results in a rather unreadable Excel spreadsheet.
More professional is the following process:
- Save .csv-file to disk, DO NOT open, assign appropriate name
- Open Excel
- In the tab menu on "data", here "from text"
- Upcoming window "Import text-file", here you can select the previously saved .csv-file -> "Open"
- Now the .csv-file appears as a very readable Excel spreadsheet.