Google Sheets and Excel
Voydar data as spreadsheet formulas. Both add-ins call the same API with your key, cost the same credits, and cache results for 15 minutes so recalculating does not spend credits again. They are not listed in the Google Workspace Marketplace or the Office Store; install them from the files below.
Google Sheets
In your sheet open Extensions, then Apps Script. Paste the script, save, and reload the sheet. Then use the new Voydar menu, Set API key.
The key is kept in your own Apps Script user properties, never in a cell. In a shared sheet, Google runs custom functions as the sheet owner, so formulas use the owner's key and credits.
Download the script (Seadar.gs)Excel (Windows, Mac and Excel on the web)
Download the manifest, then in Excel choose Add-ins, My Add-ins, Upload My Add-in (on the web), or add it through a shared-folder catalog (desktop). Open Voydar key on the Home tab and save your key.
The key is kept in the add-in's own storage on your computer, never in the workbook.
Download the manifest (manifest.xml)| Google Sheets | Excel | Returns |
|---|---|---|
| =SEADAR(id, field) | =SEADAR.GET(id, field) | One value about a vessel, port or company: name, imo, mmsi, sanctioned, owner, manager, co2, lat, lon, attribution, withheld, page, or any dot path. |
| =SEADAR_SEARCH(query, kind, limit) | =SEADAR.SEARCH(query, kind, limit) | Matching vessels, ports and companies, one per row. |
| =SEADAR_PORT_CALLS(id, limit) | =SEADAR.PORTCALLS(id, limit) | Reported port calls of a vessel or a port. |
| =SEADAR_SCREEN(range, lists) | =SEADAR.SCREEN(range, lists) | Sanctions screening of a range of IMO numbers or MMSIs (identifier match only). |
| =SEADAR_SANCTIONED(list, limit) | =SEADAR.SANCTIONED(list, limit) | Vessels currently on a sanctions list. |
| =SEADAR_TRACK(id, hours) | =SEADAR.TRACK(id, hours) | Recent positions from feeds licensed for API use. |
| =SEADAR_USAGE() | =SEADAR.USAGE() | Credits left this month. |
Show the attribution strings (the "attribution" field) wherever you share the data.