# import packages needed import glob import tabula # transform the pdfs into excel files for filepath in glob.iglob('C:/Users/myfolderwithpdfs/*.pdf'): tabula.convert_into(filepath, output_format="xlsx")