how to upload and read csv file in django using csv.DictReader?

Question

I am reading csv file through upload and trying to store all values in a list ``` def upload(request): paramFile = request.FILES['file'].read() data = csv.DictReader(paramFile) list1 = [] for row in data: list1.append(row) print list1 ``` file.csv ``` 12345,abcdef ``` output ``` [{'1': '', None: ['']}, {'1': '2'}] ``` I want to append all values in `list1`

Accepted Answer

You have two problems:

You are passing a string to the constructor of `DictReader`. You must pass an iterable object that gives the individual lines in the input (a string is iterable, but will give each character one at a time). Luckily, an `UploadedFile` object (like those in the `FILES` dictionary) are already file-like objects that support iteration, so just do this:

```
data = csv.DictReader(request.FILES['file'])
```

Your input data only has one line. `DictReader` will use that line for the column "headers", which will become the key in the resulting dictionaries. You will then have no data left! It looks like you don't want a `DictReader`, just a regualar `reader`:

```
data = csv.reader(request.FILES['file'])
```

how to upload and read csv file in django using csv.DictReader?

Solution

Problem