Bulk Ingredient Import
Get your ingredient library set up in minutes, not days
Upload a spreadsheet of your ingredients - names, units, and costs - and MenuCost imports them all at once. No manual entry, no starting from scratch.
WHY THIS MATTERS
The ingredient library is the foundation of every recipe cost — it shouldn't take a week to build
Before you can cost a single recipe in MenuCost, your ingredients need to be in the system. For a bakery or café with 80 - 150 ingredients, adding them one by one - name, unit, pack size, cost per pack - is a significant amount of work. At five minutes per ingredient, a 100-ingredient library takes over eight hours to enter manually. For many businesses, that time cost is what delays getting started.
Most businesses already have their ingredient costs somewhere - a spreadsheet they use for ordering, a supplier price list they update regularly, a purchasing tracker built over years. Bulk Ingredient Import lets you use that existing data. Prepare a excel sheet in the required format, upload it, and your ingredient library is populated. What would take days of manual entry takes minutes.
Example: A café owner has 94 ingredients tracked in a Google Sheet she's maintained for two years - columns for ingredient name, unit, pack size, and unit cost. She exports it as a excel sheet, maps the columns to MenuCost's format, and uploads the file. 91 ingredients import cleanly. Two are flagged because the unit values don't match MenuCost's unit list - she fixes them in 30 seconds each. One duplicate is skipped. Her entire ingredient library is live in under 10 minutes. She starts building recipes the same day.
Bulk import also makes price updates manageable. When a supplier sends a new price list, you can update your spreadsheet and re-import - existing ingredients update in place, and your recipe costs recalculate from the new prices immediately..
HOW IT WORKS
Upload, review, confirm — your library is ready
Prepare your Excel file
Export your ingredient data from whatever you're already using - Google Sheets, Excel, a supplier price list, or a purchasing tracker. Then, format and map the data according to the MenuCost bulk ingredient import template for easy upload.
Upload the file
In MenuCost, go to your ingredient library and select Import. Upload your Excel file. MenuCost reads the file immediately and shows you a preview of what it found - how many rows it detected, which columns it recognised, and any issues it identified before the import runs.
Review the import preview
The preview shows each row mapped to an ingredient entry, colour-coded by status - ready to import, flagged for a fixable issue, or skipped because of a duplicate. If any corrections are needed, you can update the data in your Excel file and re-import it. No data is imported into MenuCost until you review the results and approve the import..
Confirm and import
Click Confirm Import and MenuCost adds all approved rows to your ingredient library at once. The import summary tells you exactly how many ingredients were added, how many were updated, and how many were skipped - with reasons for anything that didn't import cleanly.
Re-import to update prices any time
When supplier prices change, update your spreadsheet and re-import the file. MenuCost matches rows by ingredient name - existing ingredients are updated with the new cost, and any new rows are added. Every recipe using updated ingredients recalculates immediately.
REAL EXAMPLE
What the import preview looks like
A sample Excel template being imported — raw spreadsheet rows on the left, the resulting ingredient entries on the right, each with an import status.
The rows for Shrimp (Peeled & Deveined) and Cheddar Cheese (Block) have been flagged as duplicates. You can either skip these duplicates or update the existing records. No data will be imported until you confirm, ensuring there is no risk of incorrect or duplicate information being added to your ingredient library.
WHAT YOU GET
What changes when you don't have to enter ingredients one by one
- A complete ingredient library from day one. Starting with a full ingredient library means you can begin costing recipes immediately, rather than building up your library incrementally over weeks. Bulk import removes the setup bottleneck that delays businesses from getting value from MenuCost.
- Your existing data works as-is. If you already track ingredient costs in a spreadsheet - for ordering, budgeting, or stock management - you don't need to re-enter it. Export to Excel sheet, map columns, and upload. The work you've already done transfers directly into MenuCost.
- Price updates applied across all recipes at once. When a supplier increases prices, simply update the ingredient costs in your library. MenuCost automatically recalculates the cost of every recipe using those ingredients, ensuring your pricing data stays accurate with a single update.
- A review step that catches problems before they reach your library. The import preview shows you exactly what will be added, updated, or skipped - with clear reasons for anything flagged. You see issues before they become bad data, and you approve every import before it runs.
QUESTIONS
MenuCost accepts Excel file(.xlsx). Any spreadsheet application can export to Excel format - in Google Sheets, use File → Download → Microsoft excel.
MenuCost detects duplicates by matching ingredient names exactly. When a duplicate is found, it's shown in the preview as a conflict — you can choose to skip it (keep the existing entry unchanged) or update it (overwrite the existing entry with the data from the Excel template row). The choice is per-row, so you can skip some duplicates and update others in the same import.
The import uses your account's default currency for all cost values in the Excel template. If you track some ingredient costs in a different currency — for example, you source certain items from an international supplier and track costs in USD — convert those values to your account currency before importing. MenuCost doesn't do currency conversion during import.
There's no hard limit on file size, but very large files — over 1,000 rows — may take a few seconds longer to process during the preview step. For most bakeries and cafés, ingredient libraries are well under 300 items, so this is rarely a constraint in practice. If you're migrating from a large multi-site operation, you can split the import into multiple files by category.
When a re-import updates an ingredient's unit cost, every recipe that uses that ingredient recalculates its cost per serving automatically. The recipe itself doesn't change — only the cost input changes. You'll see the updated costs immediately when you open any affected recipe, and the change is reflected in your Menu Cost Reports straight away.
Build your ingredient library—not one row at a time
Join bakeries and coffee shops who get set up and start costing on day one.
✓ 7 days free · ✓ Cancel anytime