Having trouble pulling a spreadsheet into Grow? Sometimes spreadsheets have extra information that is not part of your data set. In order for it to pull into Grow without issues, we need to do a little extra formatting. This applies to spreadsheets in Dropbox, Box, File Uploads, Google Spreadsheets, or FTP connections.
There are a few basic principles to formatting spreadsheets:
- Google Sheets cannot have a colon in the name of the spreadsheet. This will return the error "totalRowCount Undefined."
- Column headers belong in the top row (row 1).
- All column headers need to be unique.
- There cannot be empty rows or columns.
- Dates should be in YYYY-MM-DD format.
- Currencies should just be number values.
- Categories and values need to be consistent. For example, if you have a column describing what Olympic medal an individual won, keep the values to "GOLD", "SILVER" and "BRONZE". Do not put 'GOLD', then 'FIRST' or 'Winner' or another variation.
- Keep the font consistent, the data should attract attention, not the font or colors.
Here is a well formatted spreadsheet, compared to a less well formatted spreadsheet.
Here is another picture of what the ideal spreadsheet should look like:
Cleaning Up A Spreadsheet
Have a spreadsheet that you need to clean up? Here are some steps you can follow:
First, pull your spreadsheet into a program that allows editing. If you download the data, download it as a CSV file. Alternatively, you could upload it to Google Sheets to modify the spreadsheet.
In the example here, we exported the data from Google Analytics.
Next, delete the rows with unnecessary information.
Your data should then look like this. You can see the headers are in row 1, there are no extra spaces or columns, and the dates are formatted correctly.
Pulling the spreadsheet into Grow will then be as smooth as butter.
Questions? Email us at firstname.lastname@example.org or chat in on the site.