1 item has been added to your cart.
20% off Stata Gift Shop purchases through 16 December. Use code GIFT20.
Create Word® and Excel® files | ORDER STATA |
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
Then type
. 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:
Export results to an Excel file
Generate Office Open XML (.docx) files
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.
Learn
NetCourses
Classroom and web training
Organizational training
Webinars
Video tutorials
Third-party courses
Web resources
Teaching with Stata
© Copyright 1996–2023 StataCorp LLC. All rights reserved.
×
We use cookies to ensure that we give you the best experience on our website—to enhance site navigation, to analyze usage, and to assist in our marketing efforts. By continuing to use our site, you consent to the storing of cookies on your device and agree to delivery of content, including web fonts and JavaScript, from third party web services.
Cookie Settings
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.
This website uses cookies to provide you with a better user experience. A cookie is a small piece of data our website stores on a site visitor's hard drive and accesses each time you visit so we can improve your access to our site, better understand how you use our site, and serve you content that may be of interest to you. For instance, we store a cookie when you log in to our shopping cart so that we can maintain your shopping cart should you not complete checkout. These cookies do not directly store your personal information, but they do support the ability to uniquely identify your internet browser and device.
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.