element14 Community
element14 Community
    Register Log In
  • Site
  • Search
  • Log In Register
  • Community Hub
    Community Hub
    • What's New on element14
    • Feedback and Support
    • Benefits of Membership
    • Personal Blogs
    • Members Area
    • Achievement Levels
  • Learn
    Learn
    • Ask an Expert
    • eBooks
    • element14 presents
    • Learning Center
    • Tech Spotlight
    • STEM Academy
    • Webinars, Training and Events
    • Learning Groups
  • Technologies
    Technologies
    • 3D Printing
    • FPGA
    • Industrial Automation
    • Internet of Things
    • Power & Energy
    • Sensors
    • Technology Groups
  • Challenges & Projects
    Challenges & Projects
    • Design Challenges
    • element14 presents Projects
    • Project14
    • Arduino Projects
    • Raspberry Pi Projects
    • Project Groups
  • Products
    Products
    • Arduino
    • Avnet & Tria Boards Community
    • Dev Tools
    • Manufacturers
    • Multicomp Pro
    • Product Groups
    • Raspberry Pi
    • RoadTests & Reviews
  • About Us
  • Store
    Store
    • Visit Your Store
    • Choose another store...
      • Europe
      •  Austria (German)
      •  Belgium (Dutch, French)
      •  Bulgaria (Bulgarian)
      •  Czech Republic (Czech)
      •  Denmark (Danish)
      •  Estonia (Estonian)
      •  Finland (Finnish)
      •  France (French)
      •  Germany (German)
      •  Hungary (Hungarian)
      •  Ireland
      •  Israel
      •  Italy (Italian)
      •  Latvia (Latvian)
      •  
      •  Lithuania (Lithuanian)
      •  Netherlands (Dutch)
      •  Norway (Norwegian)
      •  Poland (Polish)
      •  Portugal (Portuguese)
      •  Romania (Romanian)
      •  Russia (Russian)
      •  Slovakia (Slovak)
      •  Slovenia (Slovenian)
      •  Spain (Spanish)
      •  Sweden (Swedish)
      •  Switzerland(German, French)
      •  Turkey (Turkish)
      •  United Kingdom
      • Asia Pacific
      •  Australia
      •  China
      •  Hong Kong
      •  India
      • Japan
      •  Korea (Korean)
      •  Malaysia
      •  New Zealand
      •  Philippines
      •  Singapore
      •  Taiwan
      •  Thailand (Thai)
      • Vietnam
      • Americas
      •  Brazil (Portuguese)
      •  Canada
      •  Mexico (Spanish)
      •  United States
      Can't find the country/region you're looking for? Visit our export site or find a local distributor.
  • Translate
  • Profile
  • Settings
Arduino
  • Products
  • More
Arduino
Arduino Forum arduino data logger
  • Blog
  • Forum
  • Documents
  • Quiz
  • Events
  • Polls
  • Files
  • Members
  • Mentions
  • Sub-Groups
  • Tags
  • More
  • Cancel
  • New
Join Arduino to participate - click to join for free!
Actions
  • Share
  • More
  • Cancel
Forum Thread Details
  • Replies 12 replies
  • Subscribers 403 subscribers
  • Views 1330 views
  • Users 0 members are here
  • arduino
  • googledocs
Related

arduino data logger

Former Member
Former Member over 11 years ago

hi,

i need to save sensor data in excel sheet through online can any one suggest me a model project pls...and one more thing how to get the form key of google form .....

  • Sign in to reply
  • Cancel
Parents
  • wangyeee
    wangyeee over 11 years ago

    you can store sensor readings in text file, and seperate them with commar. then change file extension to csv, and most spreadsheet apps will recognize it.

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
Reply
  • wangyeee
    wangyeee over 11 years ago

    you can store sensor readings in text file, and seperate them with commar. then change file extension to csv, and most spreadsheet apps will recognize it.

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
Children
  • Former Member
    Former Member over 11 years ago in reply to wangyeee

    am using atmega2560 and ethernet sheild..i cant save the txt file i tried with the cardinfo pgm but the car info hasnot retrived..

    /*

      SD card test

     

     

    This example shows how use the utility libraries on which the'

    SD library is based in order to get info about your SD card.

    Very useful for testing a card when you're not sure whether its working or not.

     

     

    The circuit:

      * SD card attached to SPI bus as follows:

    ** MOSI - pin 11 on Arduino Uno/Duemilanove/Diecimila

    ** MISO - pin 12 on Arduino Uno/Duemilanove/Diecimila

    ** CLK - pin 13 on Arduino Uno/Duemilanove/Diecimila

    ** CS - depends on your SD card shield or module.

      Pin 4 used here for consistency with other Arduino examples

     

     

     

     

    created  28 Mar 2011

    by Limor Fried

    modified 9 Apr 2012

    by Tom Igoe

    */

    // include the SD library:

    #include <SPI.h>

    #include <SD.h>

     

     

    // set up variables using the SD utility library functions:

    Sd2Card card;

    SdVolume volume;

    SdFile root;

     

     

    // change this to match your SD shield or module;

    // Arduino Ethernet shield: pin 4

    // Adafruit SD shields and modules: pin 10

    // Sparkfun SD shield: pin 8

    const int chipSelect = 4;

     

     

    void setup()

    {

      // Open serial communications and wait for port to open:

      Serial.begin(9600);

      while (!Serial) {

        ; // wait for serial port to connect. Needed for Leonardo only

      }

     

     

     

     

      Serial.print("\nInitializing SD card...");

      // On the Ethernet Shield, CS is pin 4. It's set as an output by default.

      // Note that even if it's not used as the CS pin, the hardware SS pin

      // (10 on most Arduino boards, 53 on the Mega) must be left as an output

      // or the SD library functions will not work

      pinMode(chipSelect, OUTPUT);

      pinMode(10,OUTPUT);

      pinMode(53, OUTPUT);     // change this to 53 on a mega

     

     

     

     

      // we'll use the initialization code from the utility libraries

      // since we're just testing if the card is working!

      if (!card.init(SPI_HALF_SPEED, chipSelect)) {

        Serial.println("initialization failed. Things to check:");

        Serial.println("* is a card is inserted?");

        Serial.println("* Is your wiring correct?");

        Serial.println("* did you change the chipSelect pin to match your shield or module?");

        return;

      } else {

        Serial.println("Wiring is correct and a card is present.");

      }

     

     

      // print the type of card

      Serial.print("\nCard type: ");

      switch (card.type()) {

        case SD_CARD_TYPE_SD1:

          Serial.println("SD1");

          break;

        case SD_CARD_TYPE_SD2:

          Serial.println("SD2");

          break;

        case SD_CARD_TYPE_SDHC:

          Serial.println("SDHC");

          break;

        default:

          Serial.println("Unknown");

      }

     

     

      // Now we will try to open the 'volume'/'partition' - it should be FAT16 or FAT32

      if (!volume.init(card)) {

        Serial.println("Could not find FAT16/FAT32 partition.\nMake sure you've formatted the card");

        return;

      }

     

     

     

     

      // print the type and size of the first FAT-type volume

      uint32_t volumesize;

      Serial.print("\nVolume type is FAT");

      Serial.println(volume.fatType(), DEC);

      Serial.println();

     

     

      volumesize = volume.blocksPerCluster();    // clusters are collections of blocks

      volumesize *= volume.clusterCount();       // we'll have a lot of clusters

      volumesize *= 512;                            // SD card blocks are always 512 bytes

      Serial.print("Volume size (bytes): ");

      Serial.println(volumesize);

      Serial.print("Volume size (Kbytes): ");

      volumesize /= 1024;

      Serial.println(volumesize);

      Serial.print("Volume size (Mbytes): ");

      volumesize /= 1024;

      Serial.println(volumesize);

     

     

     

     

      Serial.println("\nFiles found on the card (name, date and size in bytes): ");

      root.openRoot(volume);

     

     

      // list all files in the card with date and size

      root.ls(LS_R | LS_DATE | LS_SIZE);

    }

     

     

     

     

    void loop(void) {

     

     

    }

    this is the code...

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
element14 Community

element14 is the first online community specifically for engineers. Connect with your peers and get expert answers to your questions.

  • Members
  • Learn
  • Technologies
  • Challenges & Projects
  • Products
  • Store
  • About Us
  • Feedback & Support
  • FAQs
  • Terms of Use
  • Privacy Policy
  • Legal and Copyright Notices
  • Sitemap
  • Cookies

An Avnet Company © 2025 Premier Farnell Limited. All Rights Reserved.

Premier Farnell Ltd, registered in England and Wales (no 00876412), registered office: Farnell House, Forge Lane, Leeds LS12 2NE.

ICP 备案号 10220084.

Follow element14

  • X
  • Facebook
  • linkedin
  • YouTube