# Adding Data to Sensor.Community using live excel data

**URL:** <https://forum.sensor.community/t/adding-data-to-sensor-community-using-live-excel-data/1100>\
**Category:** Uncategorized\
**Created:** [December 22, 2021, 3:06am UTC](https://forum.sensor.community/t/adding-data-to-sensor-community-using-live-excel-data/1100 "2021-12-22T03:06:19Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Paolo](https://forum.sensor.community/user_avatar/forum.sensor.community/paolo/32/941_2.png) [@Paolo](https://forum.sensor.community/u/Paolo)\
**Post date:** [December 22, 2021, 3:06am UTC](https://forum.sensor.community/t/adding-data-to-sensor-community-using-live-excel-data/1100/1 "2021-12-22T03:06:19Z")

</div>

Morning

Does anyone know if we can convert live feed excel data for use on the Sensor.Community website.

The idea would be to convert the excel to the more appealing visual presentation of data.

The monitors used are not configured to feed data to Sensor.Community.

Example of data.

 ![Data](https://forum.sensor.community/uploads/default/original/1X/efecb69ae632a8d9e6cb765873ca02754ea89b3b.jpeg)

Regards

Paolo

---

<div class="post-metadata">

**Author:** ![pjg](https://forum.sensor.community/user_avatar/forum.sensor.community/pjg/32/194_2.png) [@pjg](https://forum.sensor.community/u/pjg)\
**Post date:** [December 22, 2021, 5:43am UTC](https://forum.sensor.community/t/adding-data-to-sensor-community-using-live-excel-data/1100/2 "2021-12-22T05:43:31Z")

</div>

Are the data good? Which sensors?  
It could be done with openpyxl…

---

<div class="post-metadata">

**Author:** ![Paolo](https://forum.sensor.community/user_avatar/forum.sensor.community/paolo/32/941_2.png) [@Paolo](https://forum.sensor.community/u/Paolo)\
**Post date:** [December 22, 2021, 6:10am UTC](https://forum.sensor.community/t/adding-data-to-sensor-community-using-live-excel-data/1100/3 "2021-12-22T06:10:08Z")

</div>

Morning PJG

The data from the monitors has been accredited by the South African National Accreditation Service (SANAS)

Could you please explain openpyxl or send me a link.

Thanks for your input.

Regard

Paolo

---

<div class="post-metadata">

**Author:** ![pjg](https://forum.sensor.community/user_avatar/forum.sensor.community/pjg/32/194_2.png) [@pjg](https://forum.sensor.community/u/pjg)\
**Post date:** [December 22, 2021, 7:19am UTC](https://forum.sensor.community/t/adding-data-to-sensor-community-using-live-excel-data/1100/4 "2021-12-22T07:19:18Z")

</div>

Python is a very commun programming language which can run server side.  
Openpyxl is a library for python to read/write excel spreadsheets.  
Sensor.Community uses an API to receive the data of all the sensors. This API is described here: [EN APIs · opendata-stuttgart/meta Wiki · GitHub](https://github.com/opendata-stuttgart/meta/wiki/EN-APIs)

You can write a porgramm which calls and loads the excel file. With openpyxl, you read the values and the time and prepare a json file compliant with the one which has to be sent to the API. You do a POST request with Python.

You will need a server or you’ll have to let a computer run…

---

<div class="post-metadata">

**Author:** ![Paolo](https://forum.sensor.community/user_avatar/forum.sensor.community/paolo/32/941_2.png) [@Paolo](https://forum.sensor.community/u/Paolo)\
**Post date:** [December 22, 2021, 7:49am UTC](https://forum.sensor.community/t/adding-data-to-sensor-community-using-live-excel-data/1100/5 "2021-12-22T07:49:52Z")

</div>

Thanks Pierre-Jean.

A little beyond my skill set.

Crazy season now will a lot of people off until mid January.

I will find out all the server and monitor information and will keep you posted.

All the monitors feed to a central server and then record excel information on the website. Older technology.

But from what you tell me there is a possibility that we could also feed the information into Sensor.Community.

Thanks again for your input.

Regards

Paolo