Use Excel with a recipe template file

You can use Excel to create or edit a recipe template if you do not want to use the Recipe Manager utility. You must save the Recipe Manager template created or edited with Excel to a file with a .csv file name extension.

Open an existing recipe template file in Microsoft Excel

1. Start Excel.

2. On the File menu, select Open. The Open dialog box appear.

3. Locate and select the .csv file then, select Open or, double-click the file name. Excel shows the contents of the file.

   

4. Edit the contents of the recipe file and save your changes.

Create a new recipe template file in Excel

5. Start Excel.

6. Create a new workbook.

7. Enter recipe data in the spreadsheet, as shown in the following figure.

   

   The entries must be made in the order shown in the figure. Unit Names must be defined in columns to the left of columns containing Recipe Names.

8. Save the spreadsheet with a .csv file name extension.