Export data from Django Admin to CSV

Viewing all your data from your django Admin is not ideal, Sometimes, you may want to export it to a spreedsheet format and perform data analytics or validation.

This is where the django-import-export library comes in handy. It provides an easy way to import and export data in various formats, such as CSV, xlsx and more.

The focus of this tutorial will be on exporting data, and adding export button on admin.

Getting started with Django import export

Start by installing django-import export

 pip install django-import-export 

Add it to installed apps

 # settings.py INSTALLED_APPS = [ ... 'import_export', ] 

Create a resource class inside your resource.py inside your app.

 class SampleResource(resources.ModelResource): class Meta: model = SampleModel fields = ('id', 'price', 'description') # optional, only specified fields gets exported, else all the fields  export_order = ('id', 'description', 'price') # optional, describes how order of export  

This class defines how the data will be imported and exported. You can also specify fields.

Now add it to admin so go to your admin.py

 from django.contrib import admin from import_export.admin import ExportMixin from .models import MyModel from .resources import MyModelResource @admin.register(MyModel) class MyModelAdmin(ExportMixin, admin.ModelAdmin): resource_class = MyModelResource 

That's it now you can export data directly from admin panel.

Choose the fields to export

You can also customize like specifying permissions and more. You can read this in their docs