How to import a CSV file into Django

Recently I downloaded a US zip code data file in comma separated (CSV) format. Below are the steps and python script that I used to import that data into a django model for my site Wantbox.com.

The Steps to Import CSV Data into Django:

1. Create your django model (mine is called “ZipCode”, see below).
2. Create a python script called “load_data.py” with your correct django project and directory info (see mine below).
3. Put the CSV file and “load_data.py” script in the same directory.
4. From that directory run: python ./load_data.py”

That’s it. For a CSV file with about 42,000 rows this import took about 15 seconds. You can verify that the data loaded correctly by checking your django admin.