Do you have data in Excel that you want to visualize as an org chart? Before you waste days trying to figure out exactly what you need to do, let us help you out. These are the key things you need to know to prepare your Excel data to be imported into most online org chart creators.
- Some of your data has to be unique so that org chart software can make sense of it. But which data? Stick to the basics. Every single “people ID” and “position ID” needs to be unique. If you repeat any of those IDs, your org chart won’t work.
- Don’t have IDs? You can just make them up! If you don’t have a “person ID” for every single employee, just create new IDs. In the “people ID” column, just start with the number 1 and continue down the rows of people until everyone has a “people ID”.
- Every row of data should include data about one single person that holds one single job. If there are any blanks in your data, try to fill it in as best as you can. If you have too many blanks, consider asking for more data from your colleague that keeps track of HR data.
Know The Boss
- Org charts are made by connecting every single position to a manager. For instance, a VP reports to an Executive VP. And an Executive VP reports to the CEO. Make sure you have one column in your data that shows the “position ID” that each person reports to.
- If you don’t have the “reports to position ID” column in your Excel sheet, it is necessary to add it. Start at the top. Find the “position ID” of the CEO (let’s say that “position ID” is 1). Then find every person that reports to the CEO and put the number 1 in their “reports to position ID” column. Do that for each leader until all of the rows are filled.
- The top boss doesn’t report to anyone, though. So make sure that the “reports to position ID” of the person at the top of your org chart is left blank!
- Download this example Excel sheet that shows all of the columns that are necessary to create an org chart from Excel.
- The Excel sheet was made to work with OrgWeaver, but it should also help get your data prepared for an Excel import to Organimi, OrgPlus, OrgChart4U, OrgVue, and other online org chart creators.