Supermarket Nutrition Excel Databases
Budget: $250 – $750 AUD
I need two stand-alone Excel workbooks—one for Coles, one for Woolworths—populated with every single food item listed in each supermarket’s online catalogue. Using the 'Type' template I will supply for an idea of what is required, please fill in product name, brand, pack size, calories and the full macro profile: protein, carbohydrates, fat, fibre, sugar and sodium.
Accuracy matters more than speed; each entry must match the nutrition panel published by the retailer or the manufacturer. Once the initial files are complete, I’d like a refreshed version delivered every month so the databases stay current as product lines change. If you automate the extraction with Python, Power Query or a similar tool, document the steps so the monthly update can be reproduced easily.
Deliverables:
• Coles.xlsx fully filled out in my template
• Woolworths.xlsx fully filled out in my template
• Clear instructions—or a script—showing how you will capture new and discontinued products for the monthly refresh
Let me know your proposed approach and expected turnaround time for the first release.
Accuracy matters more than speed; each entry must match the nutrition panel published by the retailer or the manufacturer. Once the initial files are complete, I’d like a refreshed version delivered every month so the databases stay current as product lines change. If you automate the extraction with Python, Power Query or a similar tool, document the steps so the monthly update can be reproduced easily.
Deliverables:
• Coles.xlsx fully filled out in my template
• Woolworths.xlsx fully filled out in my template
• Clear instructions—or a script—showing how you will capture new and discontinued products for the monthly refresh
Let me know your proposed approach and expected turnaround time for the first release.