SDET Unicorns

Postman Data Driven Testing with CSV file

Table of Content

Data-driven testing is a powerful technique for automating the testing process with Postman. By using a CSV data file, you can run the same test multiple times on different datasets, saving time and reducing the amount of code needed. In this tutorial, I will show you how to import a CSV file into Postman and use it for data-driven testing.


  • Basic knowledge of Postman and JavaScript
  • A CSV data file as a source for your test

Prepare your CSV data file

The first step is to prepare your CSV data file. Make sure the column names match the variables you will use in your tests. In this case, we have columns for User ID, Title, and Body. Each row should contain data for one test case.

csv file

Create a new request and set up your test

To create a new request in Postman, click on the “New” button and select “Request.” In the request, you can set up your test by using variables from the CSV data file. For example, you can use the useridtitle, and body variables in the request body to send different data for each test case.

Postman Test

Create a collection

To organize your requests, add the request to a collection in Postman and then click on ‘Run Collection’ button.

Import CSV Data file

To use the data from your CSV file, import it into the Postman collection by clicking on ‘Select File’ button. This will map the data from the CSV file into a table. Make sure the mapping is correct before proceeding.

Preview data

Run the collection

With the collection set up and the CSV data imported, you can now run the collection by clicking on the ‘Run Collection’ button. This will automatically run each request in the collection, using the corresponding data from the CSV file for each test.

CSV Test Run

Check out the video below for a detailed explanation

By using a CSV data file in Postman, you can easily perform data-driven testing and automate your testing process. This technique can save you time and effort by allowing you to reuse the same test with different data sets.

👩🏻‍💻 It’s time to advance your career by joining the SDET-U Academy today 👇🏻
Join Academy

📧 Subscribe to my mailing list to get access to more content like this as well as be part of amazing free giveaways.

👍 You can follow my content here as well –

Thanks for reading!

My Resources

Thrive Suite: The all-in-one WordPress theme I used to create my blog.
Jasper AI: My favorite AI writing tool.
Surfer SEO:  A tool to help you rank your content on the first page of Google.

Write Content Faster


Write blog posts that rank for affiliate terms!

Join our mailing list

Unlock the Secrets to Becoming a SDET Pro in the Industry!

Stay ahead of the curve! Join our mailing list for exclusive insights, tips, and the latest industry updates delivered straight to your inbox

Table of Content

Related Post

Functional vs Regression Testing

Functional Testing vs Regression Testing: Main Differences

Testing has increasingly become a requirement in the software development lifecycle in recent years. The realization that development is no longer a focal point for stakeholders but saving costs by catching defects early in their application makes it necessary to learn different testing types.

Read More »