Real-Time Excel Data Merger

Customer: AI | Published: 25.09.2025

I already maintain two live Excel workbooks—one is filled every few seconds by a Python script, the other refreshes through Power Query. Now I need a third workbook that can pull only the rows and columns that meet given conditions from each source file and refresh itself automatically every minute. I’m open to whatever pipeline makes that happen most smoothly: Python, Power Query, VBA, or another lightweight ETL tool you prefer. What matters is a seamless, hands-off experience—no manual clicks, no stale links, just a workbook that always shows the latest filtered snapshot. Deliverables • A ready-to-use third Excel file that merges the filtered data from both source workbooks. • The supporting script, query, or ETL setup that drives the 60-second refresh cycle. • Simple setup notes explaining how I can adjust the filter logic or point to a new file path later. If you can build a robust, minute-by-minute bridge between my two data feeds, let’s get started.