Hurree Academy

Uploading a CSV from Google Sheets

Niamh McGlade
Niamh McGlade
  • Updated

You can easily download your spreadsheet from Google Sheets as a CSV file. Below we have detailed how to download your spreadsheet as a CSV and upload this to Hurree.

 

Preparing Your Google Sheet

Before converting your Google Sheet to a CSV file, it's 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 how best to format your spreadsheet for Hurree which we recommend reviewing before exporting to CSV.

 

Saving Your Google Sheet as a CSV File

Once your Google Sheet is ready, follow these steps to save it as a CSV file:

  1. Open your Google Sheet.

  2. Click on 'File' in the menu bar.

  3. Select 'Download' from the dropdown menu.

  4. 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.

 

Uploading to Hurree 

  • Once you have selected Table (Input/CSV), click the upload CSV button at the bottom of the screen.
  • You will first need to select whether your spreadsheet includes columns and row headers, then you can simply drag and drop your CSV or upload from your files.
  • This will immediately populate on the table above which you can then edit and add additional information before adding to your dashboard.

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.