topic Re: Netapp cli output to csv or excel in ONTAP Discussions

Netapp cli output to csv or excel

VKS — Thu, 07 Jan 2016 14:25:51 GMT

Hi Guys,

Just want to know if we can collect the output generated from CLI of Netapp cluster mode to either in excel or in csv. I have connected to the console of netapp box using putty and want to collect the output in excel file.

regards

Re: Netapp cli output to csv or excel

JGPSHNTAP — Thu, 07 Jan 2016 14:40:25 GMT

Ok, why would you want to connect output to excel file.

For console logging you should set your console window to log the putty session.

For excel output to CSV, you should become familiar with the powershell cmdlets and output to csv.

Re: Netapp cli output to csv or excel

James_Castro — Thu, 07 Jan 2016 14:57:41 GMT

View this video from NetApp KB TV. Tells you how to do it.

https://www.youtube.com/watch?v=WE_vAsqaBbI

Re: Netapp cli output to csv or excel

xavierpitz — Mon, 19 Jul 2021 11:56:55 GMT

Hello,

For those like me who watched the previously mentioned NetApp KB YouTube video too often 😉 :

set -showseparator '!'
set -rows 0
set -showallfields true
set -units GB

Re: Netapp cli output to csv or excel

xavierpitz — Wed, 24 Nov 2021 11:02:55 GMT

to disable it :

set -showseparator ''
set -rows 24
set -showallfields false
set -units auto

Re: Netapp cli output to csv or excel

Spelta — Thu, 05 Mar 2026 08:58:10 GMT

Thank you for saving me quite some time!