Export Facets Tables and other files to Excel, SPSS or Word

Output Facets Table to Excel

1.In the Facets output report, locate the Facets Table that contains the numbers you want for your Excel analysis

2.Copy the rows containing the numbers you want from Facets Output Tables in NotePad into an Excel worksheet

3.In Excel, "Data", "Text to Columns" to put the numbers into columns

4.Save the Excel file

 

Output Facets Table to SPSS

1.In the Facets output report, locate the Facets Table that contains the numbers you want for your SPSS analysis

2.Copy the rows containing the numbers you want from Facets Output Tables in NotePad into an Excel worksheet

3.In Excel, "Data", "Text to Columns" to put the numbers into columns (SPSS variables)

4.Save the Excel file

5.SPSS can open the EXCEL file.

 

Output Facets Table to Word

1.In the Facets output report, locate the Facets Table that contains the numbers you want for your Word document

2.Highlight its columns by dragging your Mouse

3.Copy (ctrl+c)

4.In your Word document, paste (ctrl+v) the Facets Table.

5.Highlight the Facets Table

6. Change the font to Courier New (or another fixed-space font).