quick-and-dirty script to merge multiple Excel files into a single CSV

merge-xlsx-to-csv.py

import os
from pathlib import Path

import pandas as pd

OUTFILE = 'merged.csv'
ENGINE = 'openpyxl'

cwd = os.getcwd()
p = Path(cwd)
xlsx_files = list(p.glob('*.xlsx'))

for idx, val in enumerate(xlsx_files):
    df = pd.read_excel(val, engine=ENGINE)
    if idx == 0:
        df.to_csv(OUTFILE, index=False)
    else:
        df.to_csv(OUTFILE, index=False, mode='a', header=False)