# Homewizard P1 meter data is displayed incorrectly in Google spreadsheet

**URL:** <https://community.homey.app/t/homewizard-p1-meter-data-is-displayed-incorrectly-in-google-spreadsheet/157081>\
**Category:** Flows\
**Created:** [July 10, 2026, 8:36am UTC](https://community.homey.app/t/homewizard-p1-meter-data-is-displayed-incorrectly-in-google-spreadsheet/157081 "2026-07-10T08:36:18Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![HomeyPS](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/homeyps/32/122561_2.png) [@HomeyPS](https://community.homey.app/u/HomeyPS)\
**Post date:** [July 10, 2026, 8:36am UTC](https://community.homey.app/t/homewizard-p1-meter-data-is-displayed-incorrectly-in-google-spreadsheet/157081/1 "2026-07-10T08:36:18Z")

</div>

```auto
I am in the process of sending the data from my Homewizard P1 meter to a Google spreadsheet.

```

To my surprise, I see that the consumption of 1,739.14 is being displayed as 1,739,142.00.It is not clear to me where this is going wrong.Does anyone have an explanation?

 ![spreadsh-01](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/c/3/c3c2811d13234523596121f2784591c8d2a1a155.jpeg)

 ![spreadsh-02](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/a/8/a8eccd0ebf2377b2ab29a16362d10356826cf8a1.jpeg)

---

<div class="post-metadata">

**Author:** ![smarthomesven](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/smarthomesven/32/79712_2.png) [@smarthomesven](https://community.homey.app/u/smarthomesven)\
**Post date:** [July 10, 2026, 9:30am UTC](https://community.homey.app/t/homewizard-p1-meter-data-is-displayed-incorrectly-in-google-spreadsheet/157081/2 "2026-07-10T09:30:47Z")

</div>

The mobile/web app probably rounds the number, while the tag contains the raw data from the HomeWizard app.

---

<div class="post-metadata">

**Author:** ![Wim\_Post](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/wim_post/32/56793_2.png) [@Wim\_Post](https://community.homey.app/u/Wim_Post)\
**Post date:** [July 10, 2026, 2:21pm UTC](https://community.homey.app/t/homewizard-p1-meter-data-is-displayed-incorrectly-in-google-spreadsheet/157081/3 "2026-07-10T14:21:10Z")

</div>

I think your spreadsheet is expecting a decimal comma instead of a decimal point. You can change that in the spreadsheet-settings

---

<div class="post-metadata">

**Author:** ![HomeyPS](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/homeyps/32/122561_2.png) [@HomeyPS](https://community.homey.app/u/HomeyPS)\
**Post date:** [July 10, 2026, 3:02pm UTC](https://community.homey.app/t/homewizard-p1-meter-data-is-displayed-incorrectly-in-google-spreadsheet/157081/4 "2026-07-10T15:02:14Z")

</div>

I have given the fields the following settings: automatic and number.

The variables within Homey do return the correct values.

 ![spreadsh-05](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/8/0/8088e486b2c0542022adef3ec856dbb7aae91f14.jpeg)

 ![spreadsh-04-getal](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/d/c/dc46e112290ff2cca0057f8656eb0d561d4f58ed.jpeg)

 ![spreadsh-03-automatisch](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/0/1/012400f209e9db2064edd326ee564a0d84de6e4e.jpeg)

---

<div class="post-metadata">

**Author:** ![Wim\_Post](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/wim_post/32/56793_2.png) [@Wim\_Post](https://community.homey.app/u/Wim_Post)\
**Post date:** [July 11, 2026, 9:53am UTC](https://community.homey.app/t/homewizard-p1-meter-data-is-displayed-incorrectly-in-google-spreadsheet/157081/5 "2026-07-11T09:53:29Z")

</div>

Om in Google Sheets een decimale punt in plaats van een komma te gebruiken, **verander je de landinstelling (locatie) van je spreadsheet naar een land dat de punt hanteert**, zoals de **Verenigde Staten**.[[1](https://www.pctuts.be/threads/decimaalteken-in-google-sheets.243164/), [2](https://community.homey.app/t/google-sheets-punt-vervangen-door-komma-in-getallen/115121)]

Volg deze stappen om de instelling te wijzigen:

1. Open je spreadsheet in Google Spreadsheets.
2. Klik in het bovenste menu op **Bestand**.
3. Klik op **Instellingen**.
4. Ga naar het tabblad **Algemeen**.
5. Wijzig onder het kopje _Landinstellingen_ het land naar **Verenigde Staten**.
6. Klik op **Instellingen opslaan**. [[1](https://www.pctuts.be/threads/decimaalteken-in-google-sheets.243164/), [2](https://community.homey.app/t/google-sheets-punt-vervangen-door-komma-in-getallen/115121)]

_Let op:_ Hierdoor verandert ook de notatie van duizendtallen (deze wordt een komma) en datums (maand/dag/jaar). [[1](https://support.google.com/docs/answer/56470?hl=nl&co=GENIE.Platform%3DDesktop), [2](https://community.homey.app/t/google-sheets-punt-vervangen-door-komma-in-getallen/115121)]

Als je de taal van de interface zelf in het Nederlands wilt houden, kun je dat na het wijzigen van de landinstelling eventueel aanpassen via je eigen Google-account.

---

<div class="post-metadata">

**Author:** ![HomeyPS](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/homeyps/32/122561_2.png) [@HomeyPS](https://community.homey.app/u/HomeyPS)\
**Post date:** [July 11, 2026, 10:55am UTC](https://community.homey.app/t/homewizard-p1-meter-data-is-displayed-incorrectly-in-google-spreadsheet/157081/6 "2026-07-11T10:55:40Z")

</div>

Hallo **[Wim\_Post](https://community.homey.app/u/wim_post),**

Heb gedaan wat jij voorstelde, werkt! De komma is een punt maar daar kan ik meeleven!

 ![wim_1](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/1/2/125196e851bde37273552794fa37a1bb2e55a77f.jpeg)

 ![wim_2](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/c/1/c1e932742ed3c109ab9ed0cf1a2300df5fa9674d.jpeg)

 ![wim_3](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/2/d/2daa42856007d0942809f20d6b88c883cc6830da.jpeg)

 ![wim_4](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/2/4/24d39d7f3da48a27c2a1559949fcf1946f44768c.jpeg)