Free tool that turns a correlation matrix pasted from SPSS, R, jamovi or Excel (full or triangular, with or without headers, decimal commas or significance stars glued to the number) into an APA 7 or Vancouver table: table number and italic title above, M and SD as first columns, lower triangle only with a dash on the diagonal, significance stars and the note "* p < .05. ** p < .01. *** p < .001." with N. If you do not provide p values, it computes them from r and n with the Student t distribution (t = r·sqrt((n−2)/(1−r²)), df = n−2), matching cor.test() in R, and the 95% CI via the Fisher z transformation. The table copies into Word keeping the horizontal rules (and none vertical) or downloads as a .docx.
Worked example: burnout in 248 healthcare professionals measured with the MBI. Emotional exhaustion correlates r = .58 with depersonalization and r = .86 with the MBI total (both p < .001, three stars); with personal accomplishment, r = −.13 gives p = .041 (one star), and depersonalization with personal accomplishment, r = −.19, gives p = .003 (two stars). The results sentence: "The strongest correlation was between emotional exhaustion and the MBI total, r(246) = .86, p < .001, 95% CI [.82, .89]".
What does APA 7 require in a correlation table? Italic title above, M and SD first, lower triangle with a dash on the diagonal, r and p without the leading zero, and horizontal rules only. What if my journal is biomedical? The Vancouver switch drops the italics, keeps the leading zero (0.58) and can replace the stars with the exact p value of each pair in parentheses.
Paste your matrix from SPSS, R or jamovi and get the correlation table in APA 7 or Vancouver style: M, SD, stars and note. Copy to Word or get the .docx.