Python Program to extract data from multiple Excel Files

Ajay Anand • November 22, 2023

Ajay Anand

About

I am a Civil Engineer by education, a Highway Designer by profession, and a Coder by passion. After working on highway projects across India since 2007, I left my job in 2018 to start xlncad.com, sharing Excel and AutoCAD tips. I’ve conducted Excel workshops, including one for the United Nations Environment Program (UNEP) in Geneva, and was honored with the Microsoft MVP Award in 2020 for my contributions to the Excel community. I’d love to hear from you! Share your feedback in the comments. Thanks for visiting my channel—have a great day! Ajay Anand

Python Program to extract data from multiple Excel Files

Ajay Anand

About

Latest Posts

How to create a Simple Dashboard Report in Microsoft Excel

You May Also Like

Upgrade Your Galaxy Experience

Wireless Charger for Samsung - NANAMI 3 in 1 Charging Station for Multiple Devices,Fast Charger Stand Dock for Galaxy S25 S24 S23 Ultra S22 S21 S20 Z Flip Fold,Galaxy Watch 5/5 Pro/4/3,Galaxy Buds Pro

45W Super Fast Charger USBC Charger, 2Pack 10FT Samsung Charger Fast Charging Cord Cable&amp; Samsung Type C Charger Block for Galaxy S25 S24 S23 S22 S21 Ultra/Plus, Tab S10 S9 S8 S7,iPad,Android Phone

Wireless Charger for Samsung - NANAMI 3 in 1 Charging Station for Multiple Devices,Fast Charger Stand Dock for Galaxy S25 S24 S23 Ultra S22 S21 S20 Z Flip Fold,Galaxy Watch 5/5 Pro/4/3,Galaxy Buds Pro

Wireless Earbuds for Samsung S23 S24 S25 Ultra S21 S22 A35 A15 A14 iPhone 16 Pro 15 True Bluetooth 5.4 Headphones Ear Buds Noise Canceling in Ear Earphones,Deep Bass HiFi Stereo,Sweat Resistant,Mic

BASESAILOR iPhone 16 15 Pro Max Charger Cord,USB to USB C Cable 6.6FT/2Pack,Type C Charging Power Cord for Apple iPad 10,Samsung Galaxy AI S25 S24 S23 S22 S20 Plus Ultra Flip,A52 A53 A54,Google Pixel

Wireless Charger for Samsung - NANAMI 3 in 1 Charging Station for Multiple Devices,Fast Charger Stand Dock for Galaxy S25 S24 S23 Ultra S22 S21 S20 Z Flip Fold,Galaxy Watch 5/5 Pro/4/3,Galaxy Buds Pro

Wireless Charger for Samsung Devices, Wireless Charging Station for Galaxy S25 Ultra/S25+/S25/S24 Ultra/Z Fold/Z Flip/S23/S22/S21, for Galaxy Watch7/Ultra/6/6 Classic/5 Pro/5/4, Galaxy Buds3 Pro

Wireless Charger for Samsung - NANAMI 3 in 1 Charging Station for Multiple Devices,Fast Charger Stand Dock for Galaxy S25 S24 S23 Ultra S22 S21 S20 Z Flip Fold,Galaxy Watch 5/5 Pro/4/3,Galaxy Buds Pro

Super Fast Charger Type C, 2 Pack 25W USB C Wall Charger Fast Charging for Samsung Galaxy S25 Edge/S25 Ultra/S25/S25+/S24/S24+/S24 Ultra/S23/S22/S21 /S20/Note 20/10 with 10FT Long Type C Charging Cord

Galaxy S24 S25 USB C Charging Block 25W PD Super Fast Charger Type C Wall Plug Adapter Quick Charge for Samsung Galaxy S25/S24/S23/S22/S21/S20/Z Fold 3/4/5/Note20/iPhone 15/16/iPad/Tablet/Watch-1Pack

INIU 45W Power Bank, Ultra Small 10000mAh Portable Charger, USB C in&amp;Out Fast Charging Battery Pack, Travel External Phone Powerbank Compatible with iPhone 16 15 Samsung S25 S24 Google Pixel iPad etc

Vihibii for Samsung Galaxy S25 Ultra Case with Card Holder (4 Cards), RFID Blocking &amp; Slide Camera Cover, Military Grade Drop Protection, Rugged Hard Back &amp; Silicone Edge Wallet Case, 6.9&quot; 2025, Black

YINLAI for Samsung Galaxy S25 Case Liquid Silicone with Ring Holder Stand Slim Soft Rubber Cover Shockproof Protective Phone Case for Samsung Galaxy S25 5G 6.2 Inch, Blue

Vanjua for Samsung Galaxy S25 Case, Soft Silicone Full Camera Protecion Shockproof Phone Case Cover for Samsung Galaxy S25 Case (Mint Green)

iVoler 3-in-1 Case for Samsung Galaxy S25 Edge 5G 6.7” with 2 Pack Tempered Glass Screen Protector, [Military Grade Drop Protection] Slim Silicone Phone Case Clear [Anti-Scratch][Non-Yellowing]

TORRAS 12FT Military-Grade Shatterproof for Samsung Galaxy S25 Ultra Screen Protector [9H+ Aerospace Tempered Glass＆ One-Pull Installation] Fingerprint Full Coverage Fit Bubble Free 6.8″ GlassGo X

3 Pack for Samsung Galaxy S25 Ultra Screen Protector, 9H Tempered Glass, Ultrasonic Fingerprint Unlock, Case Friendly for Samsung Galaxy S25 Ultra Tempered Glass Screen Protector 5G 6.9 Inch

JETech Screen Protector for Samsung Galaxy S25 Ultra 5G, Tempered Glass Film, Fingerprint ID Compatible, HD Clear, 3-Pack

[3+3 Pack] for Samsung Galaxy S25 Ultra Screen Protector, 9H Tempered Glass, Ultrasonic Fingerprint Compatible, HD Clear Case Friendly for Samsung S25 Ultra Tempered Glass Screen Protector 5G

SanDisk 128GB 2-Pack microSDXC Card, Licensed for Nintendo Switch (2x128GB) - SDSQXAO-128G-GN6Z2

SanDisk 256GB Ultra microSDXC UHS-I Memory Card with Adapter - Up to 150MB/s, C10, U1, Full HD, A1, MicroSD Card - SDSQUAC-256G-GN6MA

SanDisk 64GB Extreme PRO SDXC UHS-I Memory Card - C10, U3, V30, 4K UHD, SD Card - SDSDXXU-064G-GN4IN

SanDisk 128GB Extreme PRO SDXC UHS-I Memory Card - C10, U3, V30, 4K UHD, SD Card - SDSDXXD-128G-GN4IN

soundcore P31i by Anker, Real-Time Adaptive Noise Cancelling, Hi-Res Sound, Translation Earbuds, 50H Playtime, Wireless Earbuds, Bluetooth Earphones, Spatial Audio, Fast Charging, IP55 ClimatePartner certified

soundcore by Anker P20i True Wireless Earbuds, 10mm Drivers with Big Bass, Bluetooth 5.3, 30H Long Playtime, IPX5 Water-Resistant, 2 Mics for AI Clear Calls, 22 Preset EQs, Customization via App

soundcore by Anker Q20i Hybrid Active Noise Cancelling Headphones, Wireless Over-Ear Bluetooth, 40H Long ANC Playtime, Hi-Res Audio, Big Bass, Customize via an App, Transparency Mode, Ideal for Travel

soundcore by Anker Q20i Hybrid Active Noise Cancelling Headphones, Wireless Over-Ear Bluetooth, 40H Long ANC Playtime, Hi-Res Audio, Big Bass, Customize via an App, Transparency Mode, Ideal for Travel

Wireless Charger for Samsung - NANAMI 3 in 1 Charging Station for Multiple Devices,Fast Charger Stand Dock for Galaxy S25 S24 S23 Ultra S22 S21 S20 Z Flip Fold,Galaxy Watch 5/5 Pro/4/3,Galaxy Buds Pro

BASESAILOR iPhone 16 15 Pro Max Charger Cord,USB to USB C Cable 6.6FT/2Pack,Type C Charging Power Cord for Apple iPad 10,Samsung Galaxy AI S25 S24 S23 S22 S20 Plus Ultra Flip,A52 A53 A54,Google Pixel

Spigen Case for Galaxy S25 Case, Tough Armor (Ai) MagFit [Wireless Charging] Compatible with MagSafe - Black

Spigen Case for iPhone 16 Case, Tough Armor Designed for Apple iPhone 16 - Black

Spigen Case for iPhone 16 Pro Case, Tough Armor [MagFit] Compatible with MagSafe - Black

Spigen Case for iPhone 16 Plus Case, Tough Armor (AI) [MagFit] Compatible with MagSafe - Black

Loading...

45W Super Fast Charger USBC Charger, 2Pack 10FT Samsung Charger Fast Charging Cord Cable& Samsung Type C Charger Block for Galaxy S25 S24 S23 S22 S21 Ultra/Plus, Tab S10 S9 S8 S7,iPad,Android Phone

INIU 45W Power Bank, Ultra Small 10000mAh Portable Charger, USB C in&Out Fast Charging Battery Pack, Travel External Phone Powerbank Compatible with iPhone 16 15 Samsung S25 S24 Google Pixel iPad etc

Vihibii for Samsung Galaxy S25 Ultra Case with Card Holder (4 Cards), RFID Blocking & Slide Camera Cover, Military Grade Drop Protection, Rugged Hard Back & Silicone Edge Wallet Case, 6.9" 2025, Black