Convert DTA to NUMBERS

Turn DTA files into NUMBERS. 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 a Numbers sheet.The variables become columns on one sheet. The labels stay behind.

  1. What you get

    A Numbers spreadsheet with one sheet named Data. The variable names sit in a bold header row, and the values below them are number cells, so you can sort and calculate right away.

    The conversion produces one file.

  2. What it leaves behind

    Value labels, variable labels and missing-value definitions are dropped. A coded answer stays a number, so a 1 or a 2 does not turn back into its text label. Keep the codebook next to the file if you need to read the codes.

    Numbers keep 15 significant digits. Fonts that Numbers does not have become Helvetica Neue.

  3. Large datasets

    A document of more than 300,000 cells fails with unsupported_elements. The conversion stops with that code when the dataset is over that limit.

    For other conversions of this format, see every DTA conversion. To see what else Numbers can come from, see every NUMBERS conversion.

DTA and NUMBERS.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 · NUMBERS

Apple Numbers

Apple Numbers spreadsheets from macOS and iOS.

Extensions
.numbers
MIME type
application/vnd.apple.numbers
Kind
Documents

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

terminal
$ cv convert report.dta report.numbers
$ cv convert report.dta report.numbers

Questions.What people ask about DTA to NUMBERS.

01OF 04

No. Value labels are dropped, so coded answers stay numbers.

Yes. They become the bold header row on the sheet named Data.

The document has more than 300,000 cells. The conversion stops with that code above that limit.

No. Missing-value definitions are dropped along with the value labels and variable labels.

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