> For the complete documentation index, see [llms.txt](https://docs.foodcore.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.foodcore.io/getting-started/importing-data.md).

# Importing existing data

If you've already got ingredient data in a spreadsheet or another tool, you don't need to re-enter everything by hand. FoodCore's import tool accepts CSV and Excel files, so you can bring your existing data across in one go.

## Supported formats

| Format            | Notes                                                                                                          |
| ----------------- | -------------------------------------------------------------------------------------------------------------- |
| **CSV** (.csv)    | Standard comma-separated values. Most spreadsheet apps and kitchen management tools can export to this format. |
| **Excel** (.xlsx) | Import directly from Excel workbooks. The first sheet is used.                                                 |

At present, the import tool works for **ingredients**. Recipes must be created manually within FoodCore once your ingredients are set up.

## Before you import — clean your data first

A few minutes spent tidying your spreadsheet before importing saves a lot of clean-up afterwards:

* **Consistent ingredient names** — decide on one name per ingredient and use it everywhere. "Plain Flour", "plain flour", and "Flour (plain)" will import as three separate ingredients.
* **Consistent supplier names** — if you reference suppliers in your spreadsheet, make sure the spelling is identical across rows. FoodCore uses supplier names to group and filter ingredients.
* **Numeric prices only** — remove any currency symbols (£, $) from price columns before importing. FoodCore expects a plain number like `2.49`.
* **One ingredient per row** — each row should represent a single ingredient with its price, unit, and any other data.
* **Allergens are set manually after import** — FoodCore does not import allergen data from spreadsheets (the column formats vary too much to map reliably). Plan to go through your imported ingredients and add allergens after the import is complete.

## How to import

1. Go to **Ingredients** in the sidebar.
2. Click **Import** (top right of the Ingredients page).
3. **Choose your file** — click Browse and select your CSV or Excel file.
4. FoodCore analyses the file and shows you a **column mapping screen**. Match each column in your file to the correct FoodCore field (name, price, unit, pack size, supplier, and so on). If FoodCore recognises the column headers, it maps them automatically.
5. Click **Preview** to see how your data will look once imported. Review a sample of rows to check the mapping is correct.
6. If any **duplicate ingredients** are detected — names that match something already in your FoodCore library — FoodCore flags them and asks you what to do. For each duplicate, you can choose to **skip it** (keep the existing record), **replace it** (overwrite the existing record with the imported data), or **import as new** (create a second record alongside the existing one). Take care here — importing as new is the most common cause of duplicate clutter.
7. Once you're happy with the preview and have resolved any conflicts, click **Confirm import**.
8. FoodCore shows you an **import summary**: how many ingredients were added, how many were skipped, and whether any rows had errors. If there were errors, they're listed with the row number so you can fix them in your source file and re-import just those rows.

## After importing — add allergens

Allergen data doesn't come across from spreadsheets, so your next step after importing is to go through your ingredients and add the correct allergens to each one.

The quickest way to do this is to use the **Allergen Audit** tool (Allergens → Audit). It shows you every ingredient with no allergen data set, so you can work through them systematically rather than hunting through the full list.

[Add allergens to ingredients →](https://docs.foodcore.io/ingredients/allergens.md)

## Tips for a clean import

* **Import in batches** if you have a very large ingredient list. Smaller batches are easier to review in the preview step.
* **Check supplier names after import** — go to Ingredients and use the supplier filter to confirm that each supplier's ingredients have grouped correctly.
* **Don't worry about perfection** — you can always edit individual ingredients after importing. Getting the bulk of your data in quickly is more valuable than holding off until everything is perfectly formatted.

## What's next

* [Add allergens to ingredients](https://docs.foodcore.io/ingredients/allergens.md) — complete your ingredient setup after importing
* [Fix duplicate ingredients](https://docs.foodcore.io/ingredients/duplicates.md) — clean up any duplicates created during import
* [Create your first recipe](https://docs.foodcore.io/recipes/create-recipe.md) — start building recipes with your imported ingredients
