Note that you will want to use the column header to expand complex types like Locations and Website URLs. In the window provided select "Basic" and enter your Socrata username and password. When accessing private datasets you will be prompted to authenticate your credentials in order to view the data. Step 3: Paste the OData endpoint link into the dialog box that appears and click “Ok” In Excel 2010 and Excel 2013 from the Power Query Ribbon, choose Get External Data > From Other Sources > From OData Feed:
In Excel 2016 from the Data Ribbon under Get & Transform choose New Query > From Other Sources > From OData Feed:
Use url data link in excel for mac professional#
You’ll need an installed version of Office 2010 Professional Plus, 2013 Professional Plus, Office 365 ProPlus, or a standalone edition of Excel 2013.
Use url data link in excel for mac install#
If you are using Excel 2016, you can skip this step (Power Query is built into Excel 2016 as part of the Get & Transform tool).ĭownload and install the latest version of Microsoft Power Query. Here’s how you can use Power Query to create a link to a Socrata dataset. All document data distributed and stored in the cells.
Power Query for Microsoft Excel provides more querying capabilities than Excel’s default Data tab. XLS format is used to refer to the documents of the program Microsoft Excel. Socrata OData connections are only available through Microsoft Power Query. When viewing the dataset, select the “Export” pane and choose the OData section and copy either of the two listed OData endpoints.Īccessing Socrata data using Power Query for Microsoft Excel This endpoint can also be found in the table view.
You can click on the OData box to choose either the V2 or the V4 endpoint. This will bring up a pop-up screen which will contain the OData Endpoint for the dataset. This will open up a drop-down where you can select "Access Data via OData". To access the endpoint through Socrata Primer, select the "." button on the top right of the screen. Follow these instructions to create an Excel workbook with a link to public data from any Socrata-powered website.īecause Excel maintains an active link to the data, all you need to do to refresh your workbook with the latest data is click the “Refresh All” button in the Excel ribbon.Įvery dataset has a unique OData URL. Microsoft Excel® is a very popular tool for analyzing and visualizing data.
0 kommentar(er)
