»  Home »  Products »  Features »  Importing and exporting text-delimited data
ORDER STATA

Importing and exporting text-delimited data


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, 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
  • Exporting
    • May specify delimiter
    • Optionally save variable names in first row of data
    • Support for long strings

Show me

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.

Show me more

See the import and export delimited manual entry.

There's an import excel, too.

Stata

Shop

Support

Company


The Stata Blog: Not Elsewhere Classified Find us on Facebook Follow us on Twitter LinkedIn YouTube Instagram
© Copyright 1996–2019 StataCorp LLC   •   Terms of use   •   Privacy   •   Contact us