Importing
Any text-delimited file (*.csv, *.txt, etc.)
Preview lets you see how the data will look in Stata even before you import them, even from data on the Internet
Automatic delimiter detection for commas, tabs, semicolons, colons, and pipes
May specify delimiter, including multiple-character delimiters
May specify multiple delimiters
Variable names may be on any row in the file
Import selected row ranges
Import selected column ranges
Automatic storage types
Inspect and manually control data types for each column if desired
Support for long strings
Double quotes to delimit strings
Allows "" to mean real double quotes in data (as used by Excel)
Numeric parsing for different numeric formats is supported based on locale
Automatic encoding detection
Exporting
May specify delimiter
Optionally save variable names in first row of data
Support for long strings
The commands for easily importing and exporting data to and from Stata are import delimited and export delimited.
import delimited is the star of the two. Exporting from Stata has always been easy.
Do you see the preview at the bottom of the screenshot? We have not yet imported any data! We are in the process of filling in the dialog box. As we work, we see exactly how our data would look if we were to import them into Stata using the current settings.
Learn
Free webinars
NetCourses
Classroom and web training
Organizational training
Video tutorials
Third-party courses
Web resources
Teaching with Stata
© Copyright 1996–2024 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.