How to Use Menutech's Public Excel Template

Menutech's Public Excel Template simplifies the process of creating and organizing your menu. Follow this step-by-step guide to download, fill out, and upload the template.

Step 1 : Downloading The Excel Template

• Log in to your Menutech account

• Navigate to the Templates section located on the right-hand side of your dashboard.

• Click on Write Your Menu.

• Download the Excel (.xlsx) file.

Step 2 : Open and Familiarize Yourself with the Template

The template also has a specific tab for instructions:

📰Adding Section Names📰

1. Section 1: Add section names to the "Section 1" column of the Excel file. Ensure the first letter of each section name is capitalized.

   • Example: Starters, Main Courses, Desserts

     Important Notes:

     • Add the appropriate section name next to each menu item.
     • Avoid inserting empty lines for section names; the software will automatically generate all sections and corresponding menu products.
     • You can also start by manually writing the menu in the Write screen to establish the structure, then export it to the excel file so you can have a visual representation of the menu when filling the excel template.
2. Subsections:
   • If the menu includes subsections (level 2), add them to the "Section 2" column.
   • For additional subsections (level 3), use the "Section 3" column.
3. Cool Tip: You can also start by manually writing the menu in the Write screen to establish the structure, then export it to the Excel file. This gives you a visual representation of the menu when filling out the template.

📜Adding Categories📜

1. Define Categories: Add the appropriate category for each menu item in the "Category" column. Categories include:
   • Dish
   • Beverage
   • Wine
2. Special Note for Beverages: The "Vintage" field is only supported for Wines, not Beverages.

🖋️Adding Product Names🖋️

1. Add Names: Add product names in the "Name" column.
   • Ensure product names follow sentence case (only the first word is capitalized).
   • Important: Products with the same name must have identical prices, allergens, and descriptions. If you have multiple products with the same name but different details, enter only the name and leave the other fields empty. Details can be added later through the app.

📜Adding Prices and Variants📜

1. Price: Enter the price for each item in the "Price" column.

   Variants: If the original menu displays prices with names/descriptions, add them in the "Variant" column.

🖋️Adding The Description🖋️

1. Add Descriptions: Copy product descriptions into the "Description" column.

Adding the Allergens

1. Declare Allergens: Add allergens in the "Allergens" column, separated by commas (example: 1,2,3).
   • Use the following codes:

📋Adding Labels📋

1. Special Labels: Add labels in the "Labels" ("Etichette") column (example: veg, vega, lacf)
   • Use these codes:

📜Additional Columns📜

1. Second Price Variants:
   • For multiple price variants, add columns at the end of the spreadsheet:
     • "Variant 2"

     • "Price 2"

       Important: Maintain the specific order of variants and prices as per the original template.

       Translations:

   • If translations are required, add additional columns for each language (e.g., "en" for English, "it" for Italian, etc.).
   • Translations should only include dish/beverage names, not descriptions.
   • Add translation columns after the "Alcohol" column.

🍷Adding Wines🍷

1. Wine-Specific Fields:

   • Use the "Wine" category in the "Category" column.

     Include:

     • Name
     • Description
     • Winery
     • Origin
     • Vintage
   • Add price variants for glass and bottle as needed.

🖋️Next Steps🖋️

1. Review the Excel file for missing or incorrect information.
2. Add any missing rows for overlooked items.
3. Import your menu on Menutech by following the steps mentioned in this article.

Additional Resources

If you have any questions or need assistance, please contact our support team.