Follow

How to format your CSV file

If you are uploading your services 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 service data into three columns:

  1. Postcodes – these are used to place the service on the map;
  2. Unique service reference numbers (often known as a UPRN) or service 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.
  3. Service types – the service type for each service. You can have up to thirty different types (E.g. library, school, GP) 
  4. 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 services with no service types then if you do not assign your services with UPRNs, Local Insight will automatically do this for you. You can view your new UPRNs by ‘downloading a file containing all of your services'  

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

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