How To Fix: ModuleNotFoundError: No module named ‘xlsxwriter’ in Python

You import the module xlsxwriter into your Python program. Unfortunately, a message error comes up: ModuleNotFoundError: No module named 'xlsxwriter'. We will explain the cause and teach you how to fix this problem in this article. Read now!

Cause of ModuleNotFoundError: No module named ‘xlsxwriter’ 

You want to take advantage of the xlsxwriter module. But when you try importing it to your Python, the program stops working and delivers an error message: ModuleNotFoundError: No module named 'xlsxwriter'.

Here is the code sample that leads to the issue:

import xlsxwriter

The Python program will give you an error message like this:

    import xlsxwriter
ModuleNotFoundError: No module named 'xlsxwriter'

The syntax is completely correct. There is nothing wrong with your command. But the problem is that you have not installed the xlsxwriter module in your Python.

Remember that Python does not have the built-in module xlsxwriter. Open your computer to install this module and the ModuleNotFoundError will vanish.

How to solve ModuleNotFoundError: No module named ‘xlsxwriter’ 

We have determined the cause of ModuleNotFoundError: No module named 'xlsxwriter'. As recommended above, we will need to install it into Python. Here are all the steps to do this work:

Step 1: Open Command Prompt

The Command Prompt is where you install packages on your computer. Open the search bar and search the term: Command Prompt. After that, open this application.

Another quick way is to type Windows + R at the same time. You enter cmd and tap on OK. The Command Prompt will show up.

Step 2: Install the xlsxwriter module into Python

The pip command allows you to install packages to your computer, including xlsxwriter.

You have to input the following command in the Command Prompt:

python -m pip install xlsxwriter

The xlsxwriter will be downloaded and installed on your computer.

If you fail to install xlsxwriter due to  a Permission Error, use 1 of the 2 following commands to solve the problem:

Install xlsxwriter with superuser’s privileges:

python sudo -H pip install xlsxwriter

Install xlsxwriter in the user folder:

python -m pip install xlsxwriter --user

Step 3: Import xlsxwriter into your Python program

Remember that you can check the version of xlsxwriter in your Python with the command: pip show:

python -m pip show xlsxwriter

The result will look like this:

Name: XlsxWriter
Version: 3.0.3
Summary: A Python module for creating Excel XLSX files.

As the installation is completed, you can import xlsxwriter to your Python program. There will be no more ModuleNotFoundError.

Here is the syntax for importing xlsxwriter in Python:

import xlsxwriter

The importing will be successful. You will then be able to take advantage of the xlsxwriter module to create your Python program.

Here is the code sample using xlsxwriter:

import xlsxwriter

# Create a new Excel 
fileworkbook = xlsxwriter.Workbook('learnshareit.xlsx')
worksheet = workbook.add_worksheet()

# Close the excel file
workbook.close()

There will be no output, as the xlsxwriter module helps you create an Excel file and work on it right from your Python program.

Summary

In conclusion, the ModuleNotFoundError: No module named 'xlsxwriter' occurs when you import the xlsxwriter module while not having it installed on your computer. The solution is easy as you just need to download and install it in your Python.

William Nguyen

I am William Nguyen and currently work as a software developer. I am highly interested in programming, especially in Python, C++, Html, Css, and Javascript. I’ve worked on numerous software development projects throughout the years. I am eager to share my knowledge with others that enjoy programming!