One of the design objectives guiding awe.sm’s new web tool has been reducing the amount of work you need to do on your own in a spreadsheet. Marketers already spend too much time wrestling with data, when what we want are insights.

That being said, sometimes you need the raw numbers, so we’ve got your back. In addition to awe.sm’s live Google Spreadsheet tool, starting today you can export the data from any awe.sm module directly into a CSV for slicing and dicing in a spreadsheet application.

After you’ve used our query builder and explorer to save a module displaying the data you need, export in two easy steps.

  1. Mouse over the module’s title to reveal a gear icon, and select Export:Exporting an awe.sm module, step 1
  2. In the Export dialog that appears, ensure the option for Download is selected, then click the Get CSV icon.export awe.sm to CSV, step 2

Your browser will begin downloading a CSV file. Save it to your local drive, and open it into your favorite spreadsheet app.

exporting awe.sm data to CSV, step 3

A Few Notes

  • This feature is available to every awe.sm user once you switch over to our new version. (There are so many reasons to make the switch. Try it now!)
  • INTERNET EXPLORER USERS: If you’re having trouble getting the file you’ve downloaded to open into Excel, try manually adding “.csv” to the end of its filename.
  • If you really do have a “favorite” spreadsheet application, you almost certainly need a vacation.

Happy crunching! And never forget: if you have any questions or feedback, you can find ushere.

*Originally published on the awe.sm blog.