How to Read Arduino into Excel!

Let's use a handy Excel add-in to get data directly from our Arduino board, huzzah!! This video I show you how to do that and what you can do with that data to see all the interesting things.

[ricardoguy]

FUCKING LIFE SAVER THANK YOU SO MUCH JEN!!!! I have to do a lot of work with my Arduino for my masters degree in space systems engineering and you saved my life thank you!

[ragder]

Super cool, I'll be updating my heat transfer calcs now with REAL data

[reekrev]

To combine the video with showing Excel, you can use Open Broadcaster Software (obsproject).

[rolandberendonck]

This is such an amusing video to watch!! Thank you for your enthousiasm :)

[MrAshwindersingh]

You should record your screen using camtasia software

[dcpowered]

Love your video and enthusiasm!! However, if i understood correctly, there is a limit of 500 data values in one recording? If yes, then it is not enough for my application. But thanks for sharing anyway. Looking forward to your next videos! All the best.

[jafinch]

Nice demo. Looks like the data streamer add-in is only for the MS Office 365 version. I've been using my 2000 Pro license since back when I purchased until the last year or so. I do have a Office 2007 Enterprise Ed. I invested in also back when I was working on my second B.S. programming... though have never used. I think it was last year I decided to just use LibreOffice and even with that I hesitate to upgrade to the newer versions since a few months back I broke down and invested in a Win 10 build. Now, my question... are you aware of a plugin (app, macro or script I'm guessing is since reads like the add-in is a Visual Studio object coded somehow to sync with the data stream for the MCU's designed for) that will work for the older MS Excel or Libre Office? Thanks for sharing and in advance for your time.

[jedaatencia]

Una pregunta donde puedo encontrar la guia de la que hablas sobre tu sitio web Arduino, en donde explican el paso a paso de Arduino a Excel?

[danieldolinar]

How did it work, that one value is shown on CH1 and the other one at CH2, when I try this, i see both values at CH1, may you show me the Arduino sketch?

[thegspdman]

Thanks for sharing Jen, will the excel sheet be updated automatically?

[ammarahmed]

What do you mean by separate the points with commas? I'm using the DHT11 tester sketch and am extremely new to arduinos. I'm not sure how to get the readings into separate columns

[daveharveys]

Thanks Jen, been looking how to do this for a while. I've got to plot 4 batteries through their discharge cycle and this is exactly what I needed.

[homeinspectingwithjohnhans]

Hi Jen,
Based on what I read on the MS site where the Data Streamer is offered for download, it seems that Windows 10 and Excel 2016 with a subscription to Office 365 are the minimum requirements or as I call them, 'prerequisites'. I am searching for a similar straightforward solution that will work in Windows 10 with Excel 2013 and not require a subscription? Is there anything out there that can do this? Any way that will not require Python nor any other Arduino Shield, nor other computer hardware, nor a subscription?

[nibblesd.biscuits]

Good tips thanks, FYI your camera was struggling because the pc screen pulses in brightness and that throws off the exposure control of the camera. If you haven't figured this out already set your camera to manual focus and exposure and dial in your levels before starting. Also it's pretty impossible to get good shots of a screen so that's why people turn to screen cap overlays obviously.

[Koko-cqfb]

Is there any way to change the color based on the output number? (example if the number outputted is in between 80-90 then yellow and if it’s between 91-100 turn red)

[DFEnterprisehowto]

Can you help with some code for a transducer monitoring?

[donepearce]

Thanks for this, Jen. I was concerned that the streamer was only for Office 365 - that's the impression they gave. But no, it downloaded just fine for my "real" Excel. And moreover, it works. Without this I had written a long VBA script to achieve the function, but this is easier.

[rokibulhassanremon]

it will be much better if you share your pc screen with us and then record the video

[ADVICESTECHNO]

Hello is it possible to use an input key to open a python file with usb serial?

[teriemerick]

Can I use Excel 2016? I don't see the Data Streamer com add-in in Office 2016. How do I get it without installing 365?