Easily Import the SONAR Data You Need for Easy Analysis
For SONAR users who need the ability to analyze and aggregate data via spreadsheets, we are happy to offer the Excel Add-in feature, which allows customers to choose the data they need — without the need to know code or get IT teams involved. Transportation analysts and pricing teams will value the ability to choose the data sets they want to view and streamline the aggregation and analysis of it for enhanced efficiency.
To access the Excel Add-in option, users simply need to download it from the Microsoft Store and request log-in credentials. From there, it’s a matter of choosing the desired data set(s) to import and the date or range. Available data sets include rates, capacity, volumes and more.
How to Use It
Designed to streamline the process of getting data to end users in a meaningful location, the SONAR Excel Add-in can be used to:
- Incorporate weekly/monthly updates with scheduled API pulls into customized Excel dashboards
- Benchmark contract rates regularly, combined with capacity and lane scores
- Evaluate uncovered loads most at risk daily using WRI, capacity and other scores to proactively manage volumes and scheduling
- Create historical or seasonal studies using SONAR data to evaluate high/low sales periods and market fluctuations
- Gain enterprise-level access without needing the support of an IT team or sophisticated tech stack
While it would be ideal to fully operate within a TMS, ERP or other system of choice, using spreadsheets to manage data is extremely efficient and effective. And there’s no better data to inject directly into your analytics than SONAR, the leading provider of supply chain intelligence.
Download our one pager here: Excel Add-In One-Pager (1)