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 CSV file 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 CSV, 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 CSV file
Export your ingredient data from whatever you're already using — Google Sheets, Excel, a supplier price list, or a purchasing tracker. Make sure the file has at least the three required columns: name, unit, and unit_cost. Column names are case-insensitive and can be in any order.
Upload the file
In MenuCost, go to your ingredient library and select Import. Upload your CSV 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. You can edit flagged rows directly in the preview before confirming. Nothing is imported until you approve it.
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 CSV file being imported — raw spreadsheet rows on the left, the resulting ingredient entries on the right, each with an import status.
The caster sugar row is flagged because "cups" isn't in MenuCost's unit list. Changing it to "g" or "kg" in the preview — which takes seconds — clears the flag and moves it into the ready-to-import group. Nothing imports until you confirm, so there's no risk of bad data reaching 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 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 reformat or re-enter it. Export to CSV, map three columns, and upload. The work you've already done transfers directly into MenuCost.
- Price updates applied across all recipes at once. When a supplier raises prices, the old approach is to find every recipe that uses the affected ingredients and update each one manually. With bulk import, you update your spreadsheet, re-import the file, and every recipe recalculates from the new costs in one step.
- 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 standard CSV files (.csv). Any spreadsheet application can export to CSV — in Google Sheets, use File → Download → Comma-separated values. In Excel or Numbers, use File → Save As and choose CSV. The file should use comma delimiters and UTF-8 encoding, which is the default for all major spreadsheet tools.
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 CSV 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 CSV. 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