Exporting Data
CellarTracker is designed so that any data you enter can always be exported. In fact, we recommend you regularly export your own data and save a copy for backup purposes, just in case you need to check the state of your cellar at any point in the past (CellarTracker does not maintain any historical transaction records). You can export data directly from the website to CSV or text format, or for those who are looking for more advanced options, you can also manually download to XML, HTML, tab-delimited text, or comma-separated text (CSV).
In this article
Exporting from the Web
Exporting from the web interface is very easy. Simply go to the view of the data you'd like to export (e.g., My Cellar), and click the Export button in the top right.
That brings up the export dialog, which allows you to choose the columns you'd like to include in the export.
Please note that the export feature is only exposed in our full desktop website, and it is not exposed in our mobile app/website. The list of available columns is dependent on the underlying view you are on. For example, when on the Wines view of My Cellar, location and bin are not included; if you switch to Individual Bottles view, then location and bin will be included.
Simply choose your desired columns and format, and click the Export button to download the data. The last set of columns for each view are remembered for subsequent exports.
Choosing Data to Export
When exporting from the web interface, the underlying view you are on determines what data and columns are available to export. Certain columns, such as location and bin, are only available when the underlying view is bottle-based (i.e. one bottle per row). Here are some examples of the types of data you may want to export, and the underlying view you need to be on to get that data:
- Location and Bin: Go to My Cellar and then switch into Individual Bottles view. The output will contain one row for every bottle in your cellar, which includes the location and bin values.
- Cellar contents (aggregated): Go to My Cellar and then switch into Wines view. The output will contain one row for every wine in your cellar.
- Purchase history: Go to My Cellar and then change the drop-down to Purchased. The output will contain one row for every purchase you've made.
- My wine history: Go to My Cellar and then change the drop-down to All Wines. The output will contain one row for every wine that you have attached data to, meaning wines you've previously had in stock (but since consumed), wine's you've added tasting notes for, etc.
Exporting Manually
If you'd prefer to use another tool for format to access your data, CellarTracker also supports the ability to export to XML, HTML, tab-delimited text, or comma-separated text (CSV) via specially crafted URLs. This is the same underlying functionality available in our WebQuery file.
Constructing the URL
The base format for the export URL is as follows; please replace your_handle with your handle, and your_password with your password. Then, append the appropriate additional URL parameters as described in the following sections.
If you paste these URLs into a browser that is logged in to your CellarTracker account, you can omit the User and Password parameters as these are automatically transmitted via Cookies.
https://www.cellartracker.com/xlquery.asp?User=your_handle&Password=your_password
Choosing a Format
The Format parameter determines the format of the output. By default, the export format is HTML.
| Value | Description |
| html | HTML output (default if not specified) |
| xml | XML-based output |
| tab | Tab-delimited text |
| csv | Comma Separated Values |
Choosing the Data
The Table parameter determines what data is exported. The possible values are as follows:
| Value | Description |
| List | Wine Summary (see note below) |
| Inventory | Individual Bottles |
| Notes | Your Tasting Notes |
| PrivateNotes | Your Private Notes |
| Purchase | Your Purchases |
| Pending | Your Pending Purchases (Futures) |
| Consumed | Your Consumed Bottles |
| Availability | Ready to Drink (Drinkability) report |
| Tag | Wishlists |
| ProReview | Your manually-entered Professional Reviews |
| Bottles | A special raw view showing all bottles with a BottleState parameter (-1 for pending, 1 for in-stock, 0 for consumed) |
| FoodTags | Your food pairing tags |
The Wine Summary (List) table, by default, does not include location or bin information. However, it can be included if you add an additional URL parameter named Location=1.
Example
To export your wine summary, with locations, in CSV format, use the following URL:
https://www.cellartracker.com/xlquery.asp?User=your_handle&Password=your_password&Format=csv&Table=List&Location=1
To export your tasting notes in XML format, use the following URL:
https://www.cellartracker.com/xlquery.asp?User=your_handle&Password=your_password&Format=xml&Table=Notes