We use cookies. You have options. Cookies help us keep the site running smoothly and inform some of our advertising, but if you’d like to make adjustments, you can visit our Cookie Notice page for more information.
We’d like to use cookies on your device. Cookies help us keep the site running smoothly and inform some of our advertising, but how we use them is entirely up to you. Accept our recommended settings or customise them to your wishes.
×

Data Studio 101: Data Import via File Upload

As Google releases another new connector for Data Studio, we show you how to upload CSV data from almost any source with Data Studio’s File Upload.

Why you should care

Keen followers of Data Studio 101 will know how excited we get when Google release a new data connector for Data Studio, and this is no different. 

There was already a comprehensive set of connectors which allowed you to link directly to a data source (Google Sheets, MySQL, etc.). But what if you needed to analyse over a large set of existing or historical data?

How you should do it 

Previously, a commonly used solution was to import a CSV data set into a Google Sheets document, and subsequently set that as a data source. However, this was often cumbersome and added unnecessary steps to performing simple visualisation tasks. This has been hugely improved with the addition of the ‘File Upload’ connector. You can now create ‘data sets’, which allows you to upload multiple CSV files to a single data source using a simple drag & drop interface:

File upload interface within Data Studio

You can upload up to 100MB of CSV data to the Google Cloud Platform per data set, which will then be accessible as a data source across your reports. This data source will be shareable (like any other in data studio), but only you will have access to the raw data set:

Uploaded data sets - summary

Dimensions & metrics analysed from data set

Once uploaded, Data Studio will analyse the data to break it down into Dimensions & Metrics to use in your report. It’s from here where you can also add your own calculated fields using Data Studio’s set of available formulae.

 

How we can use the data

Once your fields have been analysed, you’ll be able to use your CSV data as you would any other data source. Although data source joining is not yet a feature in Data Studio, you can add multiple data sources to your report to provide context to other underlying data such as Google Analytics, such as the data below:

Graph showing a visualisation of a sample data source (Internet upload speeds by local authority).

(Data source: Ofcom (published under Open Government Licence v3.0))

Considerations & Limitations

There are a few considerations to make when importing data via File Upload, but these shouldn’t cause much of an issue for most data sets. Current limits stand at the following:

  • 1000 data sets per user
  • 2GB total storage per user
  • 100 uploads per data set per day
  • 100MB file size limit per data set

You should also ensure that your source file is in a valid format, such as using commas as a delimiter to separate entries and line breaks to separate rows, but most platforms which allow data to be exported as CSV will handle this automatically. 

If you are looking for support or just some advice on Data Studio 360, please get in touch with our experts. 

Join the Discussion