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://1.bp.blogspot.com/-jjcOuWGMioQ/WpFLiRSfz5I/AAAAAAABdH0/EW984th3FE4yn7v4uQpQiNYL6AWPGYyBACLcBGAs/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://4.bp.blogspot.com/-aiV_GxVxxkQ/WpFOiqqeCFI/AAAAAAABdIA/NmwTWgWoG10fJPBqCv9Fo4ok4p_5r-ysgCLcBGAs/s640/Screen%2BShot%2B2018-02-24%2Bat%2B12.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.