CSV format data logging in Arduino - Step-by-Step Execution

Concept Flow - CSV format data logging

Start Program

↓

Initialize Sensors

↓

Read Sensor Data

↓

Format Data as CSV

↓

Write Data to Storage

↓

Repeat at Interval

↓

Stop or Continue Loop

The program starts, reads sensor data, formats it as CSV, writes it to storage, and repeats this cycle.

Execution Sample

Arduino

void loop() {
  int temp = analogRead(A0);
  int hum = analogRead(A1);
  Serial.print(temp);
  Serial.print(",");
  Serial.println(hum);
  delay(1000);
}

Reads two sensor values, prints them as CSV to serial every second.

Execution Table

Step	Action	temp Value	hum Value	CSV Output	Delay
1	Read temp sensor	523
2	Read hum sensor	523	487
3	Print temp	523	487	523
4	Print comma	523	487	523,
5	Print hum with newline	523	487	523,487
6	Wait 1000 ms	523	487	523,487	1000 ms
7	Repeat loop

💡 Loop runs continuously; no exit unless powered off.

Variable Tracker

Variable	Start	After Step 1	After Step 2	After Step 5	Final
temp	undefined	523	523	523	523
hum	undefined	undefined	487	487	487
CSV Output	""	""	""	523,487	523,487

Key Moments - 3 Insights

Why do we print a comma between sensor values?

The comma separates values in CSV format, so each sensor reading is a separate column. See execution_table steps 3 and 4.

Why use println for the last value instead of print?

println adds a newline, ending the CSV row. This ensures each data set is on its own line. See execution_table step 5.

What happens if delay is removed?

Without delay, data prints too fast, making it hard to read or store properly. See execution_table step 6 for timing.

Visual Quiz - 3 Questions

Look at the execution_table, what is the CSV output after step 5?

A 523;487

B 523487

C 523,487

D 523 487

💡 Hint

Check the CSV Output column at step 5 in the execution_table.

At which step is the humidity sensor value read?

A Step 2

B Step 3

C Step 1

D Step 4

💡 Hint

Look at the 'Action' column for sensor reads in the execution_table.

If the delay(1000) is changed to delay(500), what happens to the data logging speed?

A Data logs half as fast

B Data logs twice as fast

C Data logging stops

D No change in speed

💡 Hint

Refer to the Delay column in execution_table step 6 and think about timing.

Concept Snapshot

CSV Data Logging in Arduino:
- Read sensor values (e.g., analogRead)
- Print values separated by commas
- End each line with println for new row
- Use delay to control logging frequency
- Output is easy to import into spreadsheets

Full Transcript

This lesson shows how Arduino reads sensor data and logs it in CSV format. The program reads temperature and humidity sensors, prints their values separated by a comma, and ends the line with a newline character. This creates rows of data that can be saved or viewed in serial monitor. A delay controls how often data is logged. The execution table traces each step: reading sensors, printing values, and waiting. Key points include why commas separate values and why println ends the line. The quiz tests understanding of output format, sensor reading steps, and timing effects.

Practice

1. What is the main purpose of using CSV format in Arduino data logging?

easy

A. To store data in rows and columns separated by commas

B. To execute Arduino code faster

C. To connect Arduino to the internet

D. To power the Arduino board

Solution

1. Step 1: Understand CSV format basics

   CSV stands for Comma-Separated Values, storing data in rows and columns separated by commas.

2. Step 2: Relate CSV to Arduino data logging

   Using CSV format helps organize sensor or variable data clearly for later analysis.

3. Final Answer:

   To store data in rows and columns separated by commas -> Option A

4. Quick Check:

   CSV = comma-separated rows and columns [OK]

Hint: CSV means comma-separated values for easy data reading [OK]

Common Mistakes:

• Confusing CSV with code execution speed
• Thinking CSV connects Arduino to internet
• Mixing CSV with hardware power functions

2. Which Arduino code snippet correctly prints sensor values in CSV format for temperature and humidity?

easy

A. Serial.println(temperature + "," + humidity);

B. Serial.print(temperature); Serial.print(","); Serial.println(humidity);

C. Serial.print(temperature + humidity); Serial.println(",");

D. Serial.print(temperature); Serial.println(humidity);

Solution

1. Step 1: Check correct CSV printing syntax

   CSV requires values separated by commas on the same line, so use Serial.print for first value, then print comma, then Serial.println for last value.

2. Step 2: Analyze each option

   Serial.print(temperature); Serial.print(","); Serial.println(humidity); prints temperature, then comma, then humidity with newline. Serial.println(temperature + "," + humidity); tries to add strings incorrectly. Serial.print(temperature + humidity); Serial.println(","); adds numbers before printing comma. Serial.print(temperature); Serial.println(humidity); prints values on separate lines without comma.

3. Final Answer:

   Serial.print(temperature); Serial.print(","); Serial.println(humidity); -> Option B

4. Quick Check:

   Use Serial.print + comma + Serial.println for CSV line [OK]

Hint: Use Serial.print for commas, Serial.println ends the CSV line [OK]

Common Mistakes:

• Using Serial.println for all values causing new lines
• Adding numbers instead of printing strings
• Missing commas between values

3. Given the code:

float temp = 25.5;
int humidity = 60;
Serial.print(temp);
Serial.print(",");
Serial.println(humidity);

What will be the exact output on the serial monitor?

medium

A. 25.5 60

B. 25.560

C. 25.5
60

D. 25.5,60

Solution

1. Step 1: Understand Serial.print and Serial.println behavior

   Serial.print outputs text without newline; Serial.println outputs text and adds newline at end.

2. Step 2: Trace the output line

   First prints 25.5, then prints comma, then prints 60 with newline. So output is '25.5,60' on one line.

3. Final Answer:

   25.5,60 -> Option D

4. Quick Check:

   Serial.print + comma + Serial.println = '25.5,60' [OK]

Hint: Serial.println adds newline; Serial.print does not [OK]

Common Mistakes:

• Assuming Serial.print adds newline
• Confusing space with comma separator
• Expecting separate lines for values

4. Identify the error in this Arduino code snippet for CSV logging:

Serial.println(temperature);
Serial.print(",");
Serial.println(humidity);

medium

A. Missing semicolon after Serial.print

B. Comma should be replaced with semicolon

C. Using Serial.println before comma causes wrong CSV format

D. Variables temperature and humidity are not declared

Solution

1. Step 1: Analyze Serial.println and Serial.print order

   Serial.println adds newline after printing, so printing temperature with println ends line before comma.

2. Step 2: Understand CSV format requirement

   CSV needs values separated by commas on the same line. Printing newline before comma breaks CSV format.

3. Final Answer:

   Using Serial.println before comma causes wrong CSV format -> Option C

4. Quick Check:

   Print commas with Serial.print, println ends line [OK]

Hint: Print commas with Serial.print, println ends the line [OK]

Common Mistakes:

• Using println before printing commas
• Confusing semicolon with comma separator
• Assuming variables must be declared in snippet

5. You want to log temperature, humidity, and light sensor values in CSV format every second. Which code snippet correctly logs all three values on one line with commas and a newline at the end?

hard

A. Serial.print(temp); Serial.print(","); Serial.print(humidity); Serial.print(","); Serial.println(light);

B. Serial.println(temp + "," + humidity + "," + light);

C. Serial.print(temp + humidity + light); Serial.println(",");

D. Serial.println(temp); Serial.println(humidity); Serial.println(light);

Solution

1. Step 1: Understand CSV line construction

   Each value must be printed separated by commas on the same line, ending with a newline.

2. Step 2: Evaluate each option

   Serial.print(temp); Serial.print(","); Serial.print(humidity); Serial.print(","); Serial.println(light); prints temp, comma, humidity, comma, then light with newline correctly. Serial.println(temp + "," + humidity + "," + light); tries to add strings incorrectly (Arduino doesn't support string addition like that). Serial.print(temp + humidity + light); Serial.println(","); adds numbers before printing comma, wrong format. Serial.println(temp); Serial.println(humidity); Serial.println(light); prints each value on separate lines without commas.

3. Final Answer:

   Serial.print(temp); Serial.print(","); Serial.print(humidity); Serial.print(","); Serial.println(light); -> Option A

4. Quick Check:

   Use Serial.print for commas, Serial.println ends line [OK]

Hint: Print each value with Serial.print and commas, end with Serial.println [OK]

Common Mistakes:

• Trying to add strings with + operator
• Printing values on separate lines without commas
• Adding numbers before printing commas