Excel columns

Each menu type has its own set of columns, and they differ between the export and the paste-in table. Knowing both prevents the most common import failure: values landing in the wrong field.

Export columns, by menu type

The category column always comes last and lists the categories the item belongs to.

Import columns

The paste-in table carries the same columns minus the category, because a category is chosen once for the whole batch in Assign category rather than per row.

So for the à la carte menu you paste four columns — name, full portion, half portion, unit — and select the category above the table.

Columns map by position

This is the rule that matters most: the table reads your pasted cells in the order the table shows them, not by matching heading text.

Consequences:

• rename your headings freely; it changes nothing;
• reorder your spreadsheet columns to match the on-screen table before copying;
• do not paste the heading row, or it becomes an item called "Dish name";
• do not paste extra columns; anything beyond the table's columns is not read.

Always look at the table on screen before copying. It shows exactly what that menu type expects.

The title column

The first column is the item name and it is the matching key. A row with an empty title is skipped entirely.

For wines, the column is explicitly Wine name (no vintage). Keeping vintages out of titles is what makes wine imports match reliably.

Price columns

Price cells are stored as text, exactly as they arrive. Two practical consequences:

• Enter plain values. Spreadsheet currency formatting can travel with the cell and end up stored as part of the price.
• Leave a cell empty when the format is not offered. Empty cells are skipped on import, so a blank never erases an existing value — and never creates a price of zero.

If you need a currency symbol on the printed menu, use the PDF generator's price prefix and suffix rather than putting it in the data.

The category column on export

The export's category column is informational. It tells you where each item currently sits, which makes it useful for planning a restructure in the spreadsheet.

It is not read back on import. To move items between sections, import one category at a time — see Bulk import and categories.

What has no column at all

Descriptions, subtitles, long descriptions, photos, videos, allergens, featured marks, statuses, most wine technical-sheet fields and translations. None of these can be imported or exported through this route; they are maintained on the item screens. Parker and Peñín scores are the rating-field exception: they appear in wine exports for review, but the generic paste table does not import them.