Skip to main content
December 15, 2025
Question

Extracting Data from Multiple Dynamic Excel Sheets for DB

  • December 15, 2025
  • 1 reply
  • 0 views
My use case is: I receive a dynamic Excel file from the user each time, with changing column names, different sheet numbers, and a large amount of data. I need to insert this data into the database and display it in the interface. I tried Excel-to-DB, but it doesn’t work dynamically. I also tried using AI to extract data from Excel, but I’m not able to extract all sheets dynamically. What should I try?

    1 reply

    harshas2775
    December 15, 2025

    This is not a standard usecase. The excel file should have a generic static structure so that extraction can work or AI can be trained to fetch data from. Suggest you to discuss with business to standardise the format of document for better accuracy and efficiency.