How To Merge Multiple Excel Files !full! — Fully Tested

df_list = [] for file in files: df = pd.read_excel(file) df_list.append(df)

Sub MergeAllWorkbooks() Dim FolderPath As String Dim Filename As String Dim wb As Workbook Dim MainWB As Workbook Dim LastRow As Long Set MainWB = ThisWorkbook FolderPath = "C:\YourFolderPath\" ' Change this Filename = Dir(FolderPath & "*.xlsx") how to merge multiple excel files

import pandas as pd import glob path = "C:\YourFolder\" files = glob.glob(path + "*.xlsx") df_list = [] for file in files: df = pd