Hi im currently working on a project using arduino uno and mpu6050 to get readings of the gyroscope and accelerometer when i move the board. But im having difficulties trying to extract the data out to excel etc for other purposes. Can you guide me on how to save the data? Im using the code below to get the readings.

This allows any sensor data read by your Arduino to be stored with an accurate time stamp to an SD card. In this example sketch we will continually read the value of an LM35 temperature sensor and store the result together with the current time and date to a CSV file. This file can then be loaded into a spreadsheet such as Excel or Open Office. Calibratable Temperature-Humidity Meter with Excel-formatted Data, 19. Arduino write to csv file, 20. Arduino excel plx-daq, 21. Arduino serial monitor to excel, 22. Save data from arduino to computer, 23. Arduino temperature humidity data logger, 24. Csv excel import, 25. Data acquisition for excel, 26. Arduino to excel real time, 27.

// MPU-6050 Short Example Sketch
// By Arduino User JohnChi
// August 17, 2014
// Public Domain
#include<Wire.h>
const int MPU_addr=0x68; // I2C address of the MPU-6050
int16_t AcX,AcY,AcZ,Tmp,GyX,GyY,GyZ;
void setup(){
Wire.begin();
Wire.beginTransmission(MPU_addr);
Wire.write(0x6B); // PWR_MGMT_1 register
Wire.write(0); // set to zero (wakes up the MPU-6050)
Wire.endTransmission(true);
Serial.begin(9600);
}
void loop(){
Wire.beginTransmission(MPU_addr);
Wire.write(0x3B); // starting with register 0x3B (ACCEL_XOUT_H)
Wire.endTransmission(false);
Wire.requestFrom(MPU_addr,14,true); // request a total of 14 registers
AcX=Wire.read()<<8|Wire.read(); // 0x3B (ACCEL_XOUT_H) & 0x3C (ACCEL_XOUT_L)
AcY=Wire.read()<<8|Wire.read(); // 0x3D (ACCEL_YOUT_H) & 0x3E (ACCEL_YOUT_L)
AcZ=Wire.read()<<8|Wire.read(); // 0x3F (ACCEL_ZOUT_H) & 0x40 (ACCEL_ZOUT_L)
Tmp=Wire.read()<<8|Wire.read(); // 0x41 (TEMP_OUT_H) & 0x42 (TEMP_OUT_L)
GyX=Wire.read()<<8|Wire.read(); // 0x43 (GYRO_XOUT_H) & 0x44 (GYRO_XOUT_L)
GyY=Wire.read()<<8|Wire.read(); // 0x45 (GYRO_YOUT_H) & 0x46 (GYRO_YOUT_L)
GyZ=Wire.read()<<8|Wire.read(); // 0x47 (GYRO_ZOUT_H) & 0x48 (GYRO_ZOUT_L)
Serial.print('AcX = “); Serial.print(AcX);
Serial.print(” | AcY = “); Serial.print(AcY);
Serial.print(” | AcZ = “); Serial.print(AcZ);
Serial.print(” | Tmp = “); Serial.print(Tmp/340.00+36.53); //equation for temperature in degrees C from datasheet
Serial.print(” | GyX = “); Serial.print(GyX);
Serial.print(” | GyY = “); Serial.print(GyY);
Serial.print(” | GyZ = '); Serial.println(GyZ);
delay(333);
}

Use of a simple instrumentation method (based on Arduino and Excel) to acquire, monitor and store PV system data in real-time.

• 10,387 views
• 2 comments
• 21 respects

Components and supplies

Necessary tools and machines

About this project

This project proposes a Low-cost way of virtual instrumentation for real-time monitoring of the PV panel characteristics such as voltage, current and power. The system design is based on a low-cost Arduino acquisition board. The acquisition is made through a low-cost current and voltage sensors, and data are presented in Excel by using the PLX-DAQ data acquisition Macro.

The structure of the equipment used is shown in the Figure below. The PV current and voltage are obtained through the current and voltage sensors. The output of the two sensors is then transmitted to the microcontroller of the Arduino UNO board. During the acquisition process, the data obtained are stored and plotted in real-time in the Excel spreadsheet.

This project is linked to thisresearch paper.

Explanatoryvideo:

Code

Schematics

Team members

Aboubakr_El Hammoumi

• 3 projects
• 8 followers

Arduino Data Acquisition Into Excel Template

Saad Motahhir

• 4 projects
• 6 followers

Members who respect this project

Arduino Data Acquisition Into Excel Tutorial

and 14 others

Arduino-based Data Acquisition Into Excel Labview And Matlab

Table of contents

Arduino Data Acquisition Into Excel Pdf