Follow

Step 3a: Upload data using the upload spreadsheet tool

You have chosen to upload your data using the Upload Spreadsheet tool. In order to upload a spreadsheet you will need an Excel or CSV file containing data matched to postcodes. 

2022-08-26_16-26-10.jpg

Choose your file using the select file button and then click the Upload button 

2022-08-26_16-31-35.jpg

This may take up to a minute to upload.

Once it is successfully uploaded you will see a green box prompting you to click next

Don't worry if you have more columns of data than you need for your upload. You will be able to tidy the columns so it is compatible for import:

  1. 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.   
  2. Next, tidy up your columns. You can only upload two columns of data. A column containing postcode data and a column containing a piece of numeric data. If you have other irrelevant columns you can select to ignore them. 
  3. Once this is complete select next step 

2022-08-26_16-41-57.jpg

Preview the data and once happy with it select:   2022-08-26_16-18-34.jpg

Depending on the size of the dataset, this may take some time to upload. On average, Community Insight takes 4 minutes per 8000 rows. 

Once imported, you will be redirected back to the Manage Data page. To view your custom dataset on the map check out this article: 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.

Can't find what you're looking for?

Contact Us