Introduction

Parsing a CSV file means converting its contents into a structured format that a Node.js application can easily process. Instead of treating the file as plain text, parsing transforms each row into a JavaScript object, making it easier to access, filter, validate, and manipulate data.

Node.js applications commonly parse CSV files to import employee records, process customer information, read product catalogs, analyze reports, and perform bulk data operations.

For automation engineers, parsing CSV data is an essential skill because automation frameworks frequently use CSV files for data-driven testing. Parsing allows test scripts to read login credentials, API request data, search keywords, expected results, and other test inputs efficiently.

In this tutorial, you’ll learn how to parse CSV data using the csv-parser package.

What is CSV Parsing?

CSV parsing is the process of reading a CSV file and converting each row into a JavaScript object.

Example CSV file:

id,name,department
1,John,HR
2,Alice,IT
3,Bob,Finance

Parsed JavaScript objects:

[
    {
        id: "1",
        name: "John",
        department: "HR"
    },
    {
        id: "2",
        name: "Alice",
        department: "IT"
    },
    {
        id: "3",
        name: "Bob",
        department: "Finance"
    }
]

Why Parse CSV Data?

Parsing CSV files allows applications to:

Import employee records
Process customer information
Read product details
Validate CSV data
Perform data-driven testing
Analyze reports
Convert spreadsheet data into JavaScript objects

Installing the CSV Parser

Install the csv-parser package.

npm install csv-parser

Import Required Modules

const fs = require("fs");

const csv = require("csv-parser");

Sample CSV File

Suppose employees.csv contains:

id,name,department
1,John,HR
2,Alice,IT
3,Bob,Finance

Parse an Entire CSV File

const fs = require("fs");

const csv = require("csv-parser");

const employees = [];

fs.createReadStream("employees.csv")
    .pipe(csv())
    .on("data", (row) => {
        employees.push(row);
    })
    .on("end", () => {
        console.log(employees);
    });

Sample Output

[
  { id: '1', name: 'John', department: 'HR' },
  { id: '2', name: 'Alice', department: 'IT' },
  { id: '3', name: 'Bob', department: 'Finance' }
]

Example 2: Access Individual Values

const fs = require("fs");

const csv = require("csv-parser");

fs.createReadStream("employees.csv")
    .pipe(csv())
    .on("data", (row) => {
        console.log(row.name);
        console.log(row.department);
    });

Sample Output

John
HR
Alice
IT
Bob
Finance

Example 3: Filter Specific Records

Display only employees from the IT department.

const fs = require("fs");

const csv = require("csv-parser");

fs.createReadStream("employees.csv")
    .pipe(csv())
    .on("data", (row) => {
        if (row.department === "IT") {
            console.log(row);
        }
    });

Sample Output

{ id: '2', name: 'Alice', department: 'IT' }

Example 4: Count Records

const fs = require("fs");

const csv = require("csv-parser");

let total = 0;

fs.createReadStream("employees.csv")
    .pipe(csv())
    .on("data", () => {
        total++;
    })
    .on("end", () => {
        console.log(total);
    });

Sample Output

Real-World Example

Parse login credentials from a CSV file.

Suppose users.csv contains:

username,password
admin,admin123
john,password1
alice,password2

const fs = require("fs");

const csv = require("csv-parser");

const users = [];

fs.createReadStream("users.csv")
    .pipe(csv())
    .on("data", (row) => {
        users.push(row);
    })
    .on("end", () => {
        console.log(users);
    });

Sample Output

[
  { username: 'admin', password: 'admin123' },
  { username: 'john', password: 'password1' },
  { username: 'alice', password: 'password2' }
]

Automation Testing Example

Parsing CSV files is widely used in automation frameworks.

Playwright Example

Read login credentials.

const fs = require("fs");

const csv = require("csv-parser");

fs.createReadStream("users.csv")
    .pipe(csv())
    .on("data", (row) => {
        console.log(row.username);
    });

Selenium Example

Read search keywords.

const fs = require("fs");

const csv = require("csv-parser");

fs.createReadStream("keywords.csv")
    .pipe(csv())
    .on("data", (row) => {
        console.log(row.keyword);
    });

Cypress Example

Parse product information.

const fs = require("fs");

const csv = require("csv-parser");

fs.createReadStream("products.csv")
    .pipe(csv())
    .on("data", (row) => {
        console.log(row.productName);
    });

API Testing Example

Read request data.

const fs = require("fs");

const csv = require("csv-parser");

fs.createReadStream("requests.csv")
    .pipe(csv())
    .on("data", (row) => {
        console.log(row.userId);
    });

Data-Driven Testing Example

Read employee records.

const fs = require("fs");

const csv = require("csv-parser");

const employees = [];

fs.createReadStream("employees.csv")
    .pipe(csv())
    .on("data", (row) => {
        employees.push(row);
    })
    .on("end", () => {
        console.log(employees.length);
    });

Common Mistakes

Forgetting to Install the Package

Incorrect:

const csv = require("csv-parser");

without installing:

npm install csv-parser

Using Incorrect Header Names

Incorrect:

console.log(row.employeeName);

If the CSV header is:

name

Use:

console.log(row.name);

Forgetting the `end` Event

If you need the complete dataset, process it inside the end event after all rows have been read.

Best Practices

Store CSV files in a dedicated data or fixtures folder.
Keep column names short and meaningful.
Validate CSV data before processing it.
Handle stream errors properly.
Use the end event for operations that require all records.
Use CSV parsing for data-driven testing and bulk data processing.
Keep CSV files well-structured and free from unnecessary blank rows.

Conclusion

Parsing CSV data is an essential skill for Node.js developers and automation engineers. Using the csv-parser package, you can efficiently convert CSV files into JavaScript objects, making it easy to process, filter, and validate data.

For automation engineers, CSV parsing plays a key role in data-driven testing, allowing test scripts to use external datasets instead of hardcoded values.

Mastering CSV parsing helps you build scalable Node.js applications and maintainable automation frameworks.

Frequently Asked Questions (FAQs)