Tips for Researchers

Formatting APA Correlation Tables from SPSS

Recently, I became fed up with spending time formatting correlations tables from SPSS output into APA 6th edition format. I’ve created an excel sheet that does it automatically for you – all you have to do is paste in the SPSS-generated correlation table into the second tab, and the data is pulled and formatted correctly in the third tab (instructions in the first tab). I hope this can save all of us some time!

Download it here: Formatting Correlation Tables Automatically from SPSS


How to fix the “issue numbers” problem in EndNote for APA 6th

EndNote APA 6th edition includes issues numbers, even though these should only be included in the rare case when the journal is paginated by issue (i.e., each issue begins with page 1).

1) In EndNote, Edit –> Preferences

  • Reference Types –> Modify Reference Types
    • Name Custom 3 as “IssueAPA” (or whatever makes sense to you)
    • Save and Apply these Changes

2) Edit –> Output Styles –> Edit APA 6th

  • Biblography –> Templates
  • Find the “Journal Article” template
  • Replace (Issue) with (IssueAPA) [or whatever you named Custom 3]
  • Save As as new style (e.g., APA 6th USE ME)

3) When you actually need an issue number in your citation, copy and paste it in the IssueAPA field. Otherwise, this field will remain blank and thus the issue number won’t appear (as you’ve kept the original issue field but edited it out of the template).