How to create file type and file size analysis using Pivot like Treesize tool?

[Avian 1]

Hello,

We have so many excel files having having file name, extension, size last modified by, last modified date.

I want to create a pivot/chart in presentable mode depending on file size and file extensions aging analysis like treeview professiona tool. So analysis can give us a a glance summary.

Can someone please share some article or guide me?

Regards

Avian

[#2]

You can get the data in by using Data tab, Get Data button, From FIle, From Folder.