https://store-images.s-microsoft.com/image/apps.27862.5102dea7-b927-4ccf-bb16-5c2c66e7f713.d28dec56-3e0c-4361-a377-20bd101dfd94.8fe906a9-d378-462d-934a-ce069593fd8f.png

Dimensions Add-In for Excel

by Digital Science and Research Solutions Ltd

The Dimensions API Connector is an Excel Add-In that permits to launch DSL queries directly in Excel

The Dimensions API Excel Add-In allows to running Dimensions API queries using the DSL language directly from an Excel window. The results are transformed from JSON to a tabular format, thus allowing further manipulations using the usual Excel tools.

Existing Dimensions subscription is required to access data via this Add-in. Contact your sales representative or get in touch via https://www.dimensions.ai/request-a-demo-or-quote/

Dimensions is an award-winning scholarly information database containing linked metadata records for millions of publications, patents, clinical trials, grants, policy documents, and datasets. For more information, see http://dimensions.ai/

Dimensions contain a network of more than 100 million records connected by billions of links. This vast information landscape supports a myriad of business and analytical needs. Making data available in ways that are useful to the research community is a key priority for the Dimensions team, so we’ve designed several API services with your needs in mind.

The Analytics API supports the extraction of Dimensions data for use in complex analyses and visualizations or the building of analytical tools and reporting templates. The API uses an intuitive query language specifically developed for Dimensions data. You can retrieve, aggregate, and sort data from highly specific requests in a single API call. Additional services like text categorization are also available.

Start by exploring this Add-in by triggering "Dimensions API" button on the "Data" pane in Excel.

Explore the following resources to find out more:

* https://www.dimensions.ai/dimensions-apis: Dimensions API products homepage.

* https://docs.dimensions.ai/dsl: API documentation (in-depth).

* https://docs.dimensions.ai/dsl/gsheets.html: Gsheets add-on documentation.

* https://api-lab.dimensions.ai: Sample research data analysis notebooks.

App capabilities

When this app is used, it
  • Can read and make changes to your document
  • Can send data over the Internet

At a glance

https://store-images.s-microsoft.com/image/apps.30158.5102dea7-b927-4ccf-bb16-5c2c66e7f713.d28dec56-3e0c-4361-a377-20bd101dfd94.aecc4786-8012-4872-b1dc-1b1dcc00c50e.png
https://store-images.s-microsoft.com/image/apps.21605.5102dea7-b927-4ccf-bb16-5c2c66e7f713.d28dec56-3e0c-4361-a377-20bd101dfd94.092b6e5e-ae54-41b2-98f6-97dac4ece137.png
https://store-images.s-microsoft.com/image/apps.44710.5102dea7-b927-4ccf-bb16-5c2c66e7f713.d28dec56-3e0c-4361-a377-20bd101dfd94.6301a99c-f453-4554-8c44-82912c4324f0.png