I'm a newbie wanting to make a system to measure atmospheric data at intervals and record it in a spreadsheet. How do I get the data from my device to CSV?

This page summarizes the projects mentioned and recommended in the original post on /r/arduino

Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
  • ESP-Google-Sheet-Client

    Arduino Google Sheet REST client library for Arduino

  • If you still want to continue, I reccomend something like this

  • Google-Sheets-Logging

    Log data from an ESP8266 device directly to Google Sheets without a third party service. Log sensor data, send data by pressing a button, and receive data from a Google spreadsheet. (NodeMCU, Wemos D1 mini, Adafruit Feather HUZZAH, etc)

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
  • Adafruit_APDS9960

    Arduino drivers for APDS9960 gesture sensor

  • Write a program that can measure lux. I am currently using an Adafruit APDS9960 for one project, but am measuring individual red, green, and blue intensities rather than lux. Adafruit has a how-to guide for this, and for almost everything they sell. The demo program that Adafruit provides with that sensor does this for you. You could literally use their demo program without any modification for this step.

  • Adafruit_SHT4X

    Arduino driver for Adafruit SHT4X temperature / humidity breakout

  • Add into the program (from step #1) the ability to measure temperature and humidity. I have about 4 Adafruit SHT40's around my house. The how-to guide for this sensor is here. You will basically be copying code from here, into your first program. This would be good training for identifying

  • Adafruit_Seesaw

    Arduino library driver for seesaw multi-use chip

  • I recommend you also track soil moisture levels. This is easy to do with a capacitive moisture sensor. Here is their how-to guide, and here is the demo code on GitHub.

  • SparkFun_MLX90640_Arduino_Example

    Controlling and reading from the MLX90640 IR array thermal imaging sensor

  • Other companies do this as well, like Sparkfun, DFRobot, Wemos/Lolin, etc. I feel that Adafruit goes the extra mile. And that has won my loyalty.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts