import os import os.path from docx import Document import pandas as pd for filename in os.listdir(): if filename.endswith(".docx"): print(filename) document = Document(filename) tables = [] for table in document.tables: df = [['' for i in range(len(table.columns))] for j in range(len(table.rows))] for i, row in enumerate(table.rows): for j, cell in enumerate(row.cells): if cell.text: cell.text = cell.text.strip() df[i][j] = cell.text tables.append(pd.DataFrame(df)) print(tables) for df in tables: df = df.T with pd.ExcelWriter("ProjectData.xlsx", engine="openpyxl", mode="a", if_sheet_exists="new") as writer: df.to_excel(writer, sheet_name="Sheet1", index = False, header= False) writer.save()