#9 Arduino Data Logger with Direct Input to Excel

I build a Datalogger with keyboard input to Excel. It can measure volt and ampere and two additional analog signals.
I use it to check-out the buck converter of my previous video.
As promised, I use here the prototyping PCB aproach to build it.
I enhance also the precision of the built in analog-to digital converters (ADC) of the Arduinos.

The coding is on Github:

Here you find the source for the precision incres for Arduino ADCs:

[raynermihailov]

Arduino Data Logger with Direct Input to Excel? Where is the info how do you really log it to excel? The rest is unnecessary, if it is not show everything. It will be fair to put correct name "Arduino Data Logger with not showing how to do Direct Input to Excel".

[BernhardHofmann]

I must be missing something. Can't you just write to serial from the Arduino and have a little program on the PC listening and writing to a file?

[m.vpopko]

Hello,

Can you add links to modules you used?

Thanks

[deangreenhough]

Thank you for your informative reply. I will purchase a Leonardo as instructed, as I must have this setup in my lab.

[OnnieKoski]

Here from 9 years in the future. This is a great idea. I might have to borrow it for recording spatial coordinates on a DIY CMM

[fromgermany]

„I love that they work when I sleep“.
After 35y working with them, computers often kept me away from sleeping.🤠

[raymondsipat]

hi bro how can i be able to split the data cause in data streamer in excel the data shows together in one column, i would like to see the data in to different column. for example analog 0 store data in column 1 then analog 1 store data in column 2. something like this, thanks

[rarenu]

I am 72 years old retired Telecom Engineer and my hobby is Arduino. I really admire your Videos and a staunch fan of your articles. Your data logger project is, one of "The Best" and I am really fascinated by it.
I assembled it and it works, but the Voltage readings shows, 888 milli Volt for 3.7 Volts . Is there any multiplication factor to be set or any calibration process involved. Please show me the few lines of code that handles the calibration to get correct reading. Thank you for your service to our DIY electronics community. With Great Regards, Ragothaman R.

[johndenverrasco]

greetings, can i ask how to connect your data logger in the 3 phase distribution panel?

[Greenpoison]

I was looking for a way to log the sensor value realtime and boom. you're the best

[craiglarson]

Andreas: great stuff, thanks again. I think of your videos as I used to think of the library: and endless resource.
Hope it helps!

[dnyaneshvarsalve]

Hi Sir,
Plz share link of Windows app or plz tell me how to configure "Excel" to receive serial data?

[LUCKY]

Thanks for valuable support.

I tried your code but it shows me an error
'keyboard' only supports on the Arduino Leonardo
Please guide me

[Emtron_Technologies]

Hi Andreas, Do we need to remove the PC keyboard to detect Arduino micro as a keyboard.

[hafizuddinmohdlowhim]

Hi Sir, great job but perhaps you could enlighten me.
How do you key-in the data into Excel? I don't understand the concept.

Thanks

[os-channel]

Hallo Andreas,
das ist ein tolles Projekt, aber wie bekommst Du die automatische Eintragung der Werte in Excel hin?

[fumezflori]

A pleasure to watch your videos, is like Terminator teaches you electronics. Can you make a system that can Bottom Balance the 18650 easy ? I have one simple ideea and that is to use the latest Tp 4056 usb (5v) charger that in theory has a cut-off on output voltage @ 2.5 but this will need to be tested and the other one is to use a more clever setup (I have all the faith in your ability :) ) that use "1-8S Lipo/Li-ion/Fe Battery Voltage Tester Low Voltage Meter Tester Alarm OE" with relays .
Thank you!

[wahidsalah]

Dear, Im making a project with the rc522 (RFID) to log onto computer directly, now i need to run rc522 on 3.3v while the micro gives 5v through usb, any work around ?
Thanks for your time and beautiful channel

[robertcameronjones]

I must be getting old, because I missed the part where you explained how to get this into excel. After a lot of searching, I found the keyboard class, which requires a change to the Arduino Tools-USB menu to even get it to compile, and at least in case of the MAC, some security hoops to jump through to authorized that as a keyboard. I made a big mistake where the Teensy kept putting out characters, overrunning my computer, and I could not get my Teensy to reprogram because it was too busy talking to listen. After quite a bit of playing around, I found I could stop the program and put it into programming mode with the pushbuttons so I could bootload a fixed version of the program. Great videos - please keep them up!

[victororo]

This is like Mind Blowing AWESOME! Your abilities are out of this world! You have to be an alien! Where do you park your UFO? Sheesh, I'm just getting into data logging. And I never would have thought that this was possible! Automatically inputting data onto you pc. WOW!