Lexia Tech Note #100305

Creating a Tab-Delimited File for Import into Lexia

Lexia Programs:

  • Early Reading 3.x
  • Primary Reading 1.x
  • Phonics-Based Reading 4
  • Strategies for Older Students 4.x

Version:

  • Early Reading 3.x
  • Primary Reading 1.x
  • Phonics-Based Reading 4
  • Strategies for Older Students 4.x

Platforms Affected:

  • All Platforms

Description:

To import a non-Lexia file into a Lexia database, you need a tab-delimited file. Tab-delimited files can be created from Excel files, other spreadsheet programs, or database programs, but they must be converted to text files, with a .txt extension. The field headers are essential to the import process and are case-sensitive; therefore, be sure to enter your header line to match the labels in bold, listed below. Your file must include every field, though some of the fields can be empty.

In addition, the fields must be in the following order:

  1. Student ID – Data required, any number from 1 to 99,999
  2. First Name – Data required
  3. MI – No data required (an empty field is sufficient.)
  4. Last Name – Data required
  5. Suffix – Jr., III, etc.
  6. Username – Data required (must be unique)
  7. Password – No data required (an empty field is sufficient)
  8. Date of Birth – Format is mm/dd/yyyy. No data required, an empty field is sufficient
  9. Sex – Value is M or F. No data required, an empty field is sufficient
  10. Grade – Value is K–12. No data required, an empty field is sufficient
  11. Class – If this doesn’t exist already, it will be created
  12. School – Must match name of school listed on MyLexia.com

Note that student data can include upper- and/or lower-case letters, whereas the field labels on the first line must match the labels listed in bold exactly.

Keywords:

import, export, tab-delimited