Importing and exporting

Add or update many dishes, choices, menus and extras at once from a spreadsheet, or download them in the same format to edit and import again. Nothing is saved until you have checked the preview.

To import from a spreadsheet

  1. Step 1: On a computer, click Import in the sidebar, then click Import (there is no Import on phones).
  2. Step 2: Click Download the template and fill in the sheets you need. Click a column heading in the spreadsheet to see what goes in it.
  3. Step 3: Choose your file and click Check. Every sheet in the file is read, so you upload it once.
  4. Step 4: Read the table: every row is OK or says in plain words what to fix.
  5. Step 5: Click Import to save the OK rows, or fix the sheet and choose it again. Click Download the rows to fix to get the rows with a problem as a CSV, with the reason beside each.

To export

  1. Step 1: Click Export in the section of the Library you want (Menus, Dishes, Choices or Extras) for that section's items.
  2. Step 2: Or on the Import page, click Export everything. It asks first, then downloads the venue you are in. In group view you choose one venue, or all of them, in that question.
  3. Step 3: Edit the file and import it again: items are matched by name.

To see past imports

  1. Step 1: Click Import in the sidebar and scroll to Import history under the import box.
  2. Step 2: Each line shows when, who, the file, the venue, what was added (for example 12 dishes, 3 menus), the problems and whether it finished.
  3. Step 3: Click the number under Problems to read what to fix in your sheet. Imports are listed for two years.

To import into another venue

  1. Step 1: Choose the venue in the venue switcher: an import always goes to the venue you are in, and the pop-up says which one.
  2. Step 2: Or choose All venues (group view), click Import in the sidebar, click Import and choose the venue, or Group items, under Import into.
  3. Step 3: In an export of all venues, each row's Venue column decides where it goes.

What things mean

New
Not in PreOrderly yet: it will be added.
Updated
Already in PreOrderly with this name, and something in the file is different.
Unchanged
Already in PreOrderly exactly as in the file: nothing to do.
Problem
A row has something we cannot read, such as a blank or unknown allergen. It is left out and nothing is guessed; the OK rows can still be imported.

Tips

  • Items are matched by name and capitals do not matter. A name you already have is updated, a new one is added, and nothing is ever deleted.
  • Imported menus are always saved as drafts. A published menu stays live, unchanged, until you publish the new draft.
  • Every dish and choice needs its Allergens cell filled in. Write None if it has no allergens: a blank cell is flagged, never read as no allergens, and an allergen we do not recognise is flagged too.
  • Name the specific cereal or nut in Allergens, such as Wheat or Almond, and use May contain for cross-contact. Always check imported allergens before you publish.
  • Rows whose name starts with Example: are never imported, so you can leave the template's examples in.
  • The template has about six columns on each sheet. Extra columns (May contain, Tag, Extra charge, menu settings and more) are optional: add one by typing its heading, as listed on the Start here sheet. Older templates still import.
  • You can also import one CSV file per sheet, with the template's column headings.
  • An import never archives or restores anything: archive and restore items in PreOrderly. An Archived column in an older file is ignored.

Still need help?

Email us with what you were doing and what you saw. A person replies within one working day. Guests and hosts: for questions about a booking, please contact the venue first.

Contact supportsupport@preorderly.app

Something not loading? Check the system status.

Import your menu from a spreadsheet · PreOrderly