Exporting models data in Django

   In this article, we will see how to export model data in .csv format. Sometimes, you might need to export your model data in different formats such as .csv or json or .xlsx for further work or reporting. You can do this by making some sort of script but I have a better way to do that.

Create a Django project and add an App. Setup urls and do some basic stuff like adding app in INSTALLED_APPS.

Create a model. Here, we don't have much to do with views.py, urls.py or any html file.

We only have work with settings.py, admin.py, models.py and admin urlpoint.

Example

Install the package −

pip install django-import-export

In settings.py −

INSTALLED_APPS += ['import_export']

Add this library as an app in your project.

Create a model −

class StudentData(models.Model):
   name=models.CharField(max_length=100)
   standard=models.CharField(max_length=100)
   section=models.CharField(max_length=100)

Here, we created a dummy model for testing

In admin.py −

from django.contrib import admin
from .models import StudentData
from import_export import resources
from import_export.admin import ImportExportModelAdmin
   class StudentResource(resources.ModelResource):
      class Meta:
         model = StudentData

class StudentAdmin(ImportExportModelAdmin):
   resource_class = StudentResource

admin.site.register(StudentData,StudentAdmin)

Create an admin class for this ImportExportModel admin and register it to show it on the admin panel.

Output

Now, go to http://127.0.0.1/admin

Now, you can export data after clicking the 'Export' button.

Ath Tripathi

Published on 25-Aug-2021 13:14:57

• Related Questions & Answers
• Importing data into models in Django
• Implementing models reversion in Django
• Adding JSON field in Django models
• Making a Pickle field in Django models
• Evolution of Data Models
• Object based Data Models
• History of Data Models and Databases
• Django model data to JSON data in 2 lines
• Exporting data from SAP system to an Excel Report
• What are the types of data mining models?
• How to implement django-material in your Django project?
• Importing / Exporting CSV file in PowerShell
• Early Database Models
• Multi-Threading Models
• Reliability Growth Models