Is there a way to import a csv into dashboard

muralikottakota · January 31, 2020, 2:39pm

My requirement is to import a csv into Grafana dashboard, and do all kinds of filtering in Grafana dashboard. Is there a way to import csv in Grafana?

hary66 · January 31, 2020, 3:30pm

Hi Muralikottakota
I’m trying the same, but wasn’t successful yet.

It seems, you Grafana need to get the data from a database like InfluxDB.
So first, you need to move your data from CSV to InfluxDB .

There is a tool for doing so witch is telegraf.
Must you must give telegraf a telegraf.conf file, to let know how are your data organised in the CSV, so telegraf can manage your data as expected.

github.com

influxdata/telegraf/blob/master/etc/telegraf.conf

# Telegraf Configuration
#
# Telegraf is entirely plugin driven. All metrics are gathered from the
# declared inputs, and sent to the declared outputs.
#
# Plugins must be declared in here to be active.
# To deactivate a plugin, comment out the name and any variables.
#
# Use 'telegraf -config telegraf.conf -test' to see what metrics a config
# file would generate.
#
# Environment variables can be used anywhere in this config file, simply surround
# them with ${}. For strings the variable must be within quotes (ie, "${STR_VAR}"),
# for numbers and booleans they should be plain (ie, ${INT_VAR}, ${BOOL_VAR})


# Global tags can be specified here in key="value" format.
[global_tags]
  # dc = "us-east-1" # will tag all metrics with dc=us-east-1
  # rack = "1a"

This file has been truncated. show original

Hope this can help.
Could you tell if you’re successful.

malamgir · February 3, 2020, 5:38am

Alternative way .

https://www.influxdata.com/blog/getting-started-writing-data-to-influxdb/

g0nz0uk · December 20, 2020, 5:14pm

Hi, I know this is old, but yes you can. I used the cab plugin this week and it’s excellent. You need to put the csv into a website like IIS and point to that. I have a power shell script outing my csv there every 5 mins.

davidallen5 · March 16, 2023, 6:00pm

Hi all - late reply to this thread but since this topic was originally posted, a CSV plugin is available for Grafana here:

The basics of this plugin is that if you install it into your Grafana, it will allow you to create a data source that fetches CSV from anything you can address with a URL endpoint. For example, there is a public GDELT API that returns CSV data about news headlines around the world. If I wanted to get CSV out of this:

https://api.gdeltproject.org/api/v2/doc/doc?query=grafana&mode=timelinevolinfo&TIMELINESMOOTH=5&format=csv

Then I could use the CSV plugin linked above, specifying https://api.gdeltproject.org/api/v2/doc/doc as the URL, and then in the “Misc” section, specifying query=grafana&mode=timelinevolinfo&TIMELINESMOOTH=5&format=csv as the query param.

This is pretty flexible because any kind of CSV data you can get from any endpoint gets into Grafana easily, like any other data source.

Topic		Replies	Views
Move data from .csv to influxdb InfluxDB	4	8540	February 3, 2020
How do I find a telegraf plugin for a dashboard? Grafana	0	183	July 2, 2020
Help Instlalling a Dashboard Grafana	0	163	September 30, 2020
Script powershell Grafana	1	3047	September 13, 2019
Import data from excel, csv to the dashboard Grafana	2	6137	October 18, 2022

Is there a way to import a csv into dashboard

Related topics