ESP8266 – Wireless Weather Station with Data Logging to Excel
In this project we are going to establish a wireless communication between two ESPs and send data from three sensors to an Excel spreadsheet. This tutorial shows a wireless weather station with data logging that you can implement in your home.
Before you continue reading this project, please complete the following tutorials:
- How to get started with the ESP8266
- How to make two ESP8266 talk
- How to flash your ESP8266 with NodeMCU
If you like the ESP WiFi module and you want to build more projects you can download my eBook called “Home Automation using ESP8266” here. Let’s get started!
Here’s a Figure that describes exactly how everything works together:
Here’s the hardware that you need to make the weather station:
- Recommended: 2x ESP-12E (eBay)
- Alternative: 2x ESP-201 (eBay) + 1x FTDI Programmer (eBay)
- 1x DS18B20 (eBay)
- 1x Breadboard (eBay)
- 3x Pushbutton
- 3x 10k Ohm Resistor
- 1x 4700 Ohm Resistor
- 1x 10k Ohm Potentiometer
DS18B20 – One Wire Digital Temperature Sensor
In this project, we will be using the DS18B20 one wire digital temperature sensor. Now, before we get to the programming part, lets learn how to wire up our temperature sensor.
The DS18B20 can be powered by between 3.0V and 5.5V so you can simply connect its GND pin to GND and the VDD pin to 3.3V from the ESP8266.
Then connect the DQ pin to IO04 on the ESP8266. A 4K7 ohm pullup resistor is required on the DQ pin to pull it up to 3.3V.
For more detail: ESP8266 – Wireless Weather Station with Data Logging to Excel
JLCPCB – Prototype 10 PCBs for $2 + 2 days Lead Time
China’s Largest PCB Prototype Enterprise, 300,000+ Customers & 10,000+ Online Orders Per Day
Inside a huge PCB factory: https://www.youtube.com/watch?v=_XCznQFV-Mw
Current Project / Post can also be found using:
- esp8266 data logger