You can easily download your spreadsheet from Google Sheets as a CSV file. Below, we have detailed how to do so and upload it to Hurree.
Step 1: Preparing Your Google Sheet
Before converting your Google Sheet to a CSV file, it is important to ensure your data is properly organised. Here are some tips:
Keep your data in plain text format. CSV files cannot process Google Sheets formulas or formatting.
Avoid using commas in your data, as CSV files use commas to separate cells. If your data must include commas, consider using a semicolon (;) or tab-separated CSV file.
We have created a best practices article on formatting your spreadsheet for Hurree, which you should review before exporting to CSV.
Step 2: Saving Your Google Sheet as a CSV File
Once your Google Sheet is ready, follow these steps to save it as a CSV file:
Open your Google Sheet.
Click on 'File' in the menu bar.
Select 'Download' from the dropdown menu.
Choose 'Comma-separated values (.csv, current sheet)' from the options.
Your browser will now download the current sheet as a CSV file. If your workbook contains multiple sheets and you want to save each one as a separate CSV file, you'll need to repeat this process for each sheet.
Step 3: Uploading to Hurree
Once you have selected Table (Input/CSV), click the upload CSV button at the bottom of the screen.
First, you will select whether your spreadsheet includes columns and row headers, then drag and drop your CSV or upload it from your files.
This will immediately populate the table above, which you can then edit and add additional information before adding to your dashboard.