Choose the blank sheet or the example
Download blank CSV gives you the 11 column headings with no inventory rows. Add your records before importing it; headings alone cannot be imported. Download example CSV adds two fictional entries to show how the columns work. The names and counts are examples, not customer inventory.
The example contains three bottles in one row and two in another: two rows, five bottles. A row is a record of a group, not necessarily one bottle. Delete the example entries before replacing them with your own inventory.
Both downloads are UTF-8 CSV files with a byte-order mark. They contain plain values, with no formulas or macros. There is no email gate and this website does not upload or edit your cellar file. CSV is a text table; spreadsheet formatting, multiple tabs and cell formulas are not part of this template.
Decide what belongs on one row
Use one row for bottles sharing the same producer, wine name, vintage, bottle size and physical location. If a wine sits in two bins, record the quantities separately so the table says where each group is. Keep different bottle sizes separate even when the label and vintage match.
Count individual bottles in Quantity. Write 3 for three bottles, not “half a case” or “3 bottles”. For an opening-inventory import into Everycork, use positive whole quantities. Keep empty or historical rows in a separate record; zero-quantity rows are not accepted by the current generic import.
The grouping is a way to prepare your sheet. Everycork imports each valid row as a new wine-and-stock record; it does not automatically merge rows that describe the same wine.
Fill the fields you can verify
| Column | What to record |
|---|---|
| Producer | The producer name as you want to keep it |
| Wine name | Your wine name; required for import |
| Vintage | A numeric vintage year, such as 2022 |
| Vintage as written | NV or other wording when a numeric year does not describe the label |
| Color | red, white, rose, sparkling, dessert, fortified or other |
| Bottle size (ml) | A whole number of milliliters, such as 750 or 1500 |
| Quantity | The positive whole number of bottles in this row; required for import |
| Cellar | The top-level storage name, such as Home cellar |
| Rack | The rack or cabinet name within that location, such as Rack A |
| Bin | The specific bin or position, such as Bin 01 |
| Notes | Your own identification or record note |
For a non-vintage bottle, leave Vintage blank and put NV in Vintage as written. In the current importer, text such as NV entered directly in Vintage is retained with a warning; using the separate field makes the intention explicit.
Enter the bottle size for each row. A blank size becomes 750 ml when imported into Everycork. Write 1500 for a 1.5-liter bottle; the numeric column expects milliliters. Values outside the listed color names are stored as other.
The starter omits purchase price, drinking windows, LWIN and dates. Those fields involve additional formats or personal decisions. In particular, the current generic import’s date field expects a UTC millisecond timestamp, not an ordinary calendar-date cell. Do not rename a purchase-date column and assume it will be interpreted correctly.
Keep the location fields consistent
Use Cellar, Rack and Bin as separate levels. “Home cellar”, “Rack A” and “Bin 01” form one path. You can leave levels blank, but do not put the entire path in Bin and expect it to be split automatically.
Choose one spelling for each location and reuse it. The importer matches the parent location, level and complete name, including case and spaces. “Rack A”, “rack a” and “Rack A ” can become separate records. The bin-organization guide shows a simple way to label the physical storage before filling the sheet.
Review the mapping before importing
In Everycork, select Choose CSV file, then match the source columns to their corresponding field names. These template headings match the visible choices, but the current generic importer still requires manual mapping. At minimum, map Wine name and Quantity. Use Skip this column only when you intend not to bring that column into the app.
Check quantities, bottle sizes and all three location columns in your spreadsheet before import. In Everycork, select Preview import to review row names, Ready / Review / Rejected status and reported problems. The preview shows up to 20 rows; the importability counts cover the full file. It does not show every mapped value, so keep your spreadsheet available when checking the mapping. The file picker accepts CSV or TSV up to its stated 10 MB limit.
Import once after checking the file, then read the import report. Importing the same rows again appends new inventory; it does not update existing records or remove duplicates. If the report shows that some rows were imported and others rejected, put only the corrected rejected rows in your next import. Keep the original file and record which source rows succeeded before closing the report.
Keep inventory and history distinct
This template records an opening stock position. It does not recreate old consumption, gift, loss or undo events. A list showing five bottles today cannot explain how that total was reached.
Everycork’s export produces a ZIP containing inventory.csv and events.csv. Keep both for your records. The current importer does not restore that ZIP, original record IDs or event history. The export also omits empty locations, location capacities and ordering, and app settings. Re-importing the inventory CSV is not a complete restore procedure.
See Everycork’s product page for the app and current availability. The blank CSV remains usable as your own spreadsheet whether or not you import it.