
Closed
Posted
Paid on delivery
I have two Excel workbooks that do not share the same column headers. Alongside them is a separate mapping file that tells the AI which column in file-A corresponds to which column in file-B. What I need you to build is a small AI-assisted agent—Python with pandas / openpyxl is fine, but feel free to use any modern data-processing stack—that: • Reads both workbooks and the mapping file, even when the headers differ. • Performs a full comparison, returning every missing row or column and every cell whose mapped values differ. • Generates a concise, human-readable summary report (this is the only required output) that lists those discrepancies. Extra care is needed around stray spaces or data that has been moved inside a row; the agent shouldn’t “fix” these automatically. Instead, flag them clearly in the report so I can review and decide. I’ll provide the two Excel files and the mapping table once we start. Please structure your solution so I can drop in future files and rerun the script. A brief README explaining how to execute it will be appreciated.
Project ID: 40382837
26 proposals
Remote project
Active 23 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
26 freelancers are bidding on average $16 USD for this job

As an experienced Data Analysis and Data Processing expert with thorough knowledge in Excel and Python, I am positive that I can deliver a high-quality AI-Driven Excel Comparator solution for your project. First and foremost, with my proficiency in using pandas and openpyxl, I am equipped to tackle the unique situation of dissimilar column headers between two workbooks. This allows me to efficiently process your mapping file, accurately mapping every column from file A to file B for an effective comparison. Beyond just locating missing rows or columns and identifying mismatching cell values as per your requirements, I understand the critical need for clear flagging of any inconsistencies rather than automatically modifying them. This level of care will be integrated seamlessly into your summary report, outputting readable discrepancies that you can easily review and decide upon. Finally, my goal-oriented approach aligns well with your need for a structured solution that accommodates future files. With well-commented code and a comprehensive README on how to execute it, you will have no difficulty utilizing the tool even after future iterations. My commitment lies in delivering a solution that not only meets but surpasses your expectations. Let's discuss further on how we can get started on this!
$13 USD in 1 day
7.1
7.1

Hello, I am an experienced data automation specialist who will build a Python (pandas/openpyxl) script that reads two Excel workbooks with different column headers and a mapping file, then performs a full comparison—identifying missing rows/columns and mismatched cells (including stray spaces or moved data, flagged not fixed). The output will be a concise, human‑readable summary report (e.g., Excel or text). I will structure the solution so you can drop in future files and rerun the script, and provide a brief README. I am ready to start immediately. Please share the two workbooks and mapping file. Regards, Zafar
$15 USD in 1 day
6.2
6.2

Hi there, I can build a clean Python agent using pandas/openpyxl to compare both Excel files using your mapping file, even with different headers. It will detect missing rows/columns, mismatched values, and flag issues like extra spaces or shifted data without altering anything. You’ll get a clear, human-readable summary report plus a reusable script and README. Ready to start. Best regards, Avinash
$15 USD in 1 day
5.4
5.4

Respected Sir, I am Puja Rani. I have read your proposal completely. I have experience I am ready to start working. I am confident that I can handle it easily. If you are interested, please message me and we can discuss further
$10 USD in 1 day
4.5
4.5

Hi there, It looks like you need an AI-driven tool to compare two Excel workbooks with different headers, using a mapping file to identify corresponding columns. I can help you build a Python script using pandas and openpyxl that will read both workbooks and the mapping file, perform a thorough comparison, and generate a concise summary report of any discrepancies. With 4+ years of experience in data processing and automation, I understand the importance of addressing stray spaces and moved data without making automatic fixes. I'll ensure that any such issues are flagged clearly in the report for your review. Additionally, I'll structure the solution to allow easy updates with future files and provide a brief README to guide you through running the script. Just to clarify, how frequently do you anticipate needing to use this comparison tool? Best regards, Arslan Shahid
$13 USD in 7 days
3.9
3.9

Affordable, Early Delivery. ★★★★★★★★★★★★★★I hold a Masters degree which gives me the requisite background to handle writing from various subjects. I am a highly committed person towards my work. You can rely on QualityXenter for quality and consistency in writing. We never violate copyright rules. I have vast amount of experience in this industry since I am working from 2015 as a professional writer. I provide many modifications till to get your satisfactions. I have access to enough journals to use in your research project. I always produce quality work at VERY LOW RATES so, don't worry if you have a low budget for your work, I will be very happy to make a new client like you. I am producing quality work for my clients including ARTICLE WRITING, REPORT WRITING, ESSAY WRITING, RESEARCH PAPERS, BUSINESS PLAN, TECHNICAL WRITING, MATLAB, THESIS, ACCOUNTING & FINANCE work ETC. Go through my profile link https://www.freelancer.com/u/qualityxenter
$10 USD in 1 day
4.1
4.1

As a seasoned full stack developer with a penchant for automation and AI integration, I believe I'm the best fit for your project. My five-year extensive understanding of software engineering has enabled me to specialize in building intelligent systems, precisely what you need for your AI-driven Excel comparator. With Python as my bread-and-butter supplemented by robust libraries such as pandas and openpyxl, I'll proficiently enable your worksheets and mapping file comparisons even if their column headers differ. What sets me apart is my ability to deliver outputs that are not just functional, but also user-friendly. Hence, your concise human-readable summary report will be generated meticulously under my command. Stray spaces or data that have been moved inside a row? Absolutely no worry! Part of my commitment involves flagging anything unusual for you to review and decide upon; ensuring nothing is "fixed" automatically without your consent. Structuring my solutions for convenient future usage is one of my biggest strengths. Thus, I will create the agent and its accompanying README in such a way that allows you to effortlessly drop in future files and rerun the script at your convenience. The proof for all this lies in my strong trac record across various industries. Let's leverage these skills together to turn your vision into scalable reality!
$50 USD in 1 day
4.0
4.0

Mapping sheet as alignment bridge makes sense, pandas reads it and normalizes headers before the row comparison runs. Loads both workbooks, applies mapping, diffs row by row, writes mismatches to a highlighted output file. Re-runnable on new pairs. M1: comparison script, $8, 1d. M2: output with highlights, $7, 1d. Mapping sheet format, header names side by side or a different structure?
$15 USD in 1 day
2.8
2.8

Hello, I can build a clean and reliable Excel comparison agent based on the three files you provided (File1, File2, and the Mapping sheet). The solution will be lightweight, reusable, and fully aligned with your requirements. ✔️ Technical Approach Load both Excel files and the mapping sheet to align columns (e.g., “Name” → “Nme”, “Qualifications” → “Q”). Normalize values (trim spaces, unify separators like | and ;) without modifying the original data. Compare the two datasets to detect: missing or extra columns missing rows cell‑level differences reordered multi‑value fields (e.g., LLB|LLC|MA vs LLC;MA;LLB) Generate a human‑readable discrepancy report summarizing all differences. Provide a small, clear README explaining how to run the script with any future files. ✔️ Deliverables Python comparison script Mapping loader Normalization + comparison engine Clean discrepancy report README (usage + structure) juste 3-4hours ✔️ Why me 28+ years of engineering experience, strong background in data processing, pandas, and Excel automation. I already analyzed your sample files and can deliver a clean, reusable solution quickly. Ready to start.
$20 USD in 1 day
2.5
2.5

Hi, I’ve read your brief and can build a small, reusable Python agent that reads the two workbooks and the mapping file, compares them column-by-column via your mapping, and produces a concise, human-readable discrepancy report. I focus on clarity and maintainability: the script will use pandas and openpyxl (or pyarrow/xlsx alternatives if preferred), accept arbitrary header names through your mapping file, and be organized so you can drop in new files and rerun without changes. Technically, I’ll load both sheets into normalized DataFrames, apply the mapping to align columns, and run row- and cell-level comparisons that flag missing rows, missing columns, and any mapped-cell differences. I’ll add careful checks for stray spaces and moved data (reporting them as flagged items rather than auto-correcting). The output will be a concise summary report (CSV and human-readable text) and a short README showing how to run the script. Next step: I’ll start once you send the two Excel files and the mapping table; I’ll provide the script, example run, and README. Do your files share a natural row key (one or more columns to identify rows), or should I include a configurable row-matching strategy (exact key, composite key, or fuzzy row matching)? Best regards, Cindy Viorina
$10 USD in 1 day
2.2
2.2

Hi, there, I understand you need an AI-assisted Excel comparator that reads two workbooks with differing headers, applies a mapping file, and generates a concise, human-readable report listing missing rows, missing columns, and cell-level discrepancies without automatically altering the data. Accuracy and clarity in the report are the priority. With strong experience in Python, pandas, and openpyxl, I can build a reusable agent that reads both workbooks, applies your column mapping, and identifies all mismatches, including stray spaces or moved data, flagging them clearly for review. The output will be a structured summary report suitable for decision-making, and the solution will be fully reusable for future files. My approach is to parse both workbooks, normalize data according to the mapping file, perform row and cell comparisons, and generate a clean report highlighting all differences. A brief README will be included to guide future usage. To proceed, I will review your sample files and mapping table to configure the script for precise and reliable comparison. Thanks, Ihor
$15 USD in 1 day
2.2
2.2

Dear Client, I'm an experienced full-stack developer specializing in Python, pandas, and data automation, with over 10 years of building intelligent data-processing pipelines and comparison tools. I understand you need an AI-assisted agent that reads two mismatched Excel workbooks plus a mapping file, performs full column-mapped comparison, flags missing rows, shifted data, stray spaces, and cell-level discrepancies — without auto-correcting anything. My expertise in Python, pandas, openpyxl, and modular script design ensures a clean, reusable solution with a human-readable summary report and a clear README for future reruns. Feel free to share both workbooks and the mapping file whenever ready. Looking forward to hearing from you. Best regards, Md Ruhul Ajom
$45 USD in 2 days
3.3
3.3

Hi, I understand the task and will ensure your expectations are me. I am an experienced freelancer with 4 years of experience in Python, Data Visualization, Automation. Visit my profile to view latest projects. Looking forward to your reply. Best regards, Syeda Tahreem
$10 USD in 10 days
0.0
0.0

Hey , I just finished reading the job description and I see you are looking for someone experienced in Data Processing, Data Analysis, Data Visualization, Automation, Python, Pandas and Excel. This is something I can do. Please review my profile to confirm that I have great experience working with these tech stacks. While I have few questions: 1. These are all the requirements? If not, Please share more detailed requirements. 2. Do you currently have anything done for the job or it has to be done from scratch? 3. What is the timeline to get this done? Why Choose Me? Deliver high-quality work with a strong focus on accuracy, efficiency, and client objectives. Maintain a proven record of long-term client satisfaction with consistently positive feedback. Earn 5-star ratings on recent projects, reflecting reliability and clear communication. Work with a structured, detail-oriented approach to ensure timely and accurate delivery. Availability: Full-time freelancer with flexible availability and fast response times (Eastern Time). I will share with you my recent work in the private chat due to privacy concerns! Please start the chat to discuss it further. Regards, Ali
$10 USD in 4 days
0.0
0.0

This is exactly the kind of work I handle well. Handling differences in headers is often the tricky part, especially when mapping files aren’t perfectly aligned with raw data. I will ensure the process flags discrepancies clearly, avoiding unwanted automatic fixes while keeping the report straightforward and actionable. Reach out for a free consultation, happy to share a clear next step with no expectations. Stefan
$15 USD in 14 days
0.0
0.0

‼️ONLY PAY WHEN YOU'RE 100% HAPPY‼️ Your need to accurately compare two Excel workbooks with differing headers using a mapping file highlights the importance of precise, human-readable discrepancy reporting without auto-corrections. My approach: I’ll build a Python agent using pandas that dynamically reads the files and mapping, compares rows and columns as per the map, and clearly flags missing data and value mismatches—especially subtle issues like stray spaces or shifted cells—in a concise summary report. While I’m new to Freelancer, I’ve completed similar data reconciliation projects that delivered clear, actionable results. Let’s chat! Worst case, you get a free consultation and real insight. Regards Pietie Lubbe.
$11 USD in 14 days
0.0
0.0

Hi, I can build a lightweight AI-assisted Excel comparison tool that works exactly as you described — even when column headers don’t match and the structure varies between files. The approach I’ll take is to first normalize both workbooks using your mapping file as the “source of truth.” This allows the system to correctly align mismatched columns before running any comparisons. From there, I’ll implement a row-level and cell-level comparison engine that detects missing rows, missing columns, and value differences across mapped fields. Special attention will be given to edge cases like extra spaces, shifted data, or formatting inconsistencies — these will be clearly flagged in the report rather than auto-corrected, so you retain full control over decisions. The script will be reusable — you’ll be able to drop in new files and a mapping sheet, run a single command, and generate the report again without modification. I’ll also include a simple README with clear steps to run it locally. Timeline: 1–2 days Cost: $15 (fits your budget) If needed, I can also extend this later into a small UI tool or add export formats. Let me know if you want it as a CLI script or a simple interface. Thanks.
$15 USD in 1 day
0.0
0.0

Hi there, and warm greetings, I’m Farhan Shabbir, a professional Python and data automation developer with strong experience in building AI-assisted agents, data pipelines, and Excel-driven automation systems using pandas and openpyxl. I’ve carefully understood your requirement for a lightweight but intelligent agent that can process and handle structured data efficiently. My focus will be on building a clean, modular solution that is easy to run, maintain, and extend for future use. What I will deliver: ◉ Python-based AI-assisted agent using pandas and openpyxl for robust data handling ◉ Clean data processing pipeline for reading, transforming, and validating structured files ◉ Intelligent logic layer to automate decision-making or classification where required ◉ Error handling and logging system for safe and traceable execution ◉ Modular code structure so additional features can be integrated later easily ◉ Clear setup instructions for local or server-based execution The goal is to create a reliable automation agent that reduces manual work, improves accuracy, and can be scaled or enhanced with AI features in future iterations. I’m ready to start immediately and build a practical, efficient solution tailored to your workflow. Risk-Free Guarantee → No upfront payment. Pay only when satisfied, with full money-back assurance.
$10 USD in 1 day
0.0
0.0

Hello, I can build a reusable Python-based comparison tool that reads both Excel workbooks plus your mapping file, aligns the datasets dynamically (even with different headers), and performs a structured, cell-level comparison using pandas/openpyxl. The script will not modify or “correct” any data—instead, it will strictly flag missing rows, missing columns, and mismatched mapped values, including issues caused by spacing or shifted cell content. The output will be a clean, human-readable discrepancy report summarizing all differences, and I’ll include a simple README so you can rerun the tool on future file pairs without changes to the core logic. Feel free to message me back for extra details.
$10 USD in 2 days
0.0
0.0

Hello, I can build this for you. Your project is well aligned with my background in Python, Excel, data processing, and logic-based comparison workflows. I understand the key requirement: two Excel workbooks with different headers need to be compared using a separate mapping file, and the output should clearly identify matching issues, missing values, row differences, and cell-level mismatches in a way that is actually useful to a human reviewer. My approach would be to create a robust first version using Python with libraries such as pandas and openpyxl, with logic for: * reading both workbooks, * applying your mapping file, * aligning comparable columns, * flagging differences, missing rows, and missing columns, * generating a clear comparison report. I would focus on a solution that is practical, readable, and easy to test rather than an overcomplicated prototype. If you want, I can also structure it so the tool can be reused with updated files later. I may be new on Freelancer, but this type of structured analytical task is exactly where I can deliver real value. I would be glad to help with a clean and reliable implementation. Best regards Sergej W.
$13 USD in 3 days
0.0
0.0

Stamford, United States
Member since Apr 19, 2026
$10-100 USD
₹12500-37500 INR
$2-8 CAD / hour
$30-250 CAD
$15-25 USD / hour
₹75000-150000 INR
₹600-1500 INR
$30-250 USD
$30-250 USD
$250-750 USD
₹1500-12500 INR
$8-15 CAD / hour
₹750-1250 INR / hour
₹600-666 INR
$10-30 USD
$10-30 USD
₹1500-12500 INR
₹750-1250 INR / hour
$30-250 USD
$25-50 AUD / hour
₹100-400 INR / hour