FAQ

How the output workbook works

The translated workbook is designed for analysis first. Metadata stays close by, but it does not pollute the main dataset sheet.

Why does the workbook have multiple sheets?

Spreadsheet files do not have native variable labels the way Stata does. So DataTranslator puts the analysis-ready data in one sheet and the translated metadata in separate sheets.

  • `dataset`: the translated data you analyze
  • `variable_labels`: translated question text / variable labels
  • `value_labels`: translated categorical label mappings

What happened to row 2 from Qualtrics?

Row 2 question wording is moved into `variable_labels`. The `dataset` sheet stays clean so R, Stata, and other tools can read it naturally.

How do I read the workbook in R?

Use the `readxl` package and read the `dataset` sheet by default. Pull the other sheets when you want metadata.

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 in the dataset output, but their contents are not translated. They are also marked in the metadata.

Back to upload