NOTE: Certain information in this article may be missing or out of date. We are in the process of updating the content.
Overview
You may have files with data you want to visualize stored on your computer. You can upload these files to Grow and use the platform to create visualizations, just as you would with data from any other data source.
How to Connect
There is no authorization required for this connection. When creating a new dataset or adding a report to a metric, simply search for "Excel/CSV Upload" in the list of connections and then either drag in the file or click to choose your file to upload.
Please note, the files uploaded from this connector will not dynamically update.
Endpoints
The file upload interface is unlike most other integrations in that there aren't any specific endpoints to choose from. You'll simply upload the files that you want to use to create your metrics, and Grow will pull data directly from those files. Please note, the files uploaded from this connector will not dynamically update.
FAQs + Tips and Tricks
File Uploads are Static Reports
Each time you wish to update a metric build on a file upload, you have to upload the file again. If there is a potential that the data in a file upload will ever update, we strongly recommend you use Dropbox, Google Sheets, or OneDrive.
To Delete an Uploaded File
To delete a file, select "Excel/File Upload" as the data source and click on the list of files you've uploaded. Hover over the name of the file you'd like to delete and click on the "X" at the far right.
Format Your Files to Use in Grow
Make sure your spreadsheets are formatted well so you can easily use them in Grow. This help article gives some pointers on preparing spreadsheets.
One Sheet per Report
For Excel-based files, you can select 1 sheet at a time. So if you have an Excel doc with multiple sheets, you need to create a report for each sheet.
Uniquely Named Headers
If there isn’t a unique column header in your chart, you will have difficulty using Grow’s transform tools as we wont know which columns to filter, group, pivot, etc.
Size Limits
Most files must be smaller than 15 MB in order to successfully pull them into Grow. Under some extenuating circumstances, our support teams can make exceptions for files up to 50 MB.
Supported File Formats
XLS, XLSX, XLSM, and CSV. If you're looking to use JSON or XML files, Grow can pull those in, but we suggest converting to a CSV first.