# API Tests - Data from CSV files

When you wish to run a flow several times using different parameters values for each run - just use a CSV file to list the parameters values and on run time the flow will run as the number of rows in the CSV, each run will get it’s own row values from the CSV file.

Find the "Import CSV" in the flow upper toolbar:

Once the CSV file has been uploaded, you will be able to go over the different parameters and their values in a preview window, when you're done, just click "Upload". (Attention: in cases where the CSV file contains empty cells, Loadmill will not prevent its uploading).

![](/files/7ggQUFJfF5gNrJStr01E)

When a flow is using a CSV file, there will be an indication "Using CSV".

![](/files/-Ml56d0V3vIunv9asTMt)

In order to remove a CSV file from the test, simply click on the "Using CSV" button, and click on the "Delete" button.

![](https://lh6.googleusercontent.com/r6nNQ0ReXJEtZ6M7yzVm1p0wCOXflhs68gni7r0phAfLe7KpXEQKJ8QMgzmbBSAxcUM4inb5LrnwCZa6FR4jxhf2vErU_suQt3i39HdRSn_RJ0M24QnWV3XMpuTJuA6oVPc-w4DH)

**Iteration for each CSV value**

When running a test suite using a CSV file, the flow using the CSV will run for a number of iterations as the number of values in the CSV, **each iteration with the next values defined in the CSV file**.

![](https://lh4.googleusercontent.com/8SJI1rHES86UJzwsJ9m3l2ck71TPi-HaxFCEQ4n5ohOCndnxdm8YHmvHa5tFHxyBtkttCguAV0mAdr9rDGwOxCrsuCpJ8LsVYuezE46YfhIqsLG4o0FzS9dOr2sftDS7AqaixDzu)

### Execution Order

When using a parameter defined in a CSV file, any parameter defined in the "Test Suite Parameters" tab **will be overridden by the value given from the CSV file**.

The order of parameter value assignment is:

1. Value as in **Test Suite Parameters tab**. For example:

![](/files/-MN-2xe7PzvhBCWI_5wJ)

2\. Value as they appear in the **CSV** file. For example:

![](/files/-MN-3Lm08Tu9a4snnsG3)

3\. Value as defined in the **Extractions - Set Parameters** section of specific request (This will override all of the above). For example:

![](/files/-Ml56yE7fMFgDnUkwOnH)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.loadmill.com/general/api-testing1/test-suite-editor/api-tests-data-from-csv-files.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.