Search
   >> Home >> Products >> Features >> Excel® import/export
Order Stata

Excel® import and export


Stata for Windows, Mac, and Linux can directly import data and export data and results to Microsoft Excel files. Both Excel 1997/2003 (.xls) files and Excel 2007/2010/2013 (.xlsx) files are supported.

Above you see the preview tool, which you can use to see the data in an Excel worksheet before importing it and adjust options controlling how the data are imported.

import excel features

  • .xls and .xlsx support
  • import any worksheet from a workbook with multiple worksheets
  • import a custom cell range
  • treat first row of Excel data as Stata variable names
  • automatic conversion of Excel dates to Stata dates
  • automatic optimization of Stata storage types

export excel features

  • .xls and .xlsx support
  • replace an entire workbook
  • add a worksheet to an existing workbook
  • replace a single worksheet within an existing workbook
  • modify a subset of cells within an existing worksheet
  • save Stata variable names or variable labels to first row of worksheet
  • automatic conversion of Stata dates to Excel dates
  • export value labels or the underlying values
  • specify a custom missing-value code to use in worksheet

putexcel features

  • .xls and .xlsx support
  • export Stata returned results to a worksheet
  • export a Stata matrix in memory to a worksheet
  • export a custom numeric or string expression
  • insert a Stata graph or any PNG, JPEG, WMF, or TIFF file to a worksheet
  • create cell formulas in a worksheet
  • format cells in a worksheet
    • number formats
    • cell border style and color
    • horizontal and vertical alignment
    • fill patterns and foreground/background color
  • font formatting
    • font, font size, font color
    • bold, italic, strikeout, underline
    • subscrips
    • text wrapping, text indent, text rotation
  • replace an entire workbook
  • add a worksheet to an existing workbook
  • replace a single worksheet within an existing workbook
  • modify a subset of cells within an existing worksheet

produces this

And if we have the following Excel worksheet,

we can bold the column titles with the command

. putexcel (A1:B1)=bold("on") using myhcahps.xlsx, modify

add a solid black border below the column titles and on the right side of the State column with the commands

. putexcel (A1:B1)=border("bottom", "medium", "black") using myhcahps.xlsx, modify

. putexcel (A1:A6)=border("right", "medium", "black") using myhcahps.xlsx, modify

format the Average Response column as a percent:

. putexcel (B2:B6)=nformat("percent") using myhcahps.xlsx, modify

and insert a Stata bar graph, bar1.png, into the worksheet:

. putexcel (B8)=picture("bar1.png") using myhcahps.xlsx, modify

The result is

Excel is a registered trademark of Microsoft.

Explore more data management features in Stata.

The Stata Blog: Not Elsewhere Classified Find us on Facebook Follow us on Twitter LinkedIn Google+ Watch us on YouTube