Display the uploaded CSV file in Django template

Here, is the python django code to display the uploaded csv file in django template.

Gurusabarish

·

Follow

1 min read

·

Sep 5, 2021

--

Listen

Share

• Django template code to upload a csv file. Paste the below code in home.html

<form method="POST" enctype="multipart/form-data">
  {% csrf_token %}
  <input name="file" accept=".csv" type="file" id="csv" />
  <button type="submit">upload</button>
</form>
<table class="table">
  <tbody>
    {% for i in header %}
    <tr>
      <th scope="row">{{ i }}</th>
      {% for j in data|get_item:i %}
      <td>{{j}}</td>
      {% endfor %}
    </tr>
    {% endfor %}
  </tbody>
</table>

• Backend code to get and display the uploaded csv file. Paste the below code in views.py

def home(req):
    if req.POST:
        context = {}
        reader=csv.DictReader(decode_utf8(req.FILES['file']))
        for row in reader:
            header = list(row.keys())
            break
        data = {}
        for row in reader:
            for i in header:
                values = []
                values.append(row.get(i))
                if i not in data:
                    data[i] = values
                data[i].extend(values)
        context['header'] = header
        context['data'] = data        return render(req, 'home.html', context)
    return(render(req, 'home.html'))

• Paste the below code in url.py

from django.urls import path
from . import viewsurlpatterns = [
    path('', views.home, name="home"),
]