Title | Converting other format files into Stata dataset files | |
Author | Kevin Crow, StataCorp |
Stata 18 supports importing data in a variety of formats:
import excel reads worksheets from Microsoft Excel (.xls and .xlsx) files.
import delimited reads text files containing data delimited by tabs, commas, or a custom delimiter.
odbc allows you to import data from Open DataBase Connectivity (ODBC) sources into Stata.
jdbc allows you to import data using Java DataBase Connectivity (JDBC) into Stata.
infile (fixed format or free format) allows you to read text files containing fixed-format or free-format data.
import sas reads Version 7 SAS (.sas7bdat) files, and will also read value-label information from a .sas7bcat file.
import sasxport8 reads SAS XPORT Version 8 Transport format files.
import sasxport5 will read SAS XPORT Version 5 Transport format files, and will also read value-label information from a formats.xpf XPORT file.
import spss reads IBM SPSS Statistics (.sav and .zsav) files.
import fred reads Federal Reserve Economic Data; you must have a valid API key obtained from the St. Louis Federal Reserve.
import haver (Windows only) reads Haver Analytics database files.
import dbase reads a version III or version IV dBase (.dbf) file.
spshape2dta translates the .dbf and .shp files of a shapefile into two Stata datasets.
Alternatively, you could purchase a separate data conversion package if none of the above options are applicable to the data you wish to import. Before exploring such an option, check the export options of any other package you may be using. Most packages support exporting to some form of text file which Stata can import or one of the above formats.
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.