Follow these step-by-step instructions to prepare your data via a CSV or Excel file.
This is part one of three guides:
Preparing your data
Please read the directions on this page carefully. Then, download the OS Hub Data Template (see buttons below) to prepare your data. The facility data points you are able to upload are:
- country (required)
- name (required)
- address (required)
- sector/product type(s) (highly recommended)
- facility/processing type
- number of workers (raw values or ranges accepted)
- parent company
Deluxe Embedded Map Users: If you have signed up for a Deluxe Embedded Map, you will receive a custom template with any additional data points you may have requested. Please use that template and follow the accompanying instructions to prepare your data for upload.
When you upload your list to Open Supply Hub, our team will run a quality check on it before accepting it into the system. We are constantly working to maintain a balance between making it easy to share data, and preserving a high level of data quality, so that the data in the tool is as useful as possible.
Follow the tips below to help us collectively raise the quality of supply chain data available for anyone who needs it:
Please include cities and zip/postal codes in the address cell, if you have them.
OS Hub accepts facilities throughout all tiers of the supply chain, but does not accept home addresses. If you have a facility you believe is also a person's home, please do not submit it to Open Supply Hub.
Do not change the column heading titles in the first row. The wording must be exact for our system to process them.
If you don't have data for a particular data point, please leave the column or cell blank. Do not enter N/A or other filler text.
All fields in your list must be in English.
Country names must be translated into English in order to be recognized by the system. OS Hub uses ISO country names for geocoding and processing.
Please deduplicate your list. The OS Hub algorithm will check whether the facilities in your list already exist in OS Hub and match them accordingly. However, the algorithm will not remove duplicates within your list. Therefore, we ask that you remove duplicate facilities from your list before uploading.
Ensure your facility names and addresses have fewer than 200 characters in a cell.
File size limit: 5MB
Save your file as an Excel file (.xlsx) or as a CSV UTF-8 (.csv). Excel is preferred, if accessible to you.
If you are uploading multiple entries in one cell (like multiple product types), those entries must be separated by a vertical bar. For example: if entering pants and socks as product types for a facility, enter them as: pants|socks
- If you are currently using commas to separate those items, here are some quick steps you can follow in Excel to replace them with vertical bars:
Click on the column letter to select the entire column you’re working in
Select the Edit menu --> Find --> Replace
Find what: enter the comma AND the space [, ]
Search: By Columns
Replace with: |
Find next (to test your replace command and it will jump down to the next cell with a comma & space to be replaced)
Replace All (this will replace all of the commas within that particular column)
Repeat for any other columns that have multiple items.
Separate your plots/units/buildings. Please only upload one plot/unit/building per line in your upload. This way, our algorithm and moderation team can easily match entries unit by unit.
Please do not use quotation marks and en dashes (—) in your file.
Remove P.O. Box and Police Station Data: Some facility addresses will include details about a P.O. Box (PO) or local police station (PS). These details may disrupt the geocoding process and it is best practice to remove them from your address field. This will primarily affect facilities located in India.
If you used Excel formulas while preparing your data, consider copying your final dataset into a new sheet and pasting [only values] to avoid formula errors affecting your data.
Additional notes on two data points:
- Values for sector are grouped with values for product type (e.g. in the upload template you’ll notice that the column name is sector_product_type).
- Open Supply Hub has a set list of supported sector values; any values uploaded in the sector_product_type field that match values on the OS Hub sector list will be listed under the sector heading on facility profile pages. All other values uploaded in the sector_product_type field will be listed as product type values. There can be multiple sector values and multiple product type values uploaded for each facility. Remember that you must use the vertical bar character (“|”) to separate discrete values when uploading. In the case where multiple values are uploaded without proper formatting, our team may reject your list and ask that you re-upload with correctly formatted fields.
- All facilities without a value matching one of the identified sector values will be assigned the value of ‘Unspecified’ for sector. These are the sector values that are currently programmed to be supported in Open Supply Hub. Note that our team will be routinely updating the list of sector values and the logic for this field as new data is uploaded. As OS Hub expands, and the system’s understanding of sector and product type relationships improves, new versions of the algorithm and underlying display logic will be released to better reflect this understanding.
- Note for Former Open Apparel Registry Users: Even if you are only uploading apparel facilities to Open Supply Hub, please consider adding "Apparel" to this column, so your facilities can be categorized as such.
Facility Type/Processing Type:
- For apparel facilities: You will note that facility and processing type are merged into one column in the upload template (if you have questions about what constitutes a processing and/or facility type, please consult our Facility Type Taxonomy). In this column, you may upload all processing activities that you have confirmed occur at a particular facility, which will appear as the Processing Types for each facility in OS Hub. OS Hub then sorts those values into searchable Facility Type categories, which will appear as the Facility Type in OS Hub.
- For non-apparel facilities: In the initial release of OS Hub, there are no defined values for processing type and facility type for facilities outside of the apparel sector. As more data is collected for non-apparel sectors, the logic for these fields will be built out to behave as they do for apparel facilities. You are welcome to submit any processing type data you have for your facilities.
Example Data: Before and After
Want an example to follow? Here's a quick sample of how to resolve some of the most common formatting issues submitted to OS Hub.
Note: Want to divide up your lists? OS Hub allows users to filter by list. This means that the name of your list will be publicly displayed. This can be useful if you are looking to separate your facilities in a particular way - like by tier, program, certification, etc. If you want to have more than one list, create and upload a separate CSV/Excel file for each list you want displayed.
Uploading your data
Once you have prepared your file(s), according to the above instructions. Move on to uploading your data.