[Python] Python solution to extract all tables PDFs and save each table to its own Excel sheet...

I’m working with around multiple PDF files (all in English, mostly digital). Each PDF contains multiple tables. Some have 5 tables, others have 10–20 tables scattered across different pages.

I need a reliable way in Python (or any tool) that can automatically:

• 
  Open every PDF
  
  
• 
  Detect and extract ALL tables correctly (including tables that span multiple pages)
  
  
• 
  Save each table into Excel, preferably one table per sheet (or one table per file)
  

Does anyone know the best working solution for this kind of bulk table extraction? I’m looking for something that “just works” with high accuracy.

Continue reading...