The Scenario
You're a solar energy consultant, and the client handed you an Excel workbook with 15 potential farm sites — just latitude and longitude. They want a 30-day GHI and UV index projection for each one so you can model annual production estimates before the site visit next week. You have never had to model fifteen sites at once before. The last project was three.
The bad version:
- Read the Stormglass solar endpoint documentation, figure out which parameters to pass for global horizontal irradiance and UV index, then run a call for site one.
- Parse the daily array in the response — 30 entries, each with a GHI value buried in a nested object — and paste the 30 values into column C starting at row 2.
- Repeat for sites two through fifteen, mentally tracking whether you're filling the right column range for each site as you scroll down the workbook.
By site seven, your column C has a two-row gap from a copy-paste slip and you're not sure whether to fix it now or flag it for later.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the site coordinates in columns A and B, understands that you want a 30-day daily solar data series, and through its built-in Stormglass.io connection it fetches GHI and UV index for every site and writes the daily values into the adjacent columns — without you having to navigate the endpoint structure or parse a single JSON response yourself.
Get Stormglass solar data for every lat/lng in my Excel table for the next 7 days and list date, sunrise time, sunset time, UV index, and GHI in the adjacent columns starting at column C.
What You Get
- Columns C through G filled with date, sunrise time, sunset time, UV index, and GHI for each site row.
- Values sourced from the Stormglass solar endpoint and written per site across the 7-day window.
- Site name from any label column repeated as a row identifier so the output table is readable without cross-referencing another worksheet.
What If the Data Is Not Quite Ready
You need each of the 30 daily values as separate rows, not one row per site
The energy model your firm uses needs day-by-day GHI input, not a summary value.
For each coordinate in columns A and B, fetch Stormglass solar data for the next 30 days and write each day's GHI and UV index as a separate row in the Solar Output worksheet — one row per day per site, with site name, date, GHI, and UV index in columns A through D.
Several sites are listed as "Under Review" and should be excluded from this run
The client marked three sites as pending environmental clearance, and including them in the model adds confusion.
For rows where column F does not say "Under Review," fetch Stormglass solar irradiation data for the next 30 days and write daily GHI into column C and UV index into column D. Skip rows flagged as "Under Review."
Some coordinates are in the wrong hemisphere and the irradiance values look wrong
A handful of sites in the southern hemisphere were entered with the latitude sign flipped. You need to check and correct before fetching.
Check column A for latitudes that appear to be sign-flipped based on the site names in column E — if a site labeled "Southern" has a positive latitude, flip it to negative. Then fetch Stormglass solar irradiation data for the next 30 days for every corrected coordinate and write GHI into column C.
Validate coordinates, exclude review sites, fetch 30-day series, flag low-irradiance sites
Your full pre-analysis checklist: fix any sign-flipped latitudes, skip sites under review, fetch 30-day GHI and UV index for the rest, and mark any site where average daily GHI falls below 4.0 kWh/m² as "Low Potential" in column G.
Fix any sign-flipped latitude values in column A based on site names in column E, skip rows where column F says "Under Review," then fetch Stormglass solar irradiation data for the next 30 days for each valid coordinate. Write daily GHI into column C and UV index into column D. Calculate the 30-day average GHI and write "Low Potential" in column G for any site averaging below 4.0.
Combining the validation pass with the data fetch means you're handing the client a model-ready workbook, not a half-cleaned draft.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with site coordinates, then ask it to pull Stormglass solar irradiance data for each location across your planning horizon. The Stormglass.io integration is included in every SheetXAI plan. Also see fetching weather forecasts by coordinate or the Stormglass.io overview.