
Closed
Posted
Paid on delivery
I want a small but reliable automation that scans one or more folders, opens every Excel file it finds, filters the rows according to rules I will supply, then merges the filtered data from every relevant sheet into a clean, consolidated output file. Key points to build around: • Source files: Excel only, no other formats. • Logic: data filtering first, then merging data from multiple sheets inside each workbook before the final consolidation. • Result: a single Excel (or CSV if that is simpler) generated in a target folder each time the tool runs. The solution can be written in Power Automate (cloud or desktop), VBA, Python, or another lightweight option—as long as it runs on Windows without extra licensing. Please include: - well-commented source, - a brief setup/run guide, - configurable paths and filter criteria, - basic error handling so the run never stalls unnoticed. If you already have similar scripts or flows, let me know; otherwise a quick proof-of-concept video is enough for acceptance before final delivery.
Project ID: 40758116
32 proposals
Remote project
Active 2 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
32 freelancers are bidding on average ₹2,462 INR for this job

As a skilled and versatile digital agency, our team at Muntazir brings in-depth experience and expertise in various fields, including Data Processing, Excel, Python, and Visual Basic. Our range of skills echoes the broad requirements of your project—automating the filtering and merging of Excel files. Notably, our fluency with Power Automate (desktop or cloud), VBA, and Python positions us at the vanguard of digital automation solutions. than managing multiple freelancers. With one point of contact, you'll be able to leverage the combined skills and resources of our diverse team to build an efficient tool that meets all your requirements. Our ultimate focus will be on producing meticulously consolidated output files from your source Excel documents—a single file with filtered and merged data from multiple sheets in each workbook. Contact us now for a smooth automated journey with multiple value-adds! Looking forward to discussing your unique project needs and how we can bring real value to your process automation journey through our comprehensive digital services.
₹1,050 INR in 7 days
6.4
6.4

Hi, I can create automation that will filter and merge your Excel file. I have advanced knowledge of Excel formulas, data analysis, and VBA, and I have worked on many similar projects in the past. I can optimize your file’s function which can reduce manual tasks. We can discuss more details regarding the project. Thank you.
₹1,500 INR in 1 day
6.4
6.4

Hi, I've worked extensively with Excel VBA, Power Query, and data consolidation automation. I can build a lightweight Windows solution that scans your selected folders, filters data according to your rules, and combines matching records from multiple sheets and workbooks into one clean output file. I'd make the folder paths and filter conditions configurable, with error logging for missing columns, unreadable files, or inconsistent data. You'll receive the source code, a simple run guide, and a working demonstration. One question: do all your Excel sheets have the same column structure, or will the automation need to match different column names? Adnan
₹10,000 INR in 1 day
6.6
6.6

hello my friend ! consider it done ? . will use .net . c# or vb.net whichever you want. winforms if you want desktop experience or console for lightweight and direct use.
₹1,050 INR in 7 days
3.8
3.8

Hi, I can deliver this as a small Python tool that runs on Windows with no extra licensing: point it at one or more folders and each run filters, merges and writes one clean consolidated Excel (or CSV) file. How it works: 1) Config file: folder paths, output location and your filter rules (column, operator, value) are all editable in plain text, no code changes needed. 2) Processing: it opens every .xlsx it finds, applies your filters first, merges the filtered rows from every relevant sheet inside each workbook, then consolidates across workbooks, adding source file and sheet columns so every row is traceable. 3) Reliability: a log file for each run, clear messages for unreadable or locked files, and an end summary (files read, rows kept, rows skipped) so a run never fails silently. 4) Hand-off: well-commented source, a one-page setup guide and a double-click run file. Please send two or three sample workbooks and your filter rules and I will test against them before delivery. Quick question: do the sheets in each workbook share identical headers, or do they vary?
₹1,500 INR in 3 days
3.5
3.5

I'll build a Windows-ready Python tool that scans your chosen folders and reads the relevant sheets in each Excel workbook. It will apply configurable row filters, merge the matching rows and write one consolidated Excel or CSV file to your target folder. I'll include configurable paths and column handling, clear error logs and checks so failed files never pass unnoticed. You'll receive commented source, a setup/run guide and a short proof-of-concept video showing the complete workflow. INR 600 fixed for the complete described automation, within 3 days after full brief, sample-workbook and filter-rule review, with a funded milestone before work.
₹600 INR in 3 days
3.2
3.2

I can build this as a lightweight Python utility that scans the configured folders, processes every Excel workbook and relevant sheet, applies your filtering rules, and consolidates the matching rows into one clean Excel or CSV output. The folder paths and filter criteria will be configurable so you can change them later without modifying the core logic. My background includes Python automation and data-processing workflows, so I’ll also include proper error handling, logging, duplicate-safe processing, well-commented source code, and a short run/setup guide for Windows. Once you provide a couple of sample files and the filtering rules, I can have the working version ready within 2 days.
₹1,050 INR in 2 days
2.8
2.8

Hello, I’m interested in building this Excel automation for you. I have experience with Python, Excel/CSV processing, pandas, data transformation, automation, and database workflows. For this project, I recommend Python because it can run on Windows without additional licensing and will provide a reliable, configurable solution. The automation will: • Scan one or multiple configured folders • Detect and process Excel files automatically • Apply your specified filtering rules • Process and merge data across relevant sheets • Consolidate results into one clean output file • Support configurable source/output paths and filters • Include error handling and logging • Provide well-commented source code and setup documentation I’ll structure the solution so future changes to folders, filters, or output requirements can be made without rewriting the entire script. I’m available to start immediately and can provide a working proof of concept before final delivery.
₹1,050 INR in 7 days
2.6
2.6

Hello, I built 7 products in 7 days, and every client I've worked with on Freelancer has said they'd hire me again. I'll write this in Python and package it as a single .exe, so it runs on any Windows PC with no Python install and no licence. Folders, sheet names and your filter rules will live in a small settings file you can edit in Excel, and the rules run on each sheet first, then the sheets of each workbook merge, then everything consolidates into one output file. Each row keeps its source file and sheet name, and a summary tab lists every file read, skipped or failed and why, including files left open, password-protected ones and Excel's temporary ~$ files. I'll record a short video of a run on sample workbooks for your acceptance. Amul
₹1,499 INR in 3 days
2.6
2.6

Hi, You need a small, dependable tool that scans folders, applies your filter rules to every Excel file, merges the matching sheets inside each workbook and then writes one consolidated file on every run. Approach: a Python script (pandas and openpyxl) packaged as a single Windows .exe, so there is no licensing or install on your side. Folder paths and filter rules sit in a simple config file, for example column, operator and value, so you can change criteria without touching code. Each workbook is processed in its own try/except, so one corrupt or locked file is logged and skipped and the run never stops, and the output is a dated Excel (or CSV) in your target folder with a run log. Proof: a CRM and operations system I built for a construction company, with import/export and reporting. Question: can you share one sample workbook, and are the filter rules simple conditions (equals, contains, date range) or combined AND/OR rules? Timeline: 3 days - day 1 filter and merge logic on your sample, day 2 config, error handling and packaging, day 3 your testing and fixes. Aditya
₹600 INR in 3 days
1.7
1.7

Hello! Your Excel filter-and-merge tool, ready 1 day after the award and your filter rules. You pay us nothing until you've seen it working. Here is what you get: • A Python tool for Windows: scans your folders, filters rows, merges all sheets into one Excel • Folder paths and filter rules in one plain settings file you edit, no coding • A log file and a clear error message, so a failed run never goes unnoticed • Commented source, a one-page setup guide and a short video of a test run Good to know: the same column is often named differently across sheets ("Qty" vs "Quantity"), so we match columns by a name list you can edit. ✅ Included: 3 small changes within 3 weeks after you approve the work, and we fix any bug of ours for free. ? Bonus: an extra column showing which file and sheet each row came from. Our own demo: a data clean-up pipeline with a change log and a quality report. Price: ₹1,500 for the whole job. Are your files only .xlsx, or are there older .xls or .xlsm files too? P.S. Oldrich, the owner, supervises the work and stands behind every result. We use various tools and AI agents to work fast and efficiently.
₹1,500 INR in 1 day
1.9
1.9

Hello, I understand you need a reliable Windows automation that scans folders for Excel files, filters rows based on your rules, merges data from multiple sheets, and generates a consolidated output file. Here’s what I can provide: * Automated Excel scanning, filtering, and multi-sheet data merging. * Configurable folder paths and filter criteria for easy reuse. * Well-commented source code, error handling, a setup guide, and a proof of concept. I bring over 4+ years of experience in Python, Excel automation, and data processing, focusing on reliable, maintainable, and user-friendly solutions. Just to clarify a few things: 1. Which filtering rules and column conditions should be applied? 2. Should the output preserve the original formatting, or is clean consolidated data sufficient? Please come to the chat box to discuss more about your project. Best regards, Indresh Kushwaha
₹5,050 INR in 7 days
1.8
1.8

Hi, I would build this as a small Python tool for Windows with configurable input/output folders and filter rules. It would scan workbooks, process the relevant sheets, apply your filters before consolidation, and produce one clean Excel or CSV output. I would include useful error logs for unreadable files or unexpected columns so failures are visible, plus commented source, a run guide and a short demonstration. No paid automation licence is needed. My background is building maintainable backend and data-driven web systems. Relevant work is in my profile: https://www.freelancer.com/u/Vinay7758 INR 1,500 covers a consistent workbook schema and agreed filtering rules, delivered in two days after sample files are supplied. Could you share two representative workbooks and the exact filter conditions?
₹1,500 INR in 2 days
1.5
1.5

I can scan your Windows folders, apply your rules to each relevant sheet, and consolidate matching rows into one output file. I’d use a small Python script with openpyxl so paths and filters stay configurable without paid automation licensing. The delivery includes commented source, a setup and run guide, and basic error reporting with checks for the output file and expected rows. I have related Python workflow automation experience with retries and duplicate prevention, but no comparable published Excel script. I’ll validate the funded build against your sample workbooks and agreed expected results. At kickoff, can you share representative workbooks, the exact filter rules, and which columns define matching rows across sheets? Work starts after award, a funded milestone, and receipt of those files and rules. Delivery: within 23 elapsed hours (1 calendar days) after funded kickoff and receipt of the required access and materials.
₹969.21 INR in 1 day
1.5
1.5

I recently helped a client with a similar project, turning their requirements into a working solution that delivered the results they needed. I can help you achieve the same with a professional, reliable solution tailored to your requirements. With experience in automating Excel tasks, I focus on creating solutions that are clean, user-friendly, and efficient. I understand you're looking for an automation that scans folders, filters Excel data, and merges it into a consolidated output. I can develop this using VBA or Python, ensuring it runs smoothly on Windows without extra licensing. The solution will include well-commented source code, a brief setup guide, configurable paths and criteria, and basic error handling to prevent stalls. I can provide a proof-of-concept video for your review before final delivery. I'd be happy to discuss the details and get started. Regards, James
₹1,150 INR in 7 days
0.0
0.0

Hello, I can build a simple and reliable Python automation tool to filter and consolidate Excel files on Windows. My solution will: * Automatically scan selected folders for Excel files. * Read multiple sheets from each workbook. * Filter rows according to your specified rules. * Merge matching data into one consolidated Excel or CSV file. * Allow you to configure input/output paths and filter conditions. * Handle missing columns, invalid files, and processing errors without silently stopping. I recommend Python with pandas and openpyxl. The solution will run locally without additional software subscription fees. My bid: ₹1,500 INR Delivery: 2 days, after receiving sample files and filtering rules. You will receive the complete Python source code, configuration instructions, a sample output, and a short user guide. One question: Do all your source sheets use the same column names, or should the tool support different column structures? I can start once the requirements and sample files are available. Best regards, Le Tin
₹1,050 INR in 2 days
0.0
0.0

Hello, I can build a lightweight Windows automation that scans configurable folders, reads all Excel workbooks, applies your row filters, combines the relevant sheets, and writes one consolidated Excel or CSV output. The fixed scope includes configurable source/output paths and filter rules, multi-workbook and multi-sheet consolidation, duplicate-header handling, consistent output columns, clear logging, and basic error handling so failed files are reported without silently stopping the run. I will also provide well-commented source and a short setup/run guide. I would first validate the column structure and filter rules against sample files, then provide a proof-of-concept run before final delivery. My fixed bid is INR 1,500 with delivery in 2 days, assuming one consistent workbook family and one agreed rule set. Work begins after the Freelancer milestone is funded. Please confirm: do all source sheets use the same column names, approximately how many workbooks and rows are processed per run, and should the output preserve every source column or only a selected set? Thank you.
₹1,500 INR in 2 days
0.0
0.0

Hello, This is a good fit for a small Python tool, which runs on Windows with no licensing cost. What I would deliver: - A script that scans one or more configured folders (optionally sub-folders) for .xlsx/.xls files - Reads every relevant sheet in each workbook, applies your filter rules, merges the sheets per workbook, then consolidates everything into one output Excel (or CSV) in a target folder, with a source-file/sheet column for traceability - All paths and filter criteria kept in a simple config file (e.g. column = value, contains, date range, numeric thresholds), so you can change them without touching code - Error handling: a locked or corrupt file is skipped and written to a log, so a run never stalls silently; a summary of rows read and kept is printed at the end - Well-commented source, a one-click .bat launcher and a short setup/run guide If you share one or two sample files and the filter rules, I will send a first working version within 2 days, with a sample output for your acceptance before final delivery. Best regards
₹1,500 INR in 3 days
0.0
0.0

Hi, I can build this as a simple Python script using pandas and openpyxl. It will scan the selected folders, filter rows based on your rules, merge the relevant sheets, and save everything into one Excel file. I'll make the folder paths and filtering rules configurable, so you won't need to change the Python code each time. I'll also include error handling and a short guide. Before starting, could you share a sample workbook and the filtering rules? I'd also like to check whether all files use the same column structure. I can deliver within 2 days for ₹2,000, including testing on your sample files. Thanks!
₹2,000 INR in 3 days
0.0
0.0

I can build this as a small Python tool that runs on Windows with one click (a .bat file, or a single .exe if you prefer not to install Python). How it works: - You set the input folders, output folder and filter rules in one simple config file (or an Excel "Rules" sheet): equals, contains, greater/less than and date ranges, combined with AND/OR. - For each workbook it filters every relevant sheet first, merges them, then consolidates everything into one clean .xlsx (or CSV) in your target folder. - Each run also writes a summary sheet (rows read / kept per file and sheet) and a log, so nothing fails silently: a locked or broken file is reported and skipped, the run continues. You get commented source, a short setup/run guide, and a 60-90 second proof video on your sample files before final delivery. Could you share one sample workbook (dummy data is fine) and 2-3 example filter rules? Then I can confirm the exact output layout. Delivery: 2 days after I receive the samples.
₹1,500 INR in 2 days
0.0
0.0

New Delhi, India
Member since Oct 8, 2026
₹600-1500 INR
₹12500-37500 INR
$30-250 USD
€8-30 EUR
$750-1500 USD
$2-8 USD / hour
$15-25 USD / hour
$250-750 AUD
$1500-3000 USD
$2-8 USD / hour
$2-8 CAD / hour
$30-250 USD
$14-30 NZD
₹12500-37500 INR
₹750-1250 INR / hour
$15-25 USD / hour
$15-25 USD / hour
$250-750 USD
₹600-1500 INR
$15-25 USD / hour
₹1500-12500 INR