Back to MarineTraffic

Use API Services for Data Analysis purposes (spreadsheets)

MarineTraffic API Services provide you with the necessary means to create powerful applications which make use of near real-time maritime intelligence. However, you may also be looking for an effective way to enrich your reports or perform a data analysis using all the latest AIS data updates. Let's have a look at such an example:



You have activated a personalised variation of, say, API Service PS02 - Vessel Positions to be receiving the detailed positions of certain vessels having in mind to analyse their speed and produce valid reports using trustworthy, up-to-date information.


Spreadsheet Applications

Spreadsheet applications such as Microsoft Excel can be connected to another application and be automatically updated whenever changes occur.

In our example, new records will be recorded in the spreadsheet whenever an API Service response occurs. This way, you could run your analysis at any time using a Spreadsheet Application that is always up-to-date with all the latest data.


Establish a Connection

Establishing a connection between your Spreadsheet Application and a MarineTraffic API Service is a rather simple process which does not require advanced computer skills. For example, in the Microsoft Excel environment, you should follow these simple steps:

  • Launch the program and establish a connection using the URL containing your unique API Key and your Service parameters. For more information about API Usage, visit the API Documentation page.
  • To establish the connection click on the Data tab and click on the From Web" option.
  • Create a new Connection using the URL of your API Service. Click on the Import button (for optimal results set the Protocol parameter of your API Service to XML).
  • On the Connection Properties options, define an update interval (Refresh every) similar to the response frequency of your API Service (for example, 60 minutes).
  • This way, the Spreadsheet will be seamlessly updated whenever new data becomes available (i.e. whenever a new API response occurs).



The main benefit of connecting to an external data-source (your API Service) is that you can periodically analyse this data without repeatedly copying new data to your workbook, which is an operation that can be time-consuming and prone to error. This way, you may focus on your analysis using dynamic information without having to worry about tedious, manual data updates.

Set-up your API Service, set-up your connection, done!


Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Powered by Zendesk