Convert DTA to XLSX

Turn DTA files into XLSX. One sheet named Data with the variable names as a bold header row and numbers as number cells.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop DTA files on the dialor turn it to pick what to do

Stata data in an Excel sheet.One sheet with your variable names as a bold header row.

  1. What you get

    An Excel workbook with one sheet named Data. The first row holds the variable names in bold. Each row below it is one record from the dataset.

    Numbers are stored as number cells, so you can sort, filter and calculate on them right away.

  2. What it leaves behind

    Value labels are dropped. A coded answer, such as 1 for yes and 2 for no, stays as the number and does not turn into its label.

    Variable labels and missing-value definitions are dropped too. The workbook holds the names and the values, and nothing else about how the dataset describes them.

  3. When a conversion fails

    If the file cannot be parsed, the conversion stops with input_corrupted. This means the DTA file itself could not be read.

DTA and XLSX.What each format is.

The formats

From · DTA

Stata Data

Stata datasets.

Extensions
.dta
MIME type
application/x-stata-dta
Kind
Text and data
To · XLSX

Excel Workbook

Excel's workbook format since 2007. Sheets, formulas, formats and charts in zipped XML.

Extensions
.xlsx
MIME type
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Kind
Documents

In your code.The same DTA to XLSX conversion through the API, for your app or your agent.

terminal
$ cv convert report.dta report.xlsx
$ cv convert report.dta report.xlsx

Questions.What people ask about DTA to XLSX.

01OF 04

No. Value labels are dropped, so coded answers stay as numbers. Keep your codebook nearby to read them.

One. It is named Data and holds the whole dataset.

Yes. They become the header row, in bold. The longer variable labels are not kept.

Yes. Once you have the XLSX file, you can merge XLSX files into one.

More conversions.Other ways in and out of DTA and XLSX.