Hackster.io gives professionals and hobbyists the resources they need to build hardware, the easy way. Start building.

Arduino to Excel using V-USB

Log 6 analog and 8 digital pins from Arduino Uno simultaneously in Excel.

Showcase

Parts you will need

Description Vendor Unit price Qty Total cost
* polyfuse Newark $0.23 1 $0.23
** 1K8 Ohm Newark $0.02 1 $0.02
68 Ohm Newark $0.04 2 $0.08
1N5227B Zener 3.6V Newark $0.02 2 $0.03
USB connector eBay $0.30 1 $0.30
Your Existing Arduino You $0.00 1 $0.00
Total cost $0.65

Notes

* The polyfuse is optional and not shown in the reference schematic for V-USB, but I strongly recommend it.  Your PC USB port can only supply a reasonable amount of medium-current for the Arduino and the polyfuse will protect should you short something by accident.

** The value of this resistor varies from reference design to reference design.  The value shown in the Parts List is the value that I have found to work adequately.

The test interface built by rancidbacon, the Arduino library required, and his notes can be found here: 
http://code.rancidbacon.com/ProjectLogArduinoUSB

If you need help to install the library, please see:
http://arduino.cc/en/Guide/Libraries

More projects and support forum for V-USB is here:
http://www.obdev.at/products/vusb/prjall-de.html

Sample output and format of the Arduino as seen on the USB port:
ANALOG0 426
ANALOG1 401
ANALOG2 378
ANALOG3 373
ANALOG4 362
ANALOG5 445
DIGITAL 3L 6L 7L 8H 9H 10H 11H 12H

Arduino Uno code (Atmega328P)

Download USB_HID_AnalogX6_D8.ino

Overview

With the Arduino Leonardo, HID keyboard was brought into the forefront of Arduino usage.  Essentially, once programmed, the Leonardo can act as a keyboard on the PC USB port and send "keystrokes" to the PC which applications think are coming from the primary attached keyboard.  In fact, both the primary keyboard and the virtual keyboard are active!

But there is another, inexpensive, and cross platform way (I have used this with WindowsOS:XP, Vista, 7, 8, 8.1 and with OS X) to get Arduino keystrokes into an application.  This project is simple and uses a library written by an Arduino Forum member which makes the implementation a breeze.  My code will show a very simple implementation of using the library.  I wrote an Excel spreadsheet with formulas to show how flexible this implementation can be: 8 digital channels and 6 analog channels are displayed repeatedly in Excel to create a very unique data-logger.

This is both a fun project and a useful project to understand the power of V-USB with older Arduino and homemade board-duinos which would benefit from USB input to the PC for logging purposes.

Ray

V-USB Reference Design

Excel spreadsheet for HID-Arduino example

Metadata

Created on 2014-01-16
Technologies
Arduino
Users who respect this project Respect project
85ff2fde05a8f0e4e16f04628c7c7b54 2edf7c1337f3280cef759f03199b4cc8 Thumb luis nogueira cunha Thumb new4 good D11764d743848a8e497c137c6bfca1f5

Comments and feedback

Johan Nijsse
Johan Nijsse

It looks great! I connected Arduino to Excel with a VBA macro (Selmaware PLX-DAQ). Can I contact Ray Burnette to ask him some questions about this project?

6 months ago
Ray Burnette
Ray Burnette

Johan, please refer to http://forum.arduino.cc/index.php?topic=135623.0 and if that does not answer your questions, I will attempt to answer there.

6 months ago
Projects Tools Ask an expert Add project Sign up / Login

Share

Embed the widget on your own site

Arduino to Excel using V-USB

Arduino to Excel using V-USB

by Ray Burnette

Log 6 analog and 8 digital pins from Arduino Uno simultaneously in Excel.


7072 5 2

Add the following snippet to your HTML: