Share via

Export SharePoint Folder Structure to Visio

  • Article

A user asked how to export the SharePoint library folder structure so he can put the structure in his presentation. This site (http://www.experts-exchange.com/articles/2802/Displaying-the-Windows-Directory-as-a-Visio-Organization-Chart.html) describes the way to draw the Windows folder structure in Visio. Based on that idea we have finished the requirement as below.

Export data:

Using Export to Excel option library export the data.

http://1.bp.blogspot.com/-PSBl1jAq6mY/VUIjpdcZNvI/AAAAAAAAJqA/olfi6ruBBcY/s1600/1.png

http://1.bp.blogspot.com/-Qd5Vig_xJ5w/VUIjyv4JDnI/AAAAAAAAJqI/QNbjaTACUWc/s1600/2.png

Alter Data:

Remove the unwanted data.

http://3.bp.blogspot.com/-dMfM5pEx1Mg/VUIlDRPzwlI/AAAAAAAAJqU/8LinXD6PXjw/s1600/3.png

Change the column from Path to Parent.

http://3.bp.blogspot.com/-Ez8DG4iXIRs/VUIlKJGnR9I/AAAAAAAAJqc/FmXz87nOuPw/s1600/4.png

Create one column named Child with the following formula:

=CONCATENATE(b2,"/",a2)

http://4.bp.blogspot.com/-_z_IEGC5VVE/VUIlVZJ9ksI/AAAAAAAAJqk/Ykoo_vCBBck/s1600/5.png

 
Excel now looks like below:

http://2.bp.blogspot.com/-b0M3DCn1m6I/VUIlk1kzrqI/AAAAAAAAJqs/kxmH1PuV3lw/s1600/6.png

Add the root element in the Excel:

Name: Shared Document

Parent: sites/audit/test/Shared Documents
Child: sites/audit/test/Shared Documents

Final Excel sheet looks like below:

http://4.bp.blogspot.com/-O0SWKl1Q7po/VUIlxlzPePI/AAAAAAAAJq0/PdPi4-gBjiI/s1600/7.png

Save & Close Excel.

Import the data in Visio:

In Visio, choose the Organization Chart template and create.

http://3.bp.blogspot.com/-Qbx0Q_TE_as/VUIw905XNMI/AAAAAAAAJrE/D2soDR4H4dI/s1600/8.png

Choose Org Chart and click Import.

http://2.bp.blogspot.com/-elhjG5en4uY/VUIxMgWY7MI/AAAAAAAAJsI/kzVA0Mq_Zv8/s1600/9.png

Choose the first radio button.

http://1.bp.blogspot.com/-17fO-KTtxXs/VUIxIfz9HfI/AAAAAAAAJrY/WOCFfYQ_o_I/s1600/10.png

Choose Excel file as the option.

http://2.bp.blogspot.com/-z6HTgcfbf14/VUIxISMbguI/AAAAAAAAJrM/R3z2Q2KsK1Y/s1600/11.png
  

Browse the Excel and click Next.

http://2.bp.blogspot.com/-OwfG5jtU29k/VUIxIYNP_YI/AAAAAAAAJrQ/YbZnzIzG5pY/s1600/12.png

In next window choose Name as Child and Reports to as Parent

http://3.bp.blogspot.com/-wFrzdgpsvWc/VUIxJDDwbMI/AAAAAAAAJrk/SH9djWfeOD4/s1600/13.png

Choose required fields in next two windows.

http://1.bp.blogspot.com/-65EiCsN4drw/VUIxJjNGLiI/AAAAAAAAJrc/j41sPPICd0o/s1600/14.png

http://3.bp.blogspot.com/-SqxRiinUMc4/VUIxKA4KWDI/AAAAAAAAJrs/qSIeq_5hXko/s1600/15.png

On next window, choose auto page break and choose share document as top page.

http://1.bp.blogspot.com/-sHKT7e25Ow4/VUIxKa4W1mI/AAAAAAAAJr8/wnAVHPovfS4/s1600/16.png

Click Finish.

You will get the folder structure.

http://1.bp.blogspot.com/-4hJYQfb2tOc/VUIxK9YQV2I/AAAAAAAAJr4/YZ_ylgPkIbI/s1600/17.png