I recently started experimenting with my Homematic IP Smart Meter (HmIP-ESI-IEC) to monitor my PV energy production. After syncing the data for the first time and exporting it to a CSV file, I was a bit puzzled by the formatting issues I encountered in Excel. The date and value columns weren’t displaying correctly—dates were showing as numbers like 1332025 instead of 13.3.2025, and values like 817.144 were appearing as 817144. This made analyzing the data a bit of a headache, especially for the 2500+ rows spanning from 5.3.25 to 13.3.25.
After some research and trial and error, I figured out a workaround by manually converting the date and value columns. However, I’m still curious if there’s a more efficient way to handle this export process or if there’s a setting I might have missed in the Homematic IP interface. If anyone has tips or tricks for dealing with smart meter data exports, I’d love to hear them!
On a lighter note, I’m really enjoying how much insight these smart devices provide into my energy usage. It’s motivating me to be more conscious about conserving energy. If you have any favorite tools or methods for analyzing smart meter data, please share—I’m always looking for new ways to make the most of this information!
Thanks for your support and insights!