Election visualizations linked to Google Sheets

Step 1
Start with a dataset that you want to visualize. This table shows the distribution of seats in the EU Parliament from 2009 to 2024. Let's say you would like to visualize this data set with Flourish and automatically update it using the Live CSV function.

Step 2
In order to be able to use the table with the Flourish Live CSV feature, we have to publish it first: Click on “File” in the Sheets menu. Continue with clicking the “Publish to web” tab. A new window should open.

Step 3
For the visualization of the EU parliament, to be available in Flourish we need to link the Google Sheet to Flourish

Step 4
In order to use the Live CSV feature in Flourish, the Google Sheet needs to be published as a CSV file. To publish the sheet as a CSV, click on the drop down menu on the right and choose the option “Comma-separated values (.csv)”.

Step 5
There’s another drop down menu called “Published content & settings”. To keep the data up to date, click on the box “Automatically republish when changes are made”.Click “Publish”.

Step 6
Copy the link to use it in Flourish later on.

Step 1
Go to Flourish: Choose a visualization that you would like to create using the Live CSV feature. Open the visualization and click “Data”. You will see a drop down menu on the right.

Step 2
Click on the drop down tab and choose between “Upload data file”“Upload and merge”and “Import from URL”.To use the Live CSV function, select “Import from URL”.

Step 3
Paste the Google Sheet URL and click "Import".

Step 4
Your sheet should be linked to your Flourish visualization now.The data sheet will look greyed out. There will not be an option to edit the values in Flourish.

Step 1
To make changes to the visualization, first you have to unlink your Google Sheet from Flourish temporarily. Go to your data sheet in FlourishClick “Unlink and keep current data”The grey overlay should disappear afterwards. You can start editing your visualization now.

Step 2
First, switch from “data” to “preview”To make sure the correct values are being displayed in the visualization, go to “Select columns to visualise” and pick the columns you would like to be used in the parliament chart.In this case, you need columns B to E to visualize the seats correctly.

Step 3
The number of seats in the parliament chart can be adjusted in Flourish. In 2009, 764 members were elected The European Parliament. Go to “Parliament Layout”Change the number of seats.

Step 4
To adjust the colors in the visualization: Switch from “data” to “preview”Open the tab “Colours”Choose a preset design or customize displayed colours

Step 5
A custom color palette is available too: Click into the field “Custom overrides”Put in a value, separate it with “:” and follow up with a colourExample: S&D: red

Step 6
To use special color hues, use Hex Colour Codes.

Step 7
Reconnect the Google Sheet to Flourish after finishing the customization. Go back from “preview” to “data” Click the drop down menu on the right and repeat the import process with your Google Sheet.The visualization will be automatically synchronized with the Google Sheet again.

Step 8
This is the finished visualization! To update the seats in the European Parliament after the 2024 election, add the numbers in your Google sheet and Flourish will update your visualization. Click here for finished example