Importing Organizational Chart from text file

S

shudson

I have the following CSV text file. When I import it into Visio Ogranization Chart, the order of the three employess is not the same as in the text file. I want the three employees in order from left to right.

How do I specify order of the boxes when I import from a text file.

I have tried csv, regular txt, and xls files: all have the same problem.

For this chart, I can manually reorder the boxes, but for a large chart, this is tedious.

Unique_ID Department E-mail Name Telephone Title Reports_To Master_Shape
ID1 Department E-mail J Smith Telephone Manager 1
ID2 Department E-mail K Jones Telephone Employee 1 ID1 2
ID3 Department E-mail L Baker Telephone Employee 2 ID1 2
ID4 Department E-mail S James Telephone Employee 3 ID1 2
 
Top