Bringing in your lists
Import your beer list, your drinks and food, or your brew history from a spreadsheet, however messy it is.
You don't have to type your list in again. PintDeck reads the spreadsheet you already have, works out which column is which, and shows you every change before anything is saved.
There are three imports, all built the same way:
| Import | Where | Each row needs |
|---|---|---|
| Beers | Products › Beers, then ⋯ › Import beers… | A name, a style and an ABV |
| Alternative items | Products › Alternative Items, then ⋯ › Import items… | A name |
| Brew history | ⋯ › Import brew history… on Products › Beers, Inventory › Tank Schedule or Inventory › Recipes; or Import from a spreadsheet on a beer's Batches tab | A brew day and a beer |
A brand-new Beers or Alternative Items tab offers the import right on the empty page.
File
Drop a CSV, an Excel (.xlsx) file or a TSV, or copy the rows from a spreadsheet and paste them in. Up to 2,000 rows at a time.
PintDeck shows the top of the sheet the way your spreadsheet does. It finds the header row on its own (skipping a title like Beer list 2025 above it) and leaves out rows that say Total. If the guess is off, pick the right Headers on row, or another sheet of an Excel file.
Starting from scratch? Download the template, as CSV or Excel, from the same screen.
Columns
What PintDeck needs is a checklist. Each item ticks when a column is matched to it. Headers are matched on their words, so ABV (%), Price ($) and Name of Beer all land. Anything that isn't right can be changed in Your columns, or set to Don't import.
No ABV column? Choose Use one value for every row and type one; you can change any beer on Check. The same works for style.
PintDeck remembers your columns for the next import.
Values
Anything PintDeck couldn't read exactly is asked about here, once per value: NEIPA in six rows is one question. Most come with a suggestion (NEIPA becomes Hazy IPA, Cocktail becomes Cocktails).
A style or category that isn't on your list yet is only added when you pick Keep as a new style (or category). You can also leave the rows with a value out.
Numbers shows the rules PintDeck used: an ABV written as a fraction (0.065 is 6.5%), a comma used as a decimal point (6,8 is 6.8), N/A and TBD read as empty, and IBU rounded to a whole number.
If every value matched, this step is skipped.
Check
Every row, with every column you used. A value PintDeck changed shows what it was (6.8, was 6,8). Click a cell to change it.
- Ready imports as shown.
- Needs a look imports as shown too, but read the note under the row: a description an unquoted comma split in two, or a name close to a beer you already have.
- Won't import is missing something it needs, like an ABV. Type it in and it's ready.
- Already on your list is skipped unless you say otherwise. Pick Fill in blanks to add what your list is missing (it never changes what's there), or Add anyway for a genuinely different beer with the same name.
Ready means ready: PintDeck checks each row the same way it will when saving.
Done
You'll see how many were added, filled in, skipped and left out. Rows that didn't import are listed by their row number in your file, and you can download them to fix and bring in again.
Open Beers shows just the beers from this import, so you can select them and edit or delete them together.
Undoing an import
For 24 hours an import can be undone: from its Done screen, or from the tab's ⋯ menu under Last import. Undo removes what the import added and clears what it filled in. A beer that's been used since (filled into a keg, counted in stock, brewed) is kept, and PintDeck tells you which.
A point-of-sale export
Export your POS item list and bring it in through Import beers…. If it has a category column (Draft Beer, Wine, Food), PintDeck asks once per category on Values whether it's Beer or Alternative items. Beer rows come in as beers; the rest come in as alternative items, filed under a category of the same name, without needing a style or ABV. One import, and one Undo, covers both.
A POS list usually has no style or ABV, and no tap column, so its beers come in off tap. Use one value for every row on Columns, then fix the beers that differ on Check.