Export a Crosstab CSV

The CSV export of the crosstab results is organized by Control, Column, and Row, in that order. The variable names display as the first 1, 2, or 3, column headers.

NOTE: If you want the exact table from the crosstab results to display in Excel or Word, then copy the text from the results and paste them into Excel/Word. See the FAQs if you have issues copying and pasting the table.

  1. After running a crosstab, click the Export Table Data as CSV link below the table.
    Image of Export Table Data as CSV Link
  2. The data exports to a CSV file, which opens in Microsoft Excel.
    NOTE: All related data will automatically display in the CSV file, even if the checkboxes (such as Confidence Intervals and Standard Errors) were unchecked in the results.
  3. To create graphs based on this data, perform the following:
    1. Delete any columns or rows that you do not want to display on the graph. For example, if you do not want the totals on the graph, then delete the "Overall" rows.
    2. Highlight the appropriate columns (click the letter above the column header to highlight the entire column) and hit CTRL to select multiple columns.
    3. Under the Insert tab on the ribbon, click Recommended Charts.
      Image of Excel Ribbon Menu Options
    4. On the Insert Chart window, select the appropriate chart type and click OK.
      Image of Insert Chart Window
    5. The chart and related data display on a new worksheet.
      Image of New Worksheet Example
    6. Further manipulate the graph by using the Analyze, Design, and Format tabs on the ribbon. Or right-click the graph and select Change Chart Type or Select Data.
      NOTE: Refer to the Microsoft Excel help for more information on manipulating graphs.