Here's a quick example of how some sample facility data looked before and after it was prepared for upload to OS Hub.
As you are working through the guide for preparing your data for OS Hub, please refer to the below example for some formatting best practices.
Before
In the below screenshot, the following formatting will need to be amended:
- Headers do not match the provided template
- City and zip code are in separate cells
- Product types are separated by a comma
- Where there was no data, N/A has been entered
After
- Headers from OS Hub templates have been used
- The full address has been concatenated into the address cell
- Product types have now been separated by a vertical bar and relevant sectors have also been added
- For cells where there is no data, they are left blank
If you have any questions, please don't hesitate to reach out to info@opensupplyhub.org.
