Is there a way to import local excel files as adatasource and try Pivot chart feature just like in MS Excel and similar spreadsheet applications in Grafana.
Hi @gokulsnarayan - Grafana doesn’t support Excel files as a data source. Are you able to use Google Sheets instead of Excel for this project? We do have a Google Sheets data source plugin that may work for this purpose:
Configuration docs:
# Configuring the Google Sheets data source
The Google Sheets data source is using the [Google Sheet API](https://developers.google.com/sheets/api) to access spreadsheets. The data source supports two ways of authenticating against the Google Sheets API. **API Key** auth is used to access public spreadsheets, and **Google JWT File** auth using a service account is used to access private files.
## API Key
If a spreadsheet is shared publicly on the Internet, it can be accessed in the Google Sheets data source using **API Key** auth. When accessing public spreadsheets using the Google Sheets API, the request doesn't need to be authorized, but does need to be accompanied by an identifier, such as an API key.
To generate an API Key, follow the steps in the Google Sheets data source configuration page.
If you want to know how to share a file or folder, read about that in the [official Google drive documentation](https://support.google.com/drive/answer/2494822?co=GENIE.Platform%3DDesktop&hl=en#share_publicly).
## Google JWT File
Whenever access to private spreadsheets is necessary, service account auth using a Google JWT File should be used. A Google service account is an account that belongs to a project within an account or organization instead of to an individual end user. Your application calls Google APIs on behalf of the service account, so users aren't directly involved.
The project that the service account is associated with needs to be granted access to the [Google Sheets API](https://console.cloud.google.com/apis/library/sheets.googleapis.com?q=sheet) and the [Google Drive API](https://console.cloud.google.com/apis/library/drive.googleapis.com?q=drive).
The Google Sheets data source uses the scope `https://www.googleapis.com/auth/spreadsheets.readonly` to get read-only access to spreadsheets. It also uses the scope `https://www.googleapis.com/auth/drive.metadata.readonly` to list all spreadsheets that the service account has access to in Google Drive.
show original
Alternatively if you’re populating the Excel sheet by pulling in data from a database, you may be able to use one of the other data source plugins like MySQL or Postgres:
1 Like
Do you plan to support excel soon?
4 Likes
