How do I import a Treejack tree from Excel or another spreadsheet application?

To import a Treejack tree structure from Excel or another spreadsheet program, you need to format your worksheet so that each 'level' in the tree is represented by a column in your spreadsheet. It helps to add a "Home" (or similar) label to the top-left cell (A1), but if you don't, a "Top" label will be added for you.

An example is provided below:

Your tree is probably much bigger; you don't need to worry, you should be able to add as many columns and rows as you need to represent your site structure.

To get the tree into Treejack, just highlight the full contents of your spreadsheet worksheet (or just the cells that represent the entire tree) and copy and paste it into Treejack's text editor field on the "Tree" tab of your survey setup.