Follow

How to format your CSV file

If you are uploading your stock using a CSV file you must ensure that the file is formatted correctly. 

For common mistakes made with formatting check out this article: 

Organise your stock data into three columns:

Column A: Unique stock reference numbers (often known as a UPRN) or stock references. Each row of data must have a unique number. So if you have a postcode multiple times, each postcode will also have a unique number to differentiate it from the other rows containing the same postcode

Column B: Postcodes – these are used to place the stock on the map

Column C: Stock types – the stock type for each piece of stock. You can have up to thirty different types (E.g. rented, owned, community centre) 


Column D: THIS IS OPTIONAL: Organisations- The organisation feature is not switched on as default. Please email support@ocsi.co.uk if you would like us to enable this for you. Check out this article for information on using organisations: Organisations

 

Below is an example of a correctly formatted CSV: 

 

Please note: The columns must be ordered in the above format and cannot be customised even slightly.

If simply uploading your stock with no stock types then if you do not assign your stock with UPRNs, Community Insight will automatically do this for you. You can view your new UPRNs by ‘downloading a file containing all of your properties'  

However, if you are uploading stock with stock types, you have to include UPRNs yourself.

If you are experiencing problems when trying to upload your stock data 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