Skip to content

Problem: Save cross-tab to Excel results in weird column names

This situation happens in the when your perform the Graph Cross-tab Questions action and then choose the Save As action from the button bar and save to an Excel spreadsheet format. The resulting spreadsheet has weird column names.

The recommended way to resolve this is:
  1. While viewing your cross-tab questions, perform the Save As action via the button bar.
  2. When the Save As window appears, change the "Save as type:" to HTML table.
  3. Enter the "File name:" value and make sure to append .xls to the end of the file name.
  4. Select the Save button to save the file.
  5. Using Windows File Explorer, navigate to the file and open it.
  6. When Excel displays a message stating that the file is in a different format than specified by the file extension, select Yes to proceed in opening the file.

Feedback and Knowledge Base