Importing data from a local Excel file

Another popular format for storing tabular data is an Excel spreadsheet. In this recipe, we will import songs from a file of this format.

Getting ready

Let's start with the music app that we created in the previous recipe. To read Excel files, you will need to install the openpyxl package, as follows:

(env)$ pip install openpyxl==3.0.2

How to do it...

Follow these steps to create and use a management command that imports songs from a local XLSX file:

1. Create an XLSX file with the column names Artist, Title, and URL in the first...