This lesson describes how to import a plan into Hexawise from Excel files and/or Mind Maps.  

Hexawise allows you to import all of the types of details you might have in your plan. The import feature is straightforward but fairly inflexible.

This importing feature is not as forgiving or flexible as we'd ultimately like it to be.  For now, you've got to play by its formatting rules, and its got some persnickety ones.

To avoid any formatting complications when importing Excel files, you should "round trip" test plans from Hexawise, then into Hexawise.

Export a plan from Hexawise (with Value Expansions, Invalid Pairs, Married Pairs, Required Scenarios, Auto-Scripts, and Expected Results if you'll be using them). Make your edits being sure to keep the same file format when you save edits, and import the file back into Hexawise.  

We'll tell you a secret

When we create new large test plans from scratch, we don't usually start in the "Inputs" screen of Hexawise. Instead, we create Mind Maps while we put our thoughts together about possible test inputs to include in our plans.  

Mind maps are easy to use, visual, quick to modify, easy to get feedback on from others.  Also - whether or not it's actually the case - when we use mind maps to gather our test design thoughts, it tends to make us feel more creative.  

The different levels of test inputs are shown here in hierarchical order:

Basic Hexawise test plans only have two levels of test inputs: Parameters and, underneath them, Values. The all-caps levels and the fourth level shown above (for Value Expansions) are purely optional.

Any details you include in Mind Maps and import into Hexawise will go directly into the "Inputs" screen

Parameters and Values (as well as Section Headers and Value Expansion details) can be imported into Hexawise from Mind Maps.  Other test plan information such as Invalid Pairs, Married Pairs, Test Cases, Requirements, and Auto-Scripting instructions, and Expected Results cannot be represented in Mind Maps or imported from Mind Maps into Hexawise.

Once you have your Excel plan or Mind Map ready and in an acceptable format, you can import it by following these five steps:

1) Click "New Plan."

2) Name the new plan.

3) Select the project.

4) Select the file to be imported.

5) Click "Create."

Useful troubleshooting tip: to ensure your Excel file is properly formatted for a trouble-free import, follow these instructions:

1) Open the New Plan dialog based on the images above

2) Click "what kind of files?" next to "Optional import file."

3) Read the "Import File Help" pop-up.

       a. Optionally download the easy-to-modify template by clicking "this Excel example."

Using this approach will help keep your file in the format that Hexawise expects it to be.  Remember, (a) the only acceptable file format from Excel is .xlsx Workbook, and (b) this feature is still pretty inflexible.

Update - Requirement Import

Lastly, there is a separate import feature on the Requirements tab that allows you to upload data-driven scenarios to Hexawise. Once you navigate to the screen, you should see the icon on the left side.

Clicking it opens the dialog similar to the plan import.

As before, we recommend using the template (you can download it from the link at the top of the dialog) and pasting your scenarios in the table format to the cell D1 (given you have parameter names).


If you've tried these instructions and you still can't get the file to import properly, perhaps you are getting a message saying something like: "You are not allowed to upload "pdf" files, allowed types: [".xlsx", "opml"] " or " Unable to Create the Plan - could not import the file you provided. Please check that it is in the proper file format and that it contains the necessary information." In that case, please email your Excel file to Support at Hexawise ( and we'll try to help you upload it into your account.

Did this answer your question?