One of the features of Open Data Framingham is the capability to link a spreadsheet to the data maintained by the City. Some of the datasets on Open Data Framingham are updated every business day, others are updated annually.
We support the OData standard for direct data connection so you know you are working with the most recent data.
Data can also be exported in various formats including XML, RSS feed, JSON, and CSV.
1.View the dataset’s table view.
2.Click the Export link on the Toolbar and expand the OData option.
3.Copy the link found in OData v4 Endpoint.
4.In Excel, click the Data tab and choose New Query > From Other Sources > From OData Feed
5.Paste the OData link into the URL box and click OK.
6.The data will populate the spreadsheet.
Google Sheets can connect to external data using its IMPORTDATA(url) function.
4. Open your Google Sheet and enter the IMPORTDATA formula in a cell, pasting the link you copied as the parameter for the function:
5.You will need to reformat any date and time fields as date/time format: