Highlights

Importing

Any text-delimited file (*.csv, *.txt, etc.)

Preview lets you see how the data will look in Stata even before you import them

Default delimiter is a comma

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

Force specific columns to be numeric or string

Support for long strings

Double quotes to delimit strings

Allows “” to mean real double quotes in data (as used by Excel)

Exporting

May specify delimiter

Optionally save variable names in first row of data

Support for long strings

 

See the video

 

video: Importing and exporting text-delimited data

 

Show me

 

The new 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.