Search for a command to run...
How to install django-import-export in a Django project?
Experienced Full Stack Software Engineer with 4+ Years of experience, proficient in Django and React, with expertise in Python, JavaScript and Typescript, also an author of Dev.Junction Blogs & YouTube Channel, expert in Python/Django, Rest Framework, ReactJS/NextJS and TypeScript, currently based in Pune, India.
No comments yet. Be the first to comment.
Django provides a great Admin panel rich in features and highly customizable, in this series of blogs we will be introduced to all such possible customizations and more.
Adding WYSIWYG Rich Text Editor to Django Project
TypeScript, a Syntactic sugar on top of JavaScript
Are you tired of tightly coupled code and struggling to keep track of events in your Django application? Look no further! Our new e-book, "Django Signals Demystified: A Step-by-Step Guide to Event-Driven Programming" is here to help you master the po...
Maximizing Performance with select_related and prefetch_related in Django
2022 was not a good year financially because I did so many mistakes knowingly or unknowingly that, eventually, made me lose INR 500K over the course of just 6 months. So here are those mistakes which taught me about freelancing, finance management et...
Improve the user experience and efficiency of your React app with these simple techniques.
If you have been using Django admin, you might have realized that there is no way that you can import to export some data from the Django admin panel in supported formats such as CSV, JSON or an Excel Spreadsheet etc.
Well, without wasting any time, let’s directly jump into the implementation of how to add import-export functionality in Django Admin for any model.
We will use a popular third-party library called django-import-export in this blog, you can find this library on PyPI.
The simplest way to install django-import-export is to use pip.
pip install django-import-export
After the successful installation, you just need to add import_export package in your INSTALLED_APPS list of settings.py file.
# settings.py
...
INSTALLED_APPS = [
...
'import_export',
]
...
django-import-export comes with multiple admin classes and mixins to make it easy for you to integrate with any Django model.
If you want to integrate both Import and Export together in a model admin, you can import the ImportExportModelAdmin and register your model admin, here is the code:
# app_name/admin.py
from app_name.models import Book
from import_export.admin import ImportExportModelAdmin
@admin.register(Book)
class BookAdmin(ImportExportModelAdmin):
...
If you are looking to only integrate the Import or maybe only the export feature in your model admin, you can use the ImportMixin or ExportMixin respectively. But keep in mind that these mixins are combined with admin.ModelAdmin.
For only Import:
# app_name/admin.py
from django.contrib import admin
from app_name.models import Book
from import_export.admin import ImportMixin
@admin.register(Book)
class BookAdmin(ImportMixin, admin.ModelAdmin):
...
For only Export:
# app_name/admin.py
from django.contrib import admin
from app_name.models import Book
from import_export.admin import ExportMixin
@admin.register(Book)
class BookAdmin(ExportMixin, admin.ModelAdmin):
...
If you want to go into the depth of the django-import-export library, you can visit the Official GitHub repository or Official documentation.
Any thoughts? Write it down in the comments.
For more such crispy blogs daily, follow Dev.Junction, subscribe to our newsletter and get notified.
LinkedIn: https://www.linkedin.com/in/mnamegaurav/
YouTube: https://www.youtube.com/devjunction
Website: https://gaurav.devjunction.in/
GitHub: https://github.com/mnamegaurav
Instagram: https://www.instagram.com/mnamegaurav/
Twitter: https://twitter.com/mnamegaurav