Front Page | Recent Changes | Title Index | HelpCellarTracker makes it easy for users to download a copy of their cellar to an Excel file. 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).
Open this spreadsheet and go to the first tab: LOGIN
Enter your CellarTracker handle and password in the provided spaces. (You will only need to do this once.)
You may have seen a prompt (shown below) when loading the file about enabling external data refresh. Depending upon how you answered the sheet may (not) already be downloading as soon as you update the handle and password.
If not, please bring up the EXTERNAL DATA toolbar and click the REFRESH ALL button shown below. (If the toolbar is not showing then RIGHT-CLICK on any other toolbar and choose External Data from the list.)
Troubleshooting
My sheet doesn't seem to be updating, what can I do?
Are your handle and password correct on the LOGIN tab? (Note that your handle is not usually your email address.)
Have you pressed the REFRESH ALL button shown above?
Double-check your firewall and anti-virus software to ensure that it allows Microsoft Excel to access the Internet.
Other Frequently Asked Questions
Q: How can I see Location and Bin information in the Excel download? A: There are two ways to get at this.
Either switch from the WINE LIST tab to the INDIVIDUAL BOTTLES tab.
Set a non-default option to cause the WINE LIST tab to include Location and Bin columns. Switch to this tab and click into the first or second row of data. Click the QUERY PARAMETERS button on this toolbar.
Click on the Location parameter and set a value of 1 as shown below.
Q: Can I enter information in Excel and have it update the main CellarTracker site? A: Sorry, the Excel spreadsheet is a one-way download.
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.
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
Launch a supported web browser (Safari will NOT work)
Enter the desired URL for your query (see Creating and Editing CellarTracker Web Queries below) with your login and password
Once the web page loads, do a Select All (command A) and Copy (command C) all the contents of the query.
Launch Excel and open an existing or create a new worksheet
In a new worksheet, do a Paste (command V) to insert the previously copied web page
Excel will paste the tab-delimited contents correctly into columns as desired. Save the worksheet.
