Converting xls files to xlsx using python

Question

I've got loads of 97-2003 excel xls files i wanna bulk convert to xlsx - i found this documentation but cant seem to get it to work..

https://pypi.org/project/xls2xlsx/

Have tried googling the errors and searching but no avail.

import os

from xls2xlsx import XLS2XLSX


directory = 'C:\\Users\\Python Scripts\\convertXLStoXLSX\\'


for filename in os.listdir(directory):

    if filename.endswith(".xls"):
        x2x = XLS2XLSX(filename)
        x2x.to_xlsx(filename)
        
    else:
        continue

I am getting the error message

ImportError: cannot import name 'GuessedAtParserWarning' from 'bs4' (C:\Users\wf5931\AppData\Local\Continuum\anaconda3\lib\site-packages\bs4_init_.py)

Does this answer your question? [how to convert xls to xlsx](https://stackoverflow.com/questions/9918646/how-to-convert-xls-to-xlsx) — chitown88, Jan 21 '21 at 11:46

score 0 · Accepted Answer · answered Jan 21 '21 at 11:43

0

use pandas

import pandas as pd
df = pd.read_excel("file.xls")
df.to_excel("file.xlsx")

answered Jan 21 '21 at 11:43

sepideh_ssh

196
2
8

THANKS! SO easy. All the best – ASG Jan 21 '21 at 11:52

score 0 · Answer 2 · answered Jan 21 '21 at 11:53

Just including my finished code for future use by others which uses pandas - worked almost instantly

import os import pandas as pd

directory = 'C:\\Users\\Documents\\Python Scripts\\convertXLStoXLSX\\'

for filename in os.listdir(directory):

    if filename.endswith(".xls"):
        df = pd.read_excel(filename)
        df.to_excel(filename + ".xlsx")

Converting xls files to xlsx using python

2 Answers2

Linked