20% off Stata Gift Shop purchases through 16 December. Use code GIFT20.
Create Word® and Excel® files
Stata 13 adds tools to put Stata results—estimation results, returned results, matrices, etc.—into Excel and Word documents.
Although these tools were intended for programmers, there is at least one trick that many Stata users will want to know.
First, fit any estimation model in Stata; for example,
. sysuse auto . regress mpg price weight displacement trunk 1.foreign
. putexcel B3 = matrix(r(table)', names) using myresults.xls
Here is what is in myresults.xls:
If myresults.xls had previously existed, it would be modified. If not, it would have been created. You can put many results into the same Excel file.
Of course, these tools will do much more. Read all about them in the Stata manuals:
Stata has long been able to export data to Excel files.
See New in Stata 18 to learn about what was added in Stata 18.
Classroom and web training
Teaching with Stata
Statalist: The Stata Forum
Last updated: 16 November 2022
StataCorp LLC (StataCorp) strives to provide our users with exceptional products and services. To do so, we must collect personal information from you. This information is necessary to conduct business with our existing and potential customers. We collect and use this information only where we may legally do so. This policy explains what personal information we collect, how we use it, and what rights you have to that information.
These cookies are essential for our website to function and do not store any personally identifiable information. These cookies cannot be disabled.
Please note: Clearing your browser cookies at any time will undo preferences saved here. The option selected here will apply only to the device you are currently using.