Q: What should I do if the data I entered into the “Data” spreadsheet is not displayed in the text file?
A: Verify the following:
- The Respondent ID is entered in each row where there is data.
- The data were entered in consecutive rows, without skipping rows. The embedded code in the 2017 LAR Formatting Tool will stop extracting data upon encountering the first blank row of the LAR. Therefore, any data entered after the blank row in the LAR will not be extracted.
Once these issues have been resolved, please select the “Create LAR File” button to extract the data.