Automated Excel Power Query Price Comparator

@rabbiawebjuggler

As an experienced data analyst with a strong background in Excel and Power Query, I believe I am the ideal candidate for this project. My specialties in data entry, analysis, processing, and visualization are a perfect fit for your need to compare supplier price lists efficiently and accurately. Having helped numerous clients with similar projects in the past, I understand the need for a clean, reliable, and fully functional price comparison tool. My expertise in data normalization will ensure that prices are accurately compared despite variations in formats (whether it's European or US). Additionally, my extensive experience with web scraping and product listing will be valuable as we extract data from multiple supplier Excel files and seamlessly match products across suppliers. Ultimately, my primary goal is to help you obtain the best prices from the cheapest supplier for each product swiftly and efficiently.

@usmanbashir12100

Hi, You need a clean, reliable Power Query solution on Excel (Mac) that compares multiple supplier price lists without over-complication. I will build a structured workflow that imports all files, standardizes EAN/UPC fields, normalizes EU/US price formats, and matches products accurately across suppliers using a consistent data model. I will create a dynamic comparison table that calculates the best price and identifies the cheapest supplier while retaining product details like description, brand, and format. You’ll receive a fully working Excel file with simple refresh functionality, clear query structure, and a short guide so you can add new supplier files and update results easily. Ready to start right away. Usman Bashir

@ayazakhtar75

Hi Client , With over 16 years in the industry, I, Ayaz, believe I have the right blend of data analysis skills and advanced Excel knowledge needed for your project. As a seasoned specialist in Excel and Power Query, I've built numerous complex tools that have powerfully enhanced businesses' workflow efficiency. More importantly, I understand the significance of reliability and simplicity in such projects. My proficiency extends to data normalization, efficient comparison, and dynamic KPI tracking— all critical components of this task. The fact that I can expertly normalize European and US price formats will ensure seamless use of your various supplier files. Additionally, my venture, Ayaz's Data Analysis Solutions has familiarized me with challenging projects in diverse industries where no solution is too complex to be achieved. This experience allows me to not only guarantee timely and robust solutions but also maintain a keen focus on testing the outputs thoroughly before delivery. Despite any previous setbacks, I stand if entrusted with this project I can deliver not just a fully-working but an impeccably clean solution that handles all your requirements gracefully.

@sareheshak

AVAILABLE TO START IMMEDIATELY. FREE SAMPLE PROVIDED.,,. I will develop a clean Power Query workflow for Mac that consolidates multiple supplier files, normalizes EU/US price formats, and creates a dynamic dashboard identifying the cheapest supplier by EAN/UPC. 10+ years Advanced Excel experience, Certified VBA Programmer, MBA.

@sknadeem123

Hello Client, I hope you are doing well. I came across your project **Automated Excel Power Query Price Comparator**, and it immediately caught my interest. Based on your description, I’m confident that I can deliver high-quality results that align perfectly with your expectations. **Why I’m a great fit for this project:** • I have strong experience working with Data Processing, Excel, Software Architecture, Data Analysis, Data Integration, Data Visualization, Data Management, and I’ve completed similar projects in the past.   • I always focus on clean, optimized, and fully functional work.   • Communication and responsiveness are my top priorities — you’ll always be updated on progress. **What I will deliver:** • A complete and professional solution tailored to your project requirements   • Timely delivery within your budget range of **8.00 - 30.00 EUR**   • Clean, well-structured work with revisions included   • A focus on quality, clarity, and long-term reliability If you would like to discuss your project further, I’m available at any time.   I would love the opportunity to work with you and help bring your idea to life. Thank you for considering my proposal. I look forward to working with you! Best regards,   Nadeem Shaikh

@mattafareed4848

Hello I can build a clean and reliable Excel (Mac) Power Query solution that imports multiple supplier files, normalizes EAN/UPC and price formats, matches products across datasets, and generates a clear comparison table showing the best price and cheapest supplier along with product details like description, brand, and format—ensuring a simple, stable setup that avoids unnecessary complexity and works consistently. Regards Muhammad

@eshA0010

With over a decade's experience in building robust and accurate Excel systems, I am well-positioned to successfully deliver your power query price comparator. I have handled numerous intricate data projects including, but not limited to advanced Excel and Google sheets tasks, VBA automation, data reporting and most importantly data processing tasks similar to this. I have an eye for detail and an obsession with cleanliness and precision of data which would be fully implemented in this required solution. Having had the opportunity to appraise the failures encountered in previous attempts, one of my strongest suits is delivering clean, reliable and effective solutions. Additionally, my mastery of multiple Excel functions would ensure that your supplier files are accurately read, EAN or UPC promptly detected and prices normalized from both European & US formats. Given my keen appreciation of structured systems and clean data, I guarantee not only the creation of a comprehensive comparison table but also the calculation of the "Best Price" as well as provider with "Cheapest Supplier". Reliability is my watchword hence you can be assured that regardless of the formatting or complexity in your input data, I will bring clarity to your output alongside insightful product information. Trust me to get the job done in an organized and timely manner that brings value and efficiency to your business. Eyasha is your go-to-freelancer.

@ahmedsadek111124

Hello, I can help you build a clean and efficient price comparison tool using Excel Power Query on Mac. I will ensure multiple supplier files are read correctly, EAN/UPC codes are detected, and prices are normalized to a consistent format. The tool will match products and produce a clear table showing the best price and cheapest supplier with relevant product details. I focus on simplicity and reliability to avoid past issues. What is the typical number of supplier files you expect to compare at once? Thanks,

@GdevDataSceince

Hi there,I am a Data Scientist is a professional responsible for extracting actionable insights and knowledge from large volumes of data Microsoft applications Development. I can write clean, Excel, Word, Access, PowerPoint, Power BI, Outlook and creating VBA macros. Excel: Advanced Array Formulas, Charts, Pivot Tables, Pivot Charts, Mail Merge, VBA Macros, Excel Macros, Capabilities, Spreadsheets. Email through Outlook and Gmail, Add-in, Customized Macros. My top priority is to provide a high quality of work, I am willing to fully devote my time and energy to improve the service offered, with timely, accurate and professional results, building trust and a long term relationship with customer is my main objective. https://www.freelancer.com/u/GdevDataSceince Choosing me for this project not only means benefiting from my extensive skills in Excel and data analysis but also entrusting your sales data with someone who values precision and confidentiality. Let's begin working together on this valuable project to deliver lasting results that will positively impact your business. Thanks Gdev

@vw1514518vw

I understand the challenge for US, Canda UPC, EAN coding and the EU EAN13 coding standards as well as the number format standards for thousand seprator and decimal points and ready to create the required multiple suppliers item price comparator workbook with the feature you described. No worries, not working perfect enough no pay.

@ajamshad162

As an experienced professional in the realms of data processing, data visualization, and Excel mastery - I understand the complexities and nuance of your project's demands. In my 20+ successful projects across a range of industries, I have consistently built tools that are clean, robust, and most importantly - reliable. Drawing upon these experiences, I'm confident in my ability to tackle your price comparison tool with an unwavering focus on delivering streamlined and efficient results. A critical skill to the success of this project is an expert handling of data - particularly with Excel's Power Query tool. My previous work has demanded the same level of proficiency by me and provided me ample opportunities to master this aspect. With this level of comfort I find myself in while dealing with Excel Power Query and a proven track record of delivering immaculate solutions, I stand qualified for the challenge. Lastly, what truly sets me apart is my unwavering detail-orientation. This project's history has been hampered by over-complex and untested solutions; which is something you won’t encounter with me. I pride myself on a coherent and organized approach that ensures transparency right from planning to execution. So let's not let past failures dampen our spirits - rather let's reinvent this project together with a clean slate and create a solution that you can rely on completely.

@nareshk44

As a highly skilled and experienced Excel specialist, I am confident that I can deliver the clean and reliable solution you are seeking for your price comparison tool. My in-depth knowledge of Power Query and its functionalities, such as data normalization and merging, ensures I can effectively read and combine multiple supplier Excel files while accurately detecting EAN or UPC codes needed for matching products across suppliers. One of my core strengths lies in my ability to effectively process large datasets without compromising quality, an essential skill for a project of this nature. Having worked extensively with numeric and text-based data, including normalizing prices in various formats (EU / US) found in your spreadsheet samples will be no challenge for me. Additionally, my experience with data visualization will guarantee an organized and user-friendly comparison table. Finally, as someone committed to meeting deadlines without any compromise on quality, you can expect a fast turnaround time with unlimited revisions and 100% satisfaction guaranteed. So why wait? Choose me for your project and let me provide you with a robust solution that gets you the best prices from the cheapest supplier for each product – all in your preferred formats (Excel Mac) within the desired timeframe.

@MZITSERVICES

Hi there, I am A.R.M. MASUD, with a strong data science background. I specialize in creating customized Excel-based solutions that streamline business processes, enhance data management, and enable insightful analysis. Whether it’s developing advanced macros, automating workflows, or integrating Excel with other Microsoft applications, I deliver robust, efficient solutions tailored to your specific needs. My expertise includes AR/AP Management, Financial Statement Preparation, Expense Tracking, Budgeting and Forecasting, Cash Flow Management, and APR Calculation via the Sales Force Formula. I design and develop advanced Excel workbooks with tailored features such as formulas, macros, pivot tables, Power Query, mail merge, email via Outlook and Gmail, add-ins, customized macros, and automated repetitive tasks using Excel VBA. I also create interactive dashboards for real-time data visualization, providing fully functional and customized Excel workbooks, automated workflows, and macros for efficient task management and data integration between Excel and other business systems. https://www.freelancer.com.bd/projects/excel/Advanced-Data-Processing-Chart/reviews Thank you for considering your Microsoft Excel development project. I am confident that my expertise and commitment to excellence will add significant value to your business operations. Thanks A.R.M MASUD

@SmartCodeDev

Hello, I can build a clean and reliable Excel Power Query solution to compare supplier price lists and identify the cheapest source per product. I will ensure accurate EAN UPC matching price normalization for EU and US formats and a clear comparison table with best price and supplier. The solution will be simple robust and fully tested with structured queries and easy refresh. I can deliver quickly with clear instructions for use and future updates. Let me know if you can share sample files so I can start.

@ShivaniGoyalsai

Hi, I can build a clean and reliable Excel Power Query price comparator that works properly on windows. I have strong experience in Power Query, Excel data cleaning, supplier price comparisons, and automated reporting. I’ll create a robust tool that imports multiple supplier files, detects EAN/UPC, normalizes EU/US price formats, matches products across suppliers, and outputs a clear comparison table showing best price, cheapest supplier, description, brand, and format. I’ll keep the solution simple, tested, refresh-ready, and easy to maintain. Ready to review your sample files and build a working version. Thanks Shivani

@jepita200

Hello, I carefully reviewed your project and understand that you need a clean, reliable, and fully working Excel (Mac) Power Query solution to compare supplier price lists and identify the cheapest supplier per product. I also noted that previous attempts failed due to over-complicated approaches. My focus will be to build a simple, robust, and easy-to-maintain solution that works consistently. My approach: • Import multiple supplier files dynamically using Power Query • Standardize and detect EAN/UPC fields across different file structures • Normalize price formats (EU 12,50 and US 12.50) into a consistent numeric format • Match products across suppliers using EAN/UPC as the key • Build a comparison table showing all supplier prices side-by-side • Calculate Best Price and automatically identify the Cheapest Supplier • Include product details (Description, Brand, Format) where available I will keep the model clean, well-structured, and fully test it to ensure it runs smoothly on Excel for Mac without unnecessary complexity. I can also provide clear instructions so you can easily update or add new supplier files in the future. I am confident I can deliver a stable and working solution within your timeline. Best regards, Mt Juetiara

@carlosd178

Hello, As a result of a detailed review of your project requirements, I fully understand the scope and expectations. I have experience building clean Excel and Power Query tools, and I’m available to start right now. I bring strong expertise in Excel for Mac, Power Query, Data Integration, Data Processing, Data Analysis, and Data Management with over 10 years of experience. One key challenge here is keeping the solution simple and reliable: importing multiple supplier files, detecting EAN/UPC columns, normalizing EU/US price formats, matching products correctly, and generating a clear comparison table with Best Price and Cheapest Supplier. I would build this as a tested Power Query workflow with easy folder-based import, clear column mapping, and refresh instructions so you can update supplier files without rebuilding anything. I have a couple of quick questions. • Do all supplier files have similar column names, or should the tool handle different headers? • Should the final output show all supplier prices side by side or only the cheapest result? Best regards, Carlos.

@omair890

Hi there, I will build a clean, reliable Excel (Mac-compatible) Power Query solution that imports multiple supplier files, detects EAN/UPC automatically, standardizes mixed EU/US price formats, and matches products across all sources into a single comparison table. The model will calculate the lowest price per item, identify the cheapest supplier, and retain key product details like description, brand and format without overcomplicating the logic. The structure will be simple, fully tested, and easy to refresh with new supplier files by just dropping them into a folder. You will receive a ready-to-use Excel file with Power Query set up, clear naming, and step-by-step instructions so you can maintain it yourself. I will ensure accurate matching, stable refresh performance, and handle edge cases like missing fields or inconsistent formats. Delivery will include revisions, testing with your sample data, and a dependable final version that works smoothly on Mac Excel.

@faisal702

Hello, I can build a clean and reliable Excel Power Query supplier price comparator that reads multiple files, detects EAN/UPC, normalizes EU/US prices, and identifies the cheapest supplier. I have strong experience with Excel, Power Query, data cleaning, and price comparison tools, and I will keep the solution simple, tested, and easy to maintain on Mac.