To successfully upload a CSV file to Hurree, you must ensure that your original spreadsheet is formatted correctly. Below we have outlined some guidance on how to format your spreadsheet.
Note: You don’t need to include columns and rows in your table, but if you choose to include them, you can easily edit them after uploading if you notice minor misplacements.
Column Headers
Column headers are used to label the type of data in each column. They should be the first row in your spreadsheet. Here are some best practices for formatting column headers:
Each header should be unique and clearly define the data it represents.
If you're uploading user data, use clear, concise header names. For example; your headers might include "User_ID," "First_Name,"" Last_Name," "Email," etc.
Avoid using special characters or spaces in your headers. Stick with letters, numbers, and underscores.
Remember, each column represents a different data field, so the headers should reflect this.
Row Headers
Row headers are not necessary in CSV files. However, each row in your spreadsheet should represent a unique record or unit of data. The cells in each row should contain the data points corresponding to the column headers above. Here are some tips:
Ensure that each row has the same number of data points as there are column headers. Missing data can lead to misalignment in your table or errors.
For numeric data, ensure that the format is consistent across all cells. For example, if you're recording time on a task, decide whether you're using minutes or hours and stick to it throughout.
Below, we have included an example of a well-formatted and poorly formatted spreadsheet to help you.
Well-formatted
Poorly Formatted
If you are having difficulty uploading your CSV and can’t understand why, please contact a member of our support team.