You have chosen to upload your data by uploading a spreadsheet. In order to upload a spreadsheet you will need an Excel or CSV file with a column of locations (suburbs, postcodes, LGAs, SA3s or SA2s) and column of data. Don’t worry if you have extra columns. In the spreadsheet below the blue columns are the ones we’re using, but we can upload the whole thing and choose our columns later.
Click Upload spreadsheet.
Choose your file using the select file button and then click the Upload button
This may take up to a minute to upload.
Once it is successfully uploaded you will see a green box celebrating your success and prompting you to click Next Step.
Now you are able to tidy the columns so it is compatible for import:
- Firstly you must specify which row if any contains the headers for your data and which row contains your first row of data. If you do not have headers then choose 0 then 1.
- Next, specify which columns are relevant. You can only upload two columns of data. A column containing location data and a column containing a piece of numeric data. If you have other irrelevant columns you can select to ignore them.
- Once this is complete select Next step.
Preview the data and once happy with it select Import and Save to Community Insight.
Depending on the size of the dataset, this may take a few minutes, during which you may not be able to browse the rest of the site. But you can go and check your emails in another tab or window without affecting your upload.
Once imported, you will see the image below.
Now you need to activate your dataset. Go to Settings -> Manage Indicators.
Click Unassigned and you should see your new dataset in the list on the right.
Using the little cross to the left of your new dataset, drag it under the right theme. You may need to create a theme first, by clicking ADD THEME.
Then click on the theme under which you put your new dataset. Tick the box for map and, if you like, the dashboard. Remember that more than 10 indicators on the dashboard can get overwhelming, so if in doubt, leave it out!
Now return to mapview by selecting Map on the grey banner at the top. You should see your new dataset listed under its theme when you click Data.