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. Building it shouldn't take a week
Before you can cost a single recipe in MenuCost, your ingredients need to be in the system. For a bakery or café with 80 to 150 ingredients, adding them one at a time, name, unit, pack size, cost per pack, adds up to real work. At five minutes an ingredient, a 100-ingredient library takes over eight hours to type in by hand. For a lot of businesses, that's exactly what delays getting started.
Most businesses already have their ingredient costs somewhere, a spreadsheet used for ordering, a supplier price list kept up to date, a purchasing tracker built over years. Bulk ingredient import lets you use that existing data. Prepare an Excel sheet in the right format, upload it, and your ingredient library is populated. What would take days of typing takes minutes.
Example: A café owner has 94 ingredients tracked in a Google Sheet she's kept for two years, with columns for ingredient name, unit, pack size, and unit cost. She exports it as an Excel file, maps the columns to MenuCost's format, and uploads it. 91 ingredients import cleanly. Two get flagged because the unit values don't match MenuCost's list; she fixes those in 30 seconds each. One duplicate gets skipped. Her whole ingredient library is live in under 10 minutes, and she starts building recipes the same day.
Bulk import also makes price updates manageable. When a supplier sends a new price list, update your spreadsheet and re-import it; existing ingredients update in place, and every recipe cost recalculates from the new prices right away.
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, a purchasing tracker. Format and map it to MenuCost's bulk import template so it's ready to upload.
Upload the file
In MenuCost, go to your ingredient library and select import. Upload your Excel file. MenuCost reads it right away and shows you a preview: how many rows it found, which columns it recognised, and anything it flagged 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 as a duplicate. Need to fix something? Update your Excel file and re-import it. Nothing gets added to MenuCost until you review and approve.
Confirm and import
Click confirm import, and MenuCost adds all approved rows to your library at once. The 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 go through cleanly.
Re-import to update prices any time
When supplier prices change, update your spreadsheet and re-import it. MenuCost matches rows by ingredient name, existing ingredients get updated with the new cost, and new rows get added. Every recipe using those ingredients recalculates right away.
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 and deveined) and cheddar cheese (block) are flagged as duplicates. You can skip them or update the existing records. Nothing gets imported until you confirm, so there's no risk of duplicate or incorrect data landing in your 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 library means you can begin costing recipes right away, instead of building it up bit by bit over weeks. Bulk import removes the setup delay that keeps businesses from getting value out of MenuCost early on.
- Your existing data works as it is. Already tracking ingredient costs in a spreadsheet for ordering, budgeting, or stock? You don't need to retype any of it. Export to Excel, map the columns, upload. The work you've already done carries straight over into MenuCost.
- Price updates applied across all recipes at once. When a supplier raises prices, update the ingredient costs in your library. MenuCost recalculates the cost of every recipe using those ingredients automatically, so your numbers stay accurate with one update.
- A review step that catches problems before they reach your library. The preview shows 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
An Excel file (.xlsx). Any spreadsheet app can export to that format, in Google Sheets, use File, Download, Microsoft Excel.
MenuCost checks for duplicates by matching ingredient names exactly. Find a duplicate, and it shows up in the preview as a conflict, you can skip it (keep the existing entry) or update it (overwrite it with the new data). This 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 every cost value in the template. If you track some ingredients in a different currency, say you source from an international supplier and track those costs in USD, convert them to your account currency before importing. MenuCost doesn't convert currencies during import.
No hard limit, but very large files, over 1,000 rows, might take a bit longer to process during the preview step. Most bakeries and cafés have ingredient libraries well under 300 items, so this rarely comes up in practice. If you're migrating a large multi-site operation, you can split the import into several files by category.
When a re-import updates an ingredient's cost, every recipe using it recalculates its cost per serving automatically. The recipe itself doesn't change, only the cost input does. You'll see the updated numbers the moment you open any affected recipe, and it shows up in your menu cost reports right away too.
Build your ingredient library, not one row at a time
Join the bakeries and coffee shops who get set up and start costing on day one.