In this release, we’ve added some features around pulling and refreshing data from Salesforce along with a handful of enhancements.

  1. You can now transpose rows to columns when pulling or refreshing reports and SOQL queries. To enable this, check the Transpose columns to rows checkbox under Options:
  2. You can now define a cell in your workbook that will be updated with the last refresh date for reports and SOQL queries. You can use a cell address on the same worksheet (e.g. A10), a cell address on a different worksheet (e.g. Sheet1!A10), or a named range here:

  3. When pulling data via SOQL, you can now have field labels instead of API names as headers when Show object and field labels instead of API names option is checked: