• Arduino-based Data Acquisition Into Excel Labview And Matlab
• Arduino Data Acquisition Into Excel Tutorial
• Arduino Data Acquisition Into Excel Pdf

Few weeks ago I made a datalogger using Arduino, SD card, DS3231 real time clock chip and DHT22 sensor which logs: date, time, temperature and humidity values where data is stored on a text file in the SD card.
This topic shows how to build the same data logger using Arduino, DHT22 sensor and Microsoft Excel where the Arduino sends data (temperature and humidity) serially to an Excel sheet.

Related Projects:
Arduino datalogger with SD card, DS3231 and DHT22 sensor
Arduino with DHT22 sensor and LCD

Hardware Required:

ARDUINO BASED DATA ACQUISITION SYSTEM 9 Pin 13. There is a LED connected to the digital pin 13. When the pin value is HIGH, the LED is on, and when the value is LOW, the LED is off. Digital inputs and outputs 2.1.4 Analog inputs Arduino UNO has 6 analogical inputs, from A0 to A5, and each one offers a. We know that Arduino allows to acquire data in the analog input. We can use Excel to store data in a sheet and display it in a graph using an application available on the network called PLX-DAQ (Parallax Data Acquisition), but this software doesn't work under Windows 10 and is no longer supported.

• Arduino board
• DHT22 digital humidity and temperature sensor
• 4.7k ohm resistor
• Breadboard
• Jumper wires

The Circuit:
Project circuit schematic is shown below.

As shown above, the circuit is very simple we need the DHT22 sensor only and there is no need for a real time clock chip (DS3231, DS1302, DS1307 …) because Microsoft Excel can get data and time information from Windows.

The DHT22 sensor has 4 pins (from left to right): VCC (5V), data, NC (not connected pin) and GND. Data pin is connected to Arduino UNO pin 2.

Arduino Code:
To read data (temperature and humidity) from the DHT22 sensor we need a small library which can be downloaded from the link below. After downloading the library, it can be added to Arduino IDE by going to: Sketch –> Include Library –> Add .ZIP Library …
Adafruit DHT sensor library – GitHub

In order to send data serially from the Arduino board to Excel we need a small software named PLX-DAQ (Parallax Data Acquisition tool). This software is just an add-in for Microsoft Excel. PLX-DAQ download link can be found in the page below:
https://www.parallax.com/downloads/plx-daq

After downloading and installing you will see a new folder created in your PC desktop named: PLX-DAQ which contains two shortcut files: PLX-DAQ Help File and PLX-DAQ Spreadsheet. Double click (or open using Excel) on the second file (PLX-DAQ Spreadsheet) gives a window as the one shown in the picture below. If there is a security warning (macros have been disabled) just click on Options –> check: Enable this content –> OK . Note that this plugin was tested with Microsoft Office 2007 and it should work with Office 2010, but unfortunately it doesn’t work with Office 2013.

To start receiving data just choose the COM port and baud rate then click on Connect (Arduino IDE serial monitor must be closed before connecting with PLX-DAQ software).

Full Arduino code:

Arduino-based Data Acquisition Into Excel Labview And Matlab

Finally as a result I got the following Excel sheet:

If you have a problem with time column (column B) just select that column –> right mouse click –> Format Cells (a new window will open) –> select Time (from a list on the left) –> OK .

As I have started my Air Quality project I was searching the web, trying to find information hot to calibrate my new Grove Dust Sensor (I would appreciate any information on this), my eye caught this site (Robottini) and I can say that I was excited.

Arduino Data Acquisition Into Excel Tutorial

Some guys from Parallax made a program called PLX-DAQ and it does this: Allows you to capture data in real time to your Excel spreadsheet and plot them (in real time too).

I did not spend much time with this program but I can say it works and its very easy. With this one the user doesn’t have to spent time importing csv files to excel or any other language he uses. As Parallax says: Parallax Data Acquisition tool (PLX-DAQ) software add-in for Microsoft Excel acquires up to 26 channels of data from any Parallax microcontrollers and drops the numbers into columns as they arrive. PLX-DAQ provides easy spreadsheet analysis of data collected in the field, laboratory analysis of sensors and real-time equipment monitoring.

Arduino Data Acquisition Into Excel Pdf

I wrote a small script and uploaded to my Arduino to see if PLX-DAQ works. I used the same circuit as described in my previous article From Arduino to R (matlab,mathematica etc). The code is the following. Enjoy!!