title: Pandas read_excel() fails on importing xlrd
body: <p>I would like to convert multiple <code>.xls</code> files stored in my folder to <code>.csv</code> format. Here is what I've got so far:</p>
  
  <pre><code>import glob
  import os
  import csv
  import pandas as pd
  
  path = r'C:\Users\XXX\Desktop\Test'
  full_path = os.path.join(path, '*.xls')
  
      for filename in glob.glob(full_path):
  
          name_xls = os.path.basename(filename)
          name_csv = name_xls.replace('.xls', '.csv')
  
          data_xls = pd.read_excel(name_xls)
          data_xls.to_csv(name_csv, sep=';', encoding='ASCI')
  </code></pre>
  
  <p>Even that I downloaded <em>pandas and xlrd</em> libraries, I get the following error:</p>
  
  <pre><code>Traceback (most recent call last):   File
  "C:\Users\XXX\.thonny\BundledPython36\lib\site-packages\pandas\io\excel.py",
  line 261, in __init__
    **import xlrd ModuleNotFoundError: No module named 'xlrd'**
  
  During handling of the above exception, another exception occurred:
  
  Traceback (most recent call last):   File
  "C:\Users\XXX\Desktop\coverage_code_0\coverage_code_0.py", line
  16, in &lt;module&gt;
    data_xls = pd.read_excel(name_xls)   File  
  C:\Users\XXX\.thonny\BundledPython36\lib\site-packages\pandas\util\_decorators.py",
  line 118, in wrapper
    return func(*args, **kwargs)   File "C:\Users\XXX\.thonny\BundledPython36\lib\site-packages\pandas\io\excel.py",
  line 230, in read_excel
    io = ExcelFile(io, engine=engine)   File "C:\Users\XXX\.thonny\BundledPython36\lib\site-packages\pandas\io\excel.py",
  line 263, in __init__
    raise ImportError(err_msg) ImportError: Install xlrd &gt;= 0.9.0 for Excel support
  </code></pre>
  
  <p><code>import xlrd</code> doesn't work, when I include that compiler says: </p>
  
  <pre><code>No module named 'xlrd'
  </code></pre>
  
  <p>I believe that there is a mistake in my code but I don't know where. Any thoughts?</p>