What you get back

What do I get after payment?

You unlock the full translated output for your file. Stata uploads get a translated `.dta` plus a translated Excel workbook. Excel and CSV uploads get a translated workbook plus the translated Excel workbook for review and sharing.

Why does the Excel file have multiple sheets?

Excel does not store survey labels the same way Stata does, so the workbook separates the translated data from the translated question and answer guides.

• The first sheet contains the translated data.
• The second sheet lists translated question text.
• The third sheet lists translated answer labels.

What happened to row 2 from Qualtrics?

Qualtrics often stores question wording in a second row. DataTranslator moves that wording into the label guide so the main data stays clean for R, Stata, and Excel.

How do I read the workbook in R?

Use the `readxl` package and read the first sheet for the data. The other sheets act as a label dictionary for readable factors, graphs, and tables.

library(readxl)

df <- read_excel("translated_workbook.xlsx", sheet = "dataset")
variable_labels <- read_excel("translated_workbook.xlsx", sheet = "variable_labels")
value_labels <- read_excel("translated_workbook.xlsx", sheet = "value_labels")

Are admin columns removed?

No. Admin columns are preserved so your file stays complete. We focus translation on survey questions and answer labels.