When using SPM (Statistical Parametric Mapping) for the analysis of fMRI data, one soon or later needs to export the numbers in the "SPM Results Table" to a spreadsheet format to include in a publication. While the SPM Table is neatly organized within a Matlab Figure, it is not easy to export the numbers to a friendly format.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiBp-7TMEiWN8ZFlMn1KRZorlip4M80yZd9BFOJkJWBcD-p2W-AMNy9Gl7ytt5tSfWh9EOGIkXOf_QBVB9BdVrlZzYovHa4L71gEQF9XdAPt4YPDV_gxkq-3tVB6dXYZg6Wnt0JZq0ESW8/s640/SPMTable_BasicModel.png) |
SPM results table. |
H
ere is a small Matlab function that simplifies the process. It neatly dumps all values in an SPM table into a .txt file.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXB9tuNAc1zdA_rpmE9dbw_ogMjHpHPxg-mcOmFbueVXqWlrfo01R6vpDAHe9VfhrYnDK3kUGEOL2qxZWOdzy8QRIkvWQ60ImSYX0BnakdCGZZaSm1hSCLWVL4FR52r0RIwvjlFPfqWEE/s640/Screen+Shot+2018-02-24+at+12.37.11.png) |
Same table in the text editor. |
You can then easily import this text file to your spreadsheet engine (excel, gdoc, etc.) as a tab separated .txt file. With little cosmetic efforts, it is ready to be inserted in your next publication.