Embodied Carbon Tools

Excel Database Integration

Export materials database to Excel-compatible formats

Quick Export

Total Materials
0
Categories
0

How to use in Excel:

  1. Click "Export for Excel" to download the CSV/TSV file
  2. Open Excel and go to Data → Get Data → From File → From Text/CSV
  3. Select your downloaded file
  4. Excel will preview the data - click Load
  5. Use VLOOKUP or XLOOKUP to reference materials by ID

Import Custom Database

Upload your own materials JSON file to convert to Excel format

Excel VLOOKUP Formula Generator

Using materials in Excel calculations:

After importing the database, use these formulas:

  • Get Carbon Value: =VLOOKUP(A2, Materials!A:D, 4, FALSE)
  • Get Density: =VLOOKUP(A2, Materials!A:E, 5, FALSE)
  • Calculate Total Carbon: =Thickness_mm/1000 * Area_m2 * Density * Carbon

Where A2 contains the Material ID, and "Materials" is the sheet name with your imported data.

Data Preview

Material_ID Material_Name Category Carbon_kgCO2e_per_kg Density_kg_per_m3 Source EPD_Reference Notes

Power Query (Advanced)

Connect Excel directly to JSON URL:

  1. In Excel, go to Data → Get Data → From Other Sources → From Web
  2. Enter your JSON URL (e.g., https://yoursite.com/materials.json)
  3. Click OK and Excel will parse the JSON
  4. In Power Query Editor, expand the nested columns
  5. Transform and load the data
  6. Click Refresh anytime to update with latest database values

💡 Pro Tip: This method allows your Excel file to automatically update when your online database changes!