How to show csv file in Excel as Graph

[MationPlays]

Hello, I got these metrics csv files(one FFMetrics_results file and one for vmaf of each video) now and don't know how to visualize them in Excel. I don know what these numbers even are and what the term for the coloums mean. Please help

[fifonik]

Unfortunately, I cannot help as I do not know what exactly you doing and what you'd like to have at the end. Sorry.

[MationPlays]

Like i just want to be able to see the graph of the vmaf again in excel. There is a graph visible in ffmetrics when running it i want to able to see this again

[fifonik]

You need to import the tab delimited file/files into Excel (for some reason "Open" does not work in Excel as it is not smart enough to detect that the file is "tab delimited"). When importing you should make sure that "Tab" is selected as fields separator. Then you will need to select "frame" column for X-values and "vmaf" column for Y-values while creating line chart. Unfortunately, I cannot provide exact steps for configuring chart as I do not have Excel (can provide steps for LibreOffice Calc if you need).

[MationPlays]

Thanks, please tell me how to do it with libre office, i also never did this with excel

[fifonik]

Simplest line chart LibreOffice Calc:

• Ctrl+O | select file | Open
• Make sure "separated by" - tab | OK (in my case it is selected by default, I do not know if it remember the last choice of auto-detects correct separator)
• Select "vmaf" column, that is M in my case (or any other column you'd like to use in chart as Y-Values)
• Insert | Chart
• Chart | Lines only
• Finish

I believe the question should be asked in LibreOffice community or just google.

[fifonik]