Import Data

Import data

Importing data into Fillet

Fillet’s Import Spreadsheet helps you import large amounts of data:

Import new data, or update your Fillet data quickly and easily.

Select a sheet:
- Recipes,
- Prices, or
- Units.
Download CSV version of sheet: File > Download > Comma-separated-values (.csv)
Enter data to be imported.
Use iOS app to import. (Android & web coming soon)

⚠️ ↕︎

Please select & download each sheet separately.

For best results, do not edit the header row in the spreadsheet.

Recipes sheet

Enter your Ingredients’ names in the Ingredient column.

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

Prices sheet

Enter your Ingredients’ names in the Ingredient column.

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

Prices sheet

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

Prices sheet

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.

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

Recipes sheet

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.

Prices sheet

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.

Units sheet

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.