# Run a runner from a CSV file

**URL:** <https://community.postman.com/t/run-a-runner-from-a-csv-file/43419>\
**Category:** Help Hub\
**Created:** [January 31, 2023, 9:47pm UTC](https://community.postman.com/t/run-a-runner-from-a-csv-file/43419 "2023-01-31T21:47:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![francisacobahena](https://avatars.discourse-cdn.com/v4/letter/f/bbce88/32.png) [@francisacobahena](https://community.postman.com/u/francisacobahena)\
**Post date:** [January 31, 2023, 9:47pm UTC](https://community.postman.com/t/run-a-runner-from-a-csv-file/43419/1 "2023-01-31T21:47:02Z")

</div>

Hello, good afternoon. I’m busy solving this problem that occurred to me when I run the test, I get no past for my “profileId” data  
", “businessProfileId”,“businessProfileName”, “businessProfileDescription” I am trying to take the data from an excel

 ![Screenshot_3](https://us1.discourse-cdn.com/getpostman/original/3X/5/6/56baeb3aae3fb9e28623db4455883799449ec7e7.png)

 ![Screenshot_4](https://us1.discourse-cdn.com/getpostman/original/3X/4/5/457dec17858fa3c8952c4139844681e20363b7b4.png)

 ![Screenshot_5](https://us1.discourse-cdn.com/getpostman/original/3X/9/2/920d3c1884ab5bbae41a23d776358605cd137256.png)

---

<div class="post-metadata">

**Author:** ![michaelderekjones](https://sea2.discourse-cdn.com/getpostman/user_avatar/community.postman.com/michaelderekjones/32/14819_2.png) [@michaelderekjones](https://community.postman.com/u/michaelderekjones)\
**Post date:** [January 31, 2023, 11:10pm UTC](https://community.postman.com/t/run-a-runner-from-a-csv-file/43419/2 "2023-01-31T23:10:08Z")

</div>

I would recommend reading the instructions again.

> **[Using CSV and JSON Data Files in the Postman Collection Runner | Postman Blog](https://blog.postman.com/using-csv-and-json-files-in-the-postman-collection-runner/)**
>
> Update: If you want to dip deeper into the Postman Collection Runner, check out this newer post about Postman’s Collection Runner. Postman’s...

I’m assuming that you mean a CSV file in Excel, not an .xls file.

It looks like you are trying to retrieve the csv values using pm.variables.get which is not how its done. I’m assuming that you don’t actually have a local variable called profileId set, so its correctly returning “undefined”.

It should be,

```auto
var profileID = data.profileID;

```

And so forth.

On a side note, I do not recommend checking for all of those elements in one test. Break it up into smaller tests.

If the first pm.expect line fails, then the others won’t be run and you won’t get feedback on those tests.

Second tip, if you only have one element in your response, consider parsing directly to that element.

```auto
let response = pm.response.json()[0];

```

Final tip is to use the console.log. Log the variables you are setting to ensure that they are returning data.