The #1 excuse I’ve heard for not using CellarHQ has been “I already have my cellar in a Google Docs spreadsheet and don’t want to have to re-enter it.” It’s a completely valid excuse, especially for those of you with mighty impressive cellars. Well, if you’ve been holding out, you can now import your previous Google Docs, Excel, or Numbers (iWork) spreadsheet by uploading a CSV to CellarHQ.

Import Process

If you’re new to CellarHQ or your cellar is empty, you’ll be prompted to import your previous cellar after you sign in.

Or you can go to the Settings page and click Import CSV.

You’ll be presented a series of tips to get your spreadsheet ready for import. These include having your columns in the necessary order, perhaps renaming a few breweries and beers, formatting your dates, etc. All of these will help the import process better match your beers and reduce the amount of manual fixing you’ll have to do.

Once you have your CSV file ready, select it in the upload box and click Upload.

The import process may take a minute or two while it matches your breweries and beers to the ones in CellarHQ’s database. Once it’s done you’ll be presented the import results. Click Fix on unmatched beers to complete the import process.

You’ll be shown which fields need fixing and be able to fix them and add the beer to your cellar.

If you’re importing a brewery or beer that is not in our database, you can add it to the CellarHQ database by clicking Add Brewery or Add Beer. This will open a new window and let you add the brewery or beer to our database for everyone else to use. You can then return to your Import Results window and finish adding your beer.

As you fix items, your import statistics will update, showing how many more items need to be fixed.

If you try to leave this page before fixing all unmatched beers, the page will ask if you’re sure you want to leave. Any progress will be lost on unmatched beers if you leave the page and try to come back making it difficult to not end up with duplicates or missing beers.

Your Feedback

This may seem like a lengthy process, but it’s actually quite simple and much faster than adding tens or even hundreds of beers one-by-one.

If you import your old cellar, please let me know your thoughts on the process. The import process was quite complicated to develop. I’ve taken many steps to try to make it simple and efficient, but I am certainly open to feedback on how to make it better.

Made Possible By…

The countless hours that went into developing the pattern matching process for the import was made possible by an unknown vintage Serpents Stout from The Lost Abbey.

Comments