Python - How to Merge all excel files in a folder. To merge all excel files in a folder, use the Glob module and the append() method. Let’s say the following are our excel files on the Desktop − ...