The easiest way to export to Excel is to click MY CELLAR and then look for the EXPORT button at the upper right. The site will let you choose which records and which columns to export and whether to download as text or CSV.
Alternatively, there is also a legacy Excel tool you can download. This acts like a standalone application in that you feed it your CellarTracker handle and password, and then it can be refreshed to grab a copy of the latest data from your CellarTracker account. This is useful as a personal backup, for offline access (on a plane or to sync to a handheld device), and for deeper analysis using the rich tools in Microsoft Excel. Or for those without Excel, you can also download to XML, HTML, tab-delimited text, or comma-separated text (CSV).
My sheet doesn't seem to be updating, what can I do?
Q: How can I see Location and Bin information in the Excel download?
A: There are two ways to get at this.
Q: Can I enter information in this Excel spreadsheet and have it update the main CellarTracker site?
A: Sorry, the Excel spreadsheet described here is a one-way download and not a two-way sync tool. That said, if you are wondering how to import an existing Excel spreadsheet into your CellarTracker account, please read about Bulk Import.
Q: Can I use spreadsheets other than Microsoft Excel?
A: We are not aware of other spreadsheet which support the Web Query feature that allows Microsoft Excel to automatically pull data from the web. That said, CellarTracker simply exposes tabular views onto different aspects of your cellar data, so you could easily copy and paste this from your web browser into OpenOffice or other spreadsheet software. Or using the information below, you can export XML, tab-delimited text or CSV text.
The URLs available for web queries are:
By default the export format is HTML. You can append &Format=xml or &Format=tab or &Format=csv in order to change the output format. Note that if you paste these URLs into a browser that is logged in to your CellarTracker account, you can omit the User and Password variables as these are fetched via Cookies.
Wine Summary (without Location):
Wine Summary (with Location):
Your Tasting Notes:
Pending Purchases: (Futures)
Professional Reviews (user entered):
Unlike Excel for Windows, Excel for Mac OS X does not allow you to edit an existing web query embedded in a spreadsheet. If you wish to create or edit your own CellarTracker web queries, you can download the free Web Table Report tool from the University of Buffalo that offers an easy way to create and edit Excel web queries with Excel for Mac OS X.
There have been reports of issues downloading data to Excel v.x (while Excel 2004 works well). If you run into this, you will need to manually copy and paste web queries from a supported web browser into an Excel v.X worksheet.
Supported Browsers: Internet Explorer 5.2 or later, Firefox 1.0 or later, Camino 0.8 or later. NOTE: Safari is NOT SUPPORTED due to text handling issues with tabs
To create an offline copy of your cellar Excel v.X for Mac OS X
Update 2010.01.04: Based on my tests, the web query Excel file (https://www.cellartracker.com/webquery.xls) works well with Microsoft Excel 2008 for Mac, the latest version of Excel for Mac. For me, it works as advertised with the following change: the "Refresh All" option doesn't occur, so instead, place your cursor in the first cell of each sheet (for example, cell A2 of the Tasting Notes sheet) and select Refresh Data from the Data menu. This will populate the spreadsheet with your online data. Repeat this step for each sheet.
Update 2010.04.29: It works very well on Microsoft Excel 2008 for Mac. Actually, unlike the above user, "Refresh All" works just fine. Try it.
Update 2010.05.31: I'm the person who posted the "2010.01.04" update, and I can confirm that the "Refresh All" method works, as reported above in the "Update 2010.04.29" post. Excel 2008 does not automatically load the required "External Data" toolbar, which houses the "Refresh All" button. The Step 5 in the directions at the top of the page address this issue for Windows versions of Excel, and the directions hold true for Excel 2008 for Mac as well. I missed this the first time. To reiterate: open the toolbar by going to View>Toolbars>External Data in the menu bar at the top of your desktop. Clicking the Refresh All button will populate all Excel tabs with the latest data on CellarTracker.