Analyzing Open Data on the Desktop Is Now Easier with the Socrata Open Data Connector for Microsoft Office 365™

March 10, 2014 12:55 pm PST | Data as a Service
Analyzing Open Data with Microsoft Excel Via OData

By Chris Metcalf


At Socrata, we work hard every day to make data more useful, to more people, in more ways. Whether it’s through our award-winning open data platform, our GovStat performance tracking tools, or our easy-to-use Socrata Open Data API, we strive to identify the most user friendly way for the widest variety of users to access open data and provide a targeted experience for their needs.

Today, we’re excited to announce the release of the Socrata Open Data Connector for Microsoft Office 365™, a new feature that delivers native support for Microsoft Excel® and the newly released Power Query feature and Microsoft Power BI for Office 365 and Power Query tools—right from your desktop. By adding support for the Open Data Protocol (OData), an open standard for accessing data over the web, users will be able to seamlessly access datasets from within their Excel spreadsheets, and keep them in sync as data changes.

Once users have loaded data into Excel, they’ll be able to use familiar tools to:

  • Discover available datasets from within Power Query
  • Make use of open data within their Excel models and analyses
  • Analyze datasets using sophisticated features like PowerPivot in Excel
  • Build and share dashboards using Microsoft Power BI for Office 365
  • Visualize data using charting tools in Excel
  • Create interactive maps using the Power Map feature in Excel

And best of all, since Excel has a live connection to the Socrata dataset, refreshing your source data is just a click away.

Using Excel to Access Open Data

We have added a new “OData” pane within the “Export” tab of every tabular dataset on Socrata. Within that pane, users will find a link to the OData endpoint for that dataset. By copying that link into Microsoft Excel, you’ll be able to set up a live connection to the data in Socrata.

For more information about how to use the Socrata Open Data Connector with Microsoft Excel, check out this helpful support article.


These updates will be rolled out today and will be available on all existing public datasets.

Socrata’s support for OData will be maintained alongside our support for our Socrata Open Data API (SODA), so developers can continue to choose which experience they prefer. Because the functionality of the OData standard differs from that of SODA, some query functions and datatypes may only be available via SODA.

Please email our amazing support team at or file a ticket at if you have any questions or concerns.

Microsoft, Excel, and Office 365 are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.

Previous Article
Data as a Service
Open Sourcing GovFinder: Windows 8 and Windows Phone Apps

March 10, 2014

Next Article
Data as a Service, Effective Governing
Civic Awesome: Open Data in the News for March 7, 2014

March 7, 2014