Phoenix - Your AI AssistantClean, normalize and match messy supplier price lists in Excel
Delivery in
2 days
- Views 14
Amount of days required to complete work for this Offer as set by the freelancer.
Rating of the Offer as calculated from other buyers' reviews.
Average time for the freelancer to first reply on the workstream after purchase or contact on this Offer.
What you get with this Offer
Have a messy client BOM (mixed languages, shorthand, multiple part numbers in one cell) or multiple supplier quotes in different currencies and units that will not match via standard VLOOKUP?
Combining Harvard Data Science training with 20 years in B2B procurement, I will clean, normalize, and cross-match up to 1,000 rows of complex industrial or electronic part numbers into a clean, automated Excel comparison model within 24 hours.
What is included:
* Splitting combined cells and standardizing brand and part number syntax.
* Fuzzy matching across multiple supplier catalogs to pair identical items.
* Unified single-currency comparison table with minimum price highlighting.
Combining Harvard Data Science training with 20 years in B2B procurement, I will clean, normalize, and cross-match up to 1,000 rows of complex industrial or electronic part numbers into a clean, automated Excel comparison model within 24 hours.
What is included:
* Splitting combined cells and standardizing brand and part number syntax.
* Fuzzy matching across multiple supplier catalogs to pair identical items.
* Unified single-currency comparison table with minimum price highlighting.
What the Freelancer needs to start the work
Please provide:
1. Your source files (Excel, CSV, PDF tables, or text).
2. The desired output layout or columns you want in your final workbook.
3. Any specific rules (base currency, formatting preferences, or brand priorities).