BRING YOUR COLLECTION WITH YOU

Import Your Collection

Already tracking your bottles in a spreadsheet? Bring the whole shelf into Dram Diary in a couple of minutes — no retyping.

📥

THE IMPORT TEMPLATE

A ready-made Excel workbook with the right columns, dropdowns for type and size, three example rows, and a short set of instructions. Only Name is required — leave anything you don't know blank.

DOWNLOAD TEMPLATE (.XLSX) WORKS IN EXCEL, NUMBERS & GOOGLE SHEETS · .CSV ALSO ACCEPTED

How it works

GET YOUR SPREADSHEET READY

Download the template above, or use the sheet you already keep. We match your columns automatically — “Bottle”, “Brand”, “Price Paid” and friends are all recognized, and you can fix any mismatch before importing.

GET THE FILE ONTO YOUR IPHONE

AirDrop it from your Mac, save it to iCloud Drive / Files, or simply email it to yourself and save the attachment. Any .xlsx or .csv works.

IMPORT IN DRAM DIARY

Open the app, go to PROFILE → IMPORT COLLECTION, pick the file, review the matches we found, and tap import. Done — your shelf is in your pocket.

Column reference

These are the columns the template uses. Your own headers don't need to match exactly — the importer recognizes common synonyms and lets you map anything it can't guess.

COLUMN	REQUIRED	ACCEPTED VALUES
Name	REQUIRED	Bottle / expression name, e.g. “Eagle Rare 10 Year”
Distillery	RECOMMENDED	Producer or brand — helps us match the right catalog entry
Type	OPTIONAL	Bourbon, Rye, Tennessee, American Single Malt, American Blend, Wheat Whiskey, Corn Whiskey, Scotch Single Malt, Scotch Blended, Irish, Japanese, Canadian, Other (blank = Bourbon)
Proof	OPTIONAL	Number 1–200 (an “ABV” column is also accepted and doubled)
Age (Years)	OPTIONAL	Whole number 0–100 (blank = no age statement)
Size	OPTIONAL	50ml, 200ml, 375ml, 700ml, 750ml, 1L, 1.75L (blank = 750ml)
Purchase Date	OPTIONAL	Any common date format
Purchase Price	OPTIONAL	Number — “$” and commas are fine
Purchased From	OPTIONAL	Store or retailer
Storage Location	OPTIONAL	Free text (blank = “Home Bar”)
Open?	OPTIONAL	Yes / No, Y / N, True / False, Open / Sealed, 1 / 0
Date Opened	OPTIONAL	Any common date format
Fill Level %	OPTIONAL	0–100 (blank = 100)
Rating (0-100)	OPTIONAL	0–100
Tasting Notes	OPTIONAL	Free text
Private Notes	OPTIONAL	Free text — never shown publicly
UPC	OPTIONAL	Digits only, 8–14
Release Year	OPTIONAL	4-digit year
Pick Type	OPTIONAL	Standard, Store Pick, Club Pick, Distillery Pick, Private Barrel (blank = Standard)
Barrel #	OPTIONAL	Free text
Quantity	OPTIONAL	Whole number ≥ 1 — one row becomes that many bottles (blank = 1)

Extra columns are ignored, so there's no need to trim your existing sheet.

Frequently Asked Questions

DO I HAVE TO USE YOUR TEMPLATE?

No. Any .xlsx or .csv file works. When you pick a file, Dram Diary reads your header row, guesses which column is which, and shows you the mapping so you can correct anything before a single bottle is imported. The template is just the quickest way to start from scratch.

WHAT HAPPENS TO BOTTLES YOU DON'T RECOGNIZE?

They're added to your collection immediately — nothing waits and no data is lost. Behind the scenes we create a catalog entry that's visible only to you until our team reviews it. Once reviewed it becomes part of the shared catalog (or gets merged into an existing entry), and your bottle simply follows along.

WILL THIS CREATE DUPLICATES?

We match every row against our catalog of 40,000+ bottles. Confident matches are linked automatically; close-but-not-certain matches are shown to you so you can confirm the right one or add the bottle as new. If anything slips through, our team merges it during review — your collection is re-pointed and nothing you entered is lost.

CAN I UNDO AN IMPORT?

Yes. Go to Profile → Import Collection → Recent imports and tap Undo next to the import. Every bottle created by that import is removed from your collection in one step. Bottles you added by hand are never touched.

IS IMPORT FREE?

Yes. Importing your collection is free for every Dram Diary account, with no bottle limit.

READY WHEN YOU ARE

Bring your shelf into Dram Diary

Have the file on your iPhone? Open the app straight to the import screen. Don't have the app yet? Grab it on the App Store.

OPEN IN DRAM DIARY DOWNLOAD ON THE App Store

“Open in Dram Diary” only works on an iPhone with the app installed.