We’ll concede we have underestimated the importance you place on data downloads. Looking at the voracious rate of download requests, we feel you deserve much better downloads that what we have been providing so far.
We have today deployed the first of the ‘New Style’ downloads. The new style has the following characteristics:
- Native .xlsx Excel file format (if you need a CSV instead, you can always generate it yourself from the Excel file)
- Proper, meaningful, bolded heading labels, not just field names
- The labels row is static, so you can scroll down and still see the headings
- All columns feature a column filter
- The columns are automatically right-sized to show all their content
- Proper Excel-compatible dates, responding to the local settings in your country
- Currency fields formatted as numbers, with an Excel currency format rather than a string with the currency label. This means you can now perform arithmetic calculations on numeric fields without having to first search and replace currency symbols.
The first download to be styled is the Orders download. We have taken the opportunity to add some fields to the orders download which will allow us to publish a temporary solution which provides an order heatmap (details later today or tomorrow)
We currently offer 54 different downloads and we will be styling these over time.