The Scenario
It's the first day of the quarter and the maritime research team's new analyst is trying to answer a question that should take five minutes: which Stormglass tide stations exist, and which of them are in the North Atlantic? The team's reference workbook is two years out of date. The analyst needs the current complete catalog pulled fresh and ready to filter before the afternoon kickoff call.
The bad version:
- Navigate to the Stormglass tide station endpoint, run an API call with no filters to retrieve the full catalog, and parse the response — which comes back as a JSON array of station objects, each with an id, name, latitude, and longitude.
- Count the stations. There are 200+. Start pasting: ID into column A, name into column B, latitude into column C, longitude into column D.
- Realize at row 140 that the name column has extra whitespace in some entries and the ID field is sometimes an integer, sometimes a string, and the workbook is going to need cleanup before anyone can filter it.
The kickoff is in three hours. The analyst has other onboarding items to get through.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your intent — list all tide stations from Stormglass — calls the catalog endpoint, and writes a clean, consistently formatted table. No JSON parsing, no column-by-column pasting, no format guessing. One prompt.
Export the complete Stormglass tide station catalog into my Excel sheet — I need station ID, name, and coordinates in columns A through D.
What You Get
- A complete station catalog table with headers in row 1: Station ID, Station Name, Latitude, Longitude.
- One row per station, IDs formatted consistently as text, names trimmed of extra whitespace.
- The total count of stations noted in a cell below the table so the team knows whether the import was complete.
What If the Data Is Not Quite Ready
You want to filter the catalog immediately to stations above a certain latitude
The team's study area is above 55°N and they don't want the southern hemisphere stations cluttering the reference workbook.
Export the complete Stormglass tide station catalog, filter to stations with latitude above 55, and write the filtered results — station ID, name, latitude, longitude — into this workbook with headers. Note the total count of matching stations below the table.
The workbook already has an old station catalog and you want to identify new stations added since the last export
The team's reference workbook has 180 station entries from two years ago. You want to see which stations in the current Stormglass catalog aren't already listed.
Export all current Stormglass tide stations and compare them against the existing entries in columns A through D. Write any station IDs that don't appear in the existing list into a new "New Stations" section starting at row 210 with a header row.
Station names have inconsistent casing and you need them normalized before sharing with the external partner
The external team's system is case-sensitive. Some names are ALL CAPS, some are Title Case, some are mixed.
Export all Stormglass tide stations, normalize all station names to Title Case, and write station ID, normalized name, latitude, and longitude into this workbook. Flag any name that contained non-standard characters in column E.
Full refresh: pull the catalog, deduplicate against the old workbook, classify by hemisphere, flag outlier coordinates
The reference workbook hasn't been updated in two years. You want a complete refresh: pull the current catalog, remove any stations already in the old list, classify each new station by hemisphere, and flag any with coordinates that look like data entry errors.
Export all current Stormglass tide stations. Compare against the existing station IDs in column A rows 2 through 181. Write only the new stations into a "New Stations" section starting at row 185 — with ID, name, latitude, longitude, and a hemisphere label (Northern/Southern based on latitude sign). Flag any new station where latitude is outside −90 to 90 or longitude is outside −180 to 180 in a "Coordinate Error" column.
Combining the refresh, the dedup, and the validation pass in one prompt means the team starts the afternoon kickoff with a reference workbook they can actually use.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook where your team tracks geographic or environmental reference data, then ask it to pull the complete Stormglass tide station catalog and filter it to your region of interest. The Stormglass.io integration is included in every SheetXAI plan. Also see finding stations within a bounding box or the Stormglass.io overview.