{"id":7649,"date":"2012-04-04T18:54:49","date_gmt":"2012-04-04T18:54:49","guid":{"rendered":"http:\/\/adam-jackson.net\/beer\/?p=104"},"modified":"2012-04-04T18:54:49","modified_gmt":"2012-04-04T18:54:49","slug":"organizing-my-cellar-with-cellarhq","status":"publish","type":"post","link":"https:\/\/adamchandler.me\/blog\/2012\/04\/04\/organizing-my-cellar-with-cellarhq\/","title":{"rendered":"\u2605 Organizing My Cellar with CellarHQ"},"content":{"rendered":"

A few weeks ago, the team at CellarHQ reached out to me after I tweeted about us beer collectors not having many great options for cellaring. Most of us use Google Docs. I use Excel and upload to Google Docs to share with people. Beer trading revolves around Google Docs and it’s not a great platform for a few reasons. Most importantly, it’s not really tailored to beer. CellarHQ is but my issue was that it was a manual process. I had to enter every single one of my 300+ beers into their system. This would take hours that could be spent drinking beer.<\/p>\n

I sent the team my Excel files and they used it and other CSV and XLS documents to build a new feature for uploading your cellar doc. Very cool! After a few weeks, the feature launched.<\/a><\/p>\n

\n

The #1 excuse I\u2019ve heard for not using CellarHQ has been \u201cI already have my cellar in a Google Docs spreadsheet and don\u2019t want to have to re-enter it.\u201d It\u2019s a completely valid excuse, especially for those of you with mighty impressive cellars. Well, if you\u2019ve been holding out, you can now import your previous Google Docs, Excel, or Numbers (iWork) spreadsheet by uploading a CSV to CellarHQ.<\/em><\/p>\n<\/blockquote>\n

I was told my cellar could probably be imported at 50% success rate. They were right.<\/p>\n

\"Screen<\/p>\n

The ones that weren’t matched were easy to fix. I could see what was not matched and then manually add them with most of the details already included such as bottle count and year:<\/p>\n

\"Screen<\/p>\n

Overall, this tool was built very fast and works as expected. You can view my cellar right here<\/a>!<\/p>\n","protected":false},"excerpt":{"rendered":"A few weeks ago, the team at CellarHQ reached out to me after I tweeted about us beer…\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","apple_news_api_created_at":"2018-12-07T16:00:49Z","apple_news_api_id":"ccdf9cbd-f885-4b6e-a229-ac293eebfc7c","apple_news_api_modified_at":"2018-12-07T16:00:54Z","apple_news_api_revision":"AAAAAAAAAAD\/\/\/\/\/\/\/\/\/\/w==","apple_news_api_share_url":"https:\/\/apple.news\/AzN-cvfiFS26iKawpPuv8fA","apple_news_cover_media_provider":"image","apple_news_coverimage":0,"apple_news_coverimage_caption":"","apple_news_cover_video_id":0,"apple_news_cover_video_url":"","apple_news_cover_embedwebvideo_url":"","apple_news_is_hidden":"","apple_news_is_paid":"","apple_news_is_preview":"","apple_news_is_sponsored":"","apple_news_maturity_rating":"","apple_news_metadata":"\"\"","apple_news_pullquote":"","apple_news_pullquote_position":"","apple_news_slug":"","apple_news_sections":[],"apple_news_suppress_video_url":false,"apple_news_use_image_component":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"csco_singular_sidebar":"","csco_page_header_type":"","csco_custom_appearance":"","csco_disable_excerpt_posts_layout":false,"csco_page_load_nextpost":"","csco_post_video_location":[],"csco_post_video_location_hash":"","csco_post_video_url":"","csco_post_video_bg_start_time":0,"csco_post_video_bg_end_time":0,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[174],"tags":[],"class_list":["post-7649","post","type-post","status-publish","format-standard","category-cellaring","cs-entry","cs-video-wrap"],"apple_news_notices":[],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/pb3IC4-1Zn","jetpack-related-posts":[{"id":1395,"url":"https:\/\/adamchandler.me\/blog\/2013\/03\/20\/cellaring-organizing-with-cellarhq-ratebeer-and-the-beer-cellar\/","url_meta":{"origin":7649,"position":0},"title":"\u2605 Cellaring: Organizing with CellarHQ, RateBeer and The Beer Cellar","author":"Adam Chandler","date":"March 20, 2013","format":false,"excerpt":"The problem with the lack of a tasting group and having no other hobbies means that I accumulate a lot of beer. I'm not alone in this unintentional cellaring group. After only a year in beer as a hobby, I have hundreds of fermented beverages in my basement. Homebrewing doesn't\u2026","rel":"","context":"In "Cellaring"","block_context":{"text":"Cellaring","link":"https:\/\/adamchandler.me\/blog\/category\/beer\/cellaring\/"},"img":{"alt_text":"2013 Beer Cellar","src":"https:\/\/i0.wp.com\/farm9.staticflickr.com\/8216\/8404159870_aa8f0d0180_z.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/farm9.staticflickr.com\/8216\/8404159870_aa8f0d0180_z.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/farm9.staticflickr.com\/8216\/8404159870_aa8f0d0180_z.jpg?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":7672,"url":"https:\/\/adamchandler.me\/blog\/2012\/07\/02\/cellaring-finally-updated-my-beer-cellar\/","url_meta":{"origin":7649,"position":1},"title":"\u2605 Cellaring: Finally Updated my Beer Cellar","author":"Adam Chandler","date":"July 2, 2012","format":false,"excerpt":"This was LONG overdue. For the past 2 months, I've been adding and taking out beers from the cellar without updating the huge Excel file that I created in March. After my return from Belgium, it was important to go back and add in what I have. I need to\u2026","rel":"","context":"In "Cellaring"","block_context":{"text":"Cellaring","link":"https:\/\/adamchandler.me\/blog\/category\/beer\/cellaring\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":7704,"url":"https:\/\/adamchandler.me\/blog\/2013\/01\/22\/cellaring-new-home-cellar-setup\/","url_meta":{"origin":7649,"position":2},"title":"\u2605 Cellaring: New Home Cellar Setup","author":"Adam Chandler","date":"January 22, 2013","format":false,"excerpt":"I've read and researched a lot more than I've written on this blog about cellaring. Unlike wine, beer cellaring is not mainstream, it's not well documented and it's a guessing game as to what improves and what \"falls off\". The consensus of most beer geeks is that cellaring is not\u2026","rel":"","context":"In "Cellaring"","block_context":{"text":"Cellaring","link":"https:\/\/adamchandler.me\/blog\/category\/beer\/cellaring\/"},"img":{"alt_text":"2013 Beer Cellar","src":"https:\/\/i0.wp.com\/farm9.staticflickr.com\/8374\/8402985345_c987e16490_z.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/farm9.staticflickr.com\/8374\/8402985345_c987e16490_z.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/farm9.staticflickr.com\/8374\/8402985345_c987e16490_z.jpg?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":8205,"url":"https:\/\/adamchandler.me\/blog\/2020\/02\/25\/cellaring-our-beer-cellar-is-nearly-complete\/","url_meta":{"origin":7649,"position":3},"title":"Cellaring: Our Beer Cellar is Nearly Complete","author":"Adam Chandler","date":"February 25, 2020","format":false,"excerpt":"After purchasing this house in October 2016, it wasn\u2019t until March that we finally moved in. The beer slowly got unpacked but it wasn\u2019t until Summer of 2017 that we got around to building a beer room which was 2x6 construction, R40 insulation and an exterior door locking in all\u2026","rel":"","context":"In "Cellaring"","block_context":{"text":"Cellaring","link":"https:\/\/adamchandler.me\/blog\/category\/beer\/cellaring\/"},"img":{"alt_text":"Beer Cellar 2020","src":"https:\/\/i0.wp.com\/live.staticflickr.com\/65535\/49577164476_9568f68bc0_c.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/live.staticflickr.com\/65535\/49577164476_9568f68bc0_c.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/live.staticflickr.com\/65535\/49577164476_9568f68bc0_c.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/live.staticflickr.com\/65535\/49577164476_9568f68bc0_c.jpg?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":7750,"url":"https:\/\/adamchandler.me\/blog\/2014\/04\/23\/cellaring-unboxed-and-organized\/","url_meta":{"origin":7649,"position":4},"title":"\u2605 Cellaring: Unboxed and Organized","author":"Adam Chandler","date":"April 23, 2014","format":false,"excerpt":"Finally, after a very exhausting week of long hours, lots of work and unpacking, the beer cellar is setup in its new location. The cellar has kept at 55F all week (which is awesome!), the door is pretty concealed and has a security code handle + electronic deadbolt. The beer\u2026","rel":"","context":"In "Cellaring"","block_context":{"text":"Cellaring","link":"https:\/\/adamchandler.me\/blog\/category\/beer\/cellaring\/"},"img":{"alt_text":"Beer Cellar - 2014","src":"https:\/\/i0.wp.com\/farm3.staticflickr.com\/2933\/13985950601_39ede82642_z.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1269,"url":"https:\/\/adamchandler.me\/blog\/2013\/01\/20\/cellaring-a-proper-cellar-teaser\/","url_meta":{"origin":7649,"position":5},"title":"\u2605 Cellaring: A Proper Cellar (Teaser)","author":"Adam Chandler","date":"January 20, 2013","format":false,"excerpt":"The unpacking of my beer is going very well. Better photos to come once things are finished. \u00a0","rel":"","context":"In "Cellaring"","block_context":{"text":"Cellaring","link":"https:\/\/adamchandler.me\/blog\/category\/beer\/cellaring\/"},"img":{"alt_text":"Half of the beer cellar (different view)","src":"https:\/\/i0.wp.com\/farm9.staticflickr.com\/8469\/8394256158_dbaab4ac35_z.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/farm9.staticflickr.com\/8469\/8394256158_dbaab4ac35_z.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/farm9.staticflickr.com\/8469\/8394256158_dbaab4ac35_z.jpg?resize=525%2C300&ssl=1 1.5x"},"classes":[]}],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/adamchandler.me\/blog\/wp-json\/wp\/v2\/posts\/7649","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adamchandler.me\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adamchandler.me\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adamchandler.me\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/adamchandler.me\/blog\/wp-json\/wp\/v2\/comments?post=7649"}],"version-history":[{"count":0,"href":"https:\/\/adamchandler.me\/blog\/wp-json\/wp\/v2\/posts\/7649\/revisions"}],"wp:attachment":[{"href":"https:\/\/adamchandler.me\/blog\/wp-json\/wp\/v2\/media?parent=7649"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adamchandler.me\/blog\/wp-json\/wp\/v2\/categories?post=7649"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adamchandler.me\/blog\/wp-json\/wp\/v2\/tags?post=7649"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}