Green Button XML to CSV Converter

📊 Where to Get Your Green Button Data

Most utility companies provide a "Green Button" or "Download My Data" feature in their customer portal:

Log into your utility company's website
Look for "Green Button", "Download My Data", or "Export Usage Data"
Click the green button - an XML file will automatically download
Upload that XML file here to convert it to CSV format

Common locations: Account Dashboard, Usage History, or Billing sections

Choose Green Button XML File Browse

Processing Results

File Information

Feed ID: N/A

Feed Title: N/A

Last Updated: N/A

Total Entries: 0

Data Summary

Usage Points: 0

Meter Readings: 0

Total Intervals: 0

Date Range: N/A

Field Explanations

value: Energy consumption value (integer, use power_multiplier for conversion)

cost: Cost value (unit depends on utility/currency)

uom: Unit of measure (e.g., 'Wh' = Watt-hours, 'kWh' = Kilowatt-hours)

power_multiplier: Power of 10 to apply to raw values
-3 = ÷1000, 0 = no change, 3 = ×1000

calculated_value: Convenience field: value × 10^power_multiplier
Actual energy consumption in the unit specified by UOM

calculated_cost: Convenience field: (cost × 10^power_multiplier) ÷ 100
Cost in dollars if currency is USD, otherwise may be incorrect

Data Preview

📋 Green Button Data Specifications

Power Multiplier Examples

Power Multiplier: 3
Raw: 21 → Actual: 21,000 (× 1,000)
Used for: Large industrial values

Power Multiplier: 0
Raw: 21021 → Actual: 21,021 (no change)
Used for: Standard readings

Power Multiplier: -3
Raw: 21021 → Actual: 21.021 (÷ 1,000)
Used for: Utility precision data

Power Multiplier: -6
Raw: 21021000 → Actual: 21.021 (÷ 1,000,000)
Used for: High precision meters

Common Units of Measure (UOM)

Code 72: Wh
Watt-hours (energy)

Code 73: kWh
Kilowatt-hours (energy)

Code 38: W
Watts (power)

Code 42: m³
Cubic meters (gas/water)

Code 119: ft³
Cubic feet (gas)

Code 122: gal
Gallons (water)

Cost Data

Currency 840 = USD
cost typically in cents
Example: 256347 = 256,347 cents

Other Currencies
978 = EUR, 826 = GBP, 124 = CAD
ISO 4217 currency codes

Interval Durations

900 seconds
15-minute intervals

3600 seconds
1-hour intervals

86400 seconds
1-day intervals (daily readings)

2678400 seconds
~1-month intervals (monthly)

💡 Real Example from Your Data

Original Data: value = 21021, cost = 256347, power_multiplier = -3, uom = "Wh"

Value Calculation: 21021 × 10^-3 = 21021 × 0.001 = 21.021

Cost Calculation: 256347 × 10^-3 = 256347 × 0.001 = 256.347, then 256.347 ÷ 100 = $2.56

Results:

calculated_value: 21.021 Wh (Watt-hours) of energy consumed
In kWh: 21.021 ÷ 1000 = 0.021021 kWh
calculated_cost: $2.56 (assuming USD cents)