Skip to main content

Uploading a CSV from Google Sheets

Niamh McGlade avatar
Written by Niamh McGlade
Updated this week

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:

  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.

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.

Did this answer your question?