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.