Excel (and Google Sheets) Tools
Excel Export Transformer
We really don’t love to see you (still) creating lots of spreadsheets, but we also want to make it easy for you to still use Excel, as we understand it helps to get data here and there. We would love to know why you are using Excel though, so make sure to let us know so we can potentially save you additional time by offering a WaterClick partner or connection to wherever you’re headed with that data.
The Macro-enabled Excel tool below will convert your downloaded Waterly CSV report data from the “long format” (friendly to most computer systems and databases) to a “wide format” more suitable for use by a human in Excel. You will have to “Trust” the Excel Macro file once you open it so that it can run its (safe) code to transform your CSV data from a “long” format to a “wide” format.
See our Help Desk article entitled ”Converting exported CSV "long format" to human-friendly Excel format” for a step-by-step guide with screen shots.
v1.1.1
Excel Import Template
We love to import data! So much so, we don’t charge for it if you do some homework ahead of the import.
This downloadable template will allow you to see how we format data before we import. You’ll have to reach out to a create a Waterly Support Ticket to get a copy of your Waterly data model, but once you have the structure of your data, you have to let us know what data you want imported and prep it (clean it up a bit) to make it easy for a machine to import.
You’ll want to see our Help Desk article entitled ”Importing Data to Waterly” for a step-by-step guide to help you get your data ready for the Waterly machine!
v1.3