Data import spreadsheet

Enter data into Import Spreadsheet #

Basic #

Ingredient names #

Enter your Ingredients' names in the Ingredient column.

When you use these Ingredients in Recipes, the Recipe Ingredients will use these names.

Enter your Ingredients' names in the Ingredient column.

When you Order these Ingredients from your suppliers, the Orders will use these names.

Ingredient prices #

Enter your Ingredients' prices in the Price column.

When you Order these Ingredients from your suppliers, the Orders will use these Ingredient prices.

Example
Ingredient Price Amount Unit Supplier
Apples 3.00 3.00 kg Farmer #1
Bananas 4.00 2.00 kg Farmer #2
Oranges 5.00 1.00 kg Farmer #1
Tomatoes 6.00 0.50 lb Farmer #3
Garlic 7.00 1.00 bag Farmer #3
Onion 8.00 1.00 bag Farmer #3
Honey 9.00 1.00 L Natural foods supplier
Almonds 10.00 1.00 kg Natural foods supplier

Ingredient suppliers #

Enter names of your Ingredients' suppliers in the Supplier column.

When you Order these Ingredients from your suppliers, the Orders will use these suppliers' names.

Advanced #

Ingredients in a Recipe #

You can also use Fillet’s Import Spreadsheet to specify what Recipes use which Ingredients.

After you import your data, the Fillet apps can do automatic calculations for you.

Example
Ingredient Amount Unit Recipe
Apples 3.00 kg Fruit cake
Bananas 3.00 g Fruit cake
Oranges 3.00 L Fruit cake
Tomatoes 3.00 kg Pasta sauce
Garlic 2.00 each Pasta sauce
Onion 1.50 lb Pasta sauce
Olive oil 500.00 mL Pasta sauce

Measurement units #

Enter measurement units in the Units column.

When you use these Ingredients in Recipes, these measurement units are used with the quantities you entered in the Amounts column.

This is Ingredient quantity in a Recipe.

Enter measurement units in the Units column.

When you Order these Ingredients from your suppliers, these measurement units are used with the quantities you entered in the Amounts column.

This is Ingredient price per unit.

Enter custom measurement units (Abstract Units) that you want to use in the Recipes sheet or Prices sheet.

After you import your data, you can use these units in Fillet apps.