--- title: "Product Impact Calculator: Bulk Upload - Material Workbook" description: "Product Impact Calculator: Bulk Upload - Material Workbook" --- [Skip to content](https://support.worldly.io/hc/en-us/articles/37619915074587-product-impact-calculator-bulk-upload-material-workbook#main-content) English Show submenu for translations [Submit a request](https://support.worldly.io/kb-tickets/new?hsLang=en) [![Worldly logo](https://support.worldly.io/hs-fs/hubfs/Worldly%20Media%20Kit/Worldly%20Logos/Worldly_LogoTM_Red.png?width=250&height=61&name=Worldly_LogoTM_Red.png)](https://www.worldly.io/) Open main navigation Close main navigation - English Show submenu for translations - [Submit a request](https://support.worldly.io/kb-tickets/new) How can we help? - There are no suggestions because the search field is empty. 1. [Help Center](https://support.worldly.io/?hsLang=en) 2. [Products](https://support.worldly.io/products?hsLang=en) 3. [Product Impact Calculator](https://support.worldly.io/products?hsLang=en#product-impact-calculator) # Product Impact Calculator: Bulk Upload - Material Workbook **Table of Contents** - [**Bulk Upload - Material Workbook**](https://support.worldly.io/hc/en-us/articles/37619915074587-product-impact-calculator-bulk-upload-material-workbook#h_01JWSN2F2PC0JMF2W53G2T3BY4) - [**Recycled Materials**](https://support.worldly.io/hc/en-us/articles/37619915074587-product-impact-calculator-bulk-upload-material-workbook#h_01K3HV55876YM78XRBY01F5ZDD) - [**Missing Info and Revising**](https://support.worldly.io/hc/en-us/articles/37619915074587-product-impact-calculator-bulk-upload-material-workbook#h_01K3HV55876YM78XRBY01F5ZDD) - [**FEM Outlier Exclusion**](https://support.worldly.io/hc/en-us/articles/37619915074587-product-impact-calculator-bulk-upload-material-workbook#h_01KME1H5HAQ2QV45SXNS2AFWP6) - [**Workbook Template**](https://support.worldly.io/hc/en-us/articles/37619915074587-product-impact-calculator-bulk-upload-material-workbook#h_01JWSN7J1976WB0Z4SWPAMJRZC) This workbook is only for textiles with a maximum of 4 base materials.   ## **Bulk Upload - Material Workbook** This workbook is only for textiles with a maximum of 4 base materials.   ## **Bulk Upload - Material Workbook Fields** **Field name** **Description** **Material Name (Required)** Name of material or material blend **Material Code** User supplied product identifier **Material Supplier** No FEM linking This optional field is intended to help identify a material. These are Vendors who are not involved in the making of the actual material. They’re the point of contact for the brand when they buy textiles. Example: Vendor ABC in China sold me 50 Cotton/50 Poly blend, and Vendor DEF in Vietnam sold me 50 Cotton/50 Poly blend **Material Country** Select a country from the list **Base Material 1, Base Material 2, Base Material 3, Base Material 4,** **Base Material 5,** **Base Material 6** Select a material from the list **Sustainability 1, Sustainability 2,** **Sustainability 3, Sustainability 4,** **Sustainability 5, Sustainability 6** Enter **Recycled** if the material is recyclable. Leave blank if the material is not recyclable. **Composition 1, Composition 2, Composition 3, Composition 4,** **Composition 5,** **Composition 6** Enter a number between 1-100 when the "Material" field is populated All composition columns must add up to 100% **T2 Facility, T3 Facility** Populated with list of T2 and T3 accounts that have shared a 2023 or 2024 FEM with the brand Supplier Name or Worldly ID If No Match, map to Keep value as is **T2 Country, T3 Country** Select a country from the list **Overwrite** Set to YES when uploading a file that contains revisions to existing materials Contents of MatLib can be exported by selecting one or more materials and clicking Download in the table action bar **Worldly Material ID** Worldly Generated ID for the product **The below fields are automatically pre-populated with the T2 and T3 values, but can be overwritten if the brand has more detailed information. P002-P006 refer to lifecycle stages.** **P002 Facility** **Definition:** Supplier Name or Worldly ID **Automatically Pre-populated:** T3 Facility value **Lifecycle Stage:** Yarn Formation stage (i.e. Spinners) **P002 Country** **Definition:** Select a country from the list **Automatically Pre-populated:** T3 Country value **P003 Facility** **Definition:** Supplier Name or Worldly ID **Automatically Pre-populated:** T2 Facility value **Lifecycle Stage:** Textile Formation stage **P003 Country** **Definition:** Select a country from the list **Automatically Pre-populated:** T2 Country value **P004 Facility** **Definition:** Supplier Name or Worldly ID **Automatically Pre-populated:** T2 Facility value **Lifecycle Stage:** Preparation stage **P004 Country** **Definition:** Select a country from the list **Automatically Pre-populated:** T2 Country value **P005 Facility** **Definition:** Supplier Name or Worldly ID **Automatically Pre-populated:** T2 Facility value **Lifecycle Stage:** Coloration stage **P005 Country** **Definition:** Select a country from the list **Automatically Pre-populated:** T2 Country value **P006 Facility** **Definition:** Supplier Name or Worldly ID **Automatically Pre-populated:** T2 Facility value **Lifecycle Stage:** Finishing stage (e.g. Applying heat transfers, or adding a weatherproofing coating) **P006 Country** **Definition:** Select a country from the list **Automatically Pre-populated:** T2 Country value **T2FacilityRawText, T3FacilityRawText** This is a read-only field that stores the supplier information as part of the PO record, even when no eligible FEM is found during import If a user maps unmatched suppliers to “Keep as is”, the system imports this information to the FacilityRawText field **P002FacilityRawText, P003FacilityRawText, P004FacilityRawText, P005FacilityRawText, P006FacilityRawText** This is a read-only field that stores the supplier information as part of the PO record, even when no eligible FEM is found during import If a user maps unmatched suppliers to “Keep as is”, the system imports this information to the FacilityRawText field ## **Example** Next, let's walk through an example of uploading a Bulk Upload - Material workbook. Download the template at the bottom of this article. 1. Select **Import** **Expand to show screenshot** ![40382507795355.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/40382507795355.png?width=373&height=170&name=40382507795355.png) 2. Select the **Bulk Upload - Material** workbook. **Expand to show screenshot** ![40382550452635.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/40382550452635.png?width=691&height=442&name=40382550452635.png) 3. Drag and drop your file onto the screen. You can upload the following file formats: CSV, Excel, or JSON. We recommend CSV as a best practice. **Expand to show screenshot** ![6.gif](https://support.worldly.io/hubfs/Knowledge%20Base%20Import/37619908679195.gif) 4. Review the field mapping on the next two windows before clicking Continue. **Expand to show screenshot** ![37619908679579.gif](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/37619908679579.gif?width=858&height=564&name=37619908679579.gif) - If a field is missing or incorrect, select the dropdown arrow to select the desired field. - Preview the data for the category on the right side of the window. Hovering over different rows updates the preview window. - Select **Continue.**  5. On the next page, review the **Bulk Upload** table for any errors. **Expand to show screenshot** ![10.gif](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/37619908680475.gif?width=858&height=564&name=37619908680475.gif) 6. After the table has been reviewed and all errors have been resolved, click **Submit data.** **Expand to show screenshot** ![39906802221723.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/39906802221723.png?width=356&height=247&name=39906802221723.png)   ## **Recycled Materials** Use the **Sustainability Attribute** field in the **Material Library** to create recycled materials. PIC will automatically map these materials to the correct Tier 4 recycled processes from MSI when a match exists. Use this feature to model the impact of recycled content of products.   ### **Prerequisites** Before getting started, make sure of the following: 1. Select **Refresh Import Space** on the PIC Dashboard to ensure the new workbooks are updated. ![49395324677019.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/49395324677019.png?width=594&height=125&name=49395324677019.png) 2. During bulk upload, you must have a data file that includes a column indicating which materials are recycled. ![49395331853339.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/49395331853339.png?width=621&height=252&name=49395331853339.png)   ### **Which materials have automatic Tier 4 recycled process mappings?** If a material is not on this list, no recycled process option is available. - Cotton - Nylon - Polyester - Polyethylene (PE) - Polypropylene (PP) - Wool   ### **How does it work?** **Prepare the Upload File** 1. Include “**- Recycled**” in the **Material Name** column. ![49395324678299.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/49395324678299.png?width=503&height=389&name=49395324678299.png) - Recycled material example: **Cotton - Recycled** - Not recycled material example: **Cotton - Conventional** 2. Include a column for the sustainability attribute in the upload file. ![49395331854747.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/49395331854747.png?width=503&height=389&name=49395331854747.png) - If you are uploading recycled material, enter **Recycled** under this column. - If you are not uploading a recycled material, leave the sustainability attribute blank. **Upload and Map Fields** 1. Upload your file [using these instructions](https://support.worldly.io/hc/en-us/articles/37618508429979-Product-Impact-Calculator-Material-Library?hsLang=en#h_01JWSA51RXGEMXYGHJV08KHPR8:~:text=the%20FacilityRawText%20field-,Example,-Next%2C%20let%27s%20walk), and you’ll see an option to map columns to the new **Sustainability Attribute** field. ![49395324678939.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/49395324678939.png?width=584&height=330&name=49395324678939.png) 2. During the value-mapping step, map your **Recycled** values accordingly. ![49395324680219.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/49395324680219.png?width=572&height=302&name=49395324680219.png) **Download Impact Report - Tier 4 Process Assignment** The download reports show the adjusted Tier 4 processes and impact for recycled materials. ![49395324681371.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/49395324681371.png?width=1306&height=408&name=49395324681371.png) [Click here](https://support.worldly.io/hc/en-us/articles/37618508429979-Product-Impact-Calculator-Material-Library?hsLang=en#h_01JWSA51RXGEMXYGHJV08KHPR8:~:text=to%20show%20screenshot-,Detailed%20Material%20Components%20Report%20Fields,-Field) to jump to Detailed Material Components Report Fields   ![49395331858331.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/49395331858331.png?width=881&height=441&name=49395331858331.png) [Click here](https://support.worldly.io/hc/en-us/articles/37618508429979-Product-Impact-Calculator-Material-Library?hsLang=en#h_01JWSA51RXGEMXYGHJV08KHPR8:~:text=by%20P006%20supplier-,Material%20Impacts%20Report%20Fields,-Field) to jump to Material Impacts Report Fields   ## **Missing Info and Revising** Select the **Missing Info** checkbox in the upper right-hand corner to target just the products that are missing information. In this case, all four products are missing purchase orders. ![40382534362139.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/40382534362139.png?width=1101&height=465&name=40382534362139.png) By using the bulk upload, you can make tens of thousands of edits to your Product Library with a single file upload. 1. Check **Missing Info** box if you haven’t done so already.   2. Click the first checkbox in the Product Library, and navigate to **Select all on this page**. Steps 1 and 2 will check all the items that are missing information, which can come in handy if you’re dealing with hundreds of thousands of products. ![40382550449051.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/40382550449051.png?width=1098&height=499&name=40382550449051.png)   3. From the black navigation bar, select **Download.** This downloads a csv file that mirrors the selected rows in the **Product Library.** ![40382550449691.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/40382550449691.png?width=1100&height=503&name=40382550449691.png)   4. Make any edits in the CSV file, in this case, adding the purchase order dates to the purchase order column. Make sure to save as a CSV file. ![40463984934939.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/40463984934939.png?width=2226&height=560&name=40463984934939.png)   5. Back on the platform, select **Import.**![40765488754587.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/40765488754587.png?width=771&height=69&name=40765488754587.png)   6. Select the **Bulk Upload - BOM** workbook, or whichever workbook corresponds with the column headers in your file. ![40382550452635.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/40382550452635.png?width=691&height=442&name=40382550452635.png)   7. Drag and drop your file onto the screen. ![40382550453403.gif](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/40382550453403.gif?width=914&height=640&name=40382550453403.gif)   8. Review the field mapping and value mapping on the next two windows before clicking **Continue**. ![40382550457371.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/40382550457371.png?width=905&height=643&name=40382550457371.png)   9. On the next page, review the **Bulk Upload** table for any errors. - The following example is for a company uploading a workbook with four products. ![40382550458651.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/40382550458651.png?width=1982&height=604&name=40382550458651.png) - The screenshot below has errors several errors that need to be resolved. ![40382534377115.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/40382534377115.png?width=1041&height=313&name=40382534377115.png) - To resolve the errors, hover over the red shaded cells. ![40382550460059.gif](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/40382550460059.gif?width=650&height=312&name=40382550460059.gif) - The red cell under the Material 1 column is blank. Select Wool from the drop-down menu. ![40382534383771.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/40382534383771.png?width=1042&height=338&name=40382534383771.png) - The red cells under Composition 1 column should be 100. Since these products are made with only one material (Material 2 and Composition 2 columns are not filled out), the composition must equal 100%. Enter 100 into the cells with 75.  ![40382550462747.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/40382550462747.png?width=480&height=261&name=40382550462747.png)   10. After the table has been reviewed and all errors have been resolved, click **Submit data.** ![40382534385947.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/40382534385947.png?width=331&height=133&name=40382534385947.png)   11. You’ll know if you were successful when you see the **Success** pop up. ![40382550465307.png](https://support.worldly.io/hs-fs/hubfs/Knowledge%20Base%20Import/40382550465307.png?width=516&height=184&name=40382550465307.png)   ## **FEM Outlier Exclusion** Unusual or potentially erroneous FEM data is automatically excluded before it impacts product-level calculations.   ## **Workbook Template** Download the **Bulk Upload - Material Workbook Template** below. [![Worldly logo](https://support.worldly.io/hs-fs/hubfs/Worldly%20Media%20Kit/Worldly%20Logos/Worldly_LogoTM_Red.png?width=120&height=30&name=Worldly_LogoTM_Red.png "Worldly logo")](https://www.worldly.io) © 2026 Worldly. All Rights Reserved [Terms of use](https://worldly.io/terms-of-use/)  |  [DPA](https://worldly.io/data-privacy-addendum/)  |  [Privacy Policy](https://worldly.io/privacy-policy/)  |  [Cookie notice](https://worldly.io/cookie-notice/)