Training

How To Import Data from Microsoft Excel

Heat Map Explorer supports Microsoft Excel 97-2003, 2007, and 2010 formats. To import your data into Heat Map Explorer, do the following:

  1. Prepare your spreadsheet data for importing. Heat Map Explorer expects column headings in the first row, followed by rows of data. It also expects numeric columns to contain only numbers. See how to adjust headings, remove footers, and format data for importing.
  2. Before prepping for import

    Before prepping for import

    After prepping for import

    After prepping for import

  3. Launch Heat Map Explorer, then click Create a New Heat Map. (If you’ve already launched Heat Map Explorer, click the New Heat Map button on the toolbar.)
  4. For Professional Edition only: Select Microsoft Excel Spreadsheet as the data source, then click Next.
  5. Browse to select the spreadsheet file to open, then click Next.
  6. Select the spreadsheet data to import.

    The first worksheet is selected by default. If your spreadsheet contains multiple worksheets, you can select the one to import from.

    Heat Map Explorer fills in the header row and data range based on a tabular format (i.e., column headings in in row 1, followed by rows of data). If your data is not in this format, you need to enter the correct heading and data ranges. Then click Next to import.

    Be sure heading and data ranges are correct

    Be sure heading and data ranges are correct

  7. Edit the mappings for size, color, label and grouping used to create the heat map (you can change these later), if necessary.
  8. Click Finish to create your heat map.