Ingest lexile data

Owned by Tim Peterson
Last updated: Dec 26, 2023
2 min read

The products-lexile template is a subset of the products template. It can only be used to update product records, not create product records.

When you've received Lexile, you should update the website database. This page explains that process using a Google Doc template. Google Doc is not mandatory; you can follow the same procedure using any modern spreadsheet application that can save data as CSV (comma-separated values).

  1. Open Excel data file from Lexile.

  2. Create a new Google Doc spreadsheet using the products-lexile template file (See menu item: File > Make a Copy…). The required columns are: isbn, lexile. The word_count column is optional.

  3. Copy/paste data from Excel to the new Google Doc file.

  4. Once complete, download the new Google Doc file as CSV to your local computer (See menu item: File > Download as > Comma Separated Values). Name the local file without spaces. For example: products-lexile-YYYYMMDD.csv (where YYYYMMDD represents today's date)

  5. Ingest the local file through the web admin UI of the titleleaf site:

    a. Admin > Ingestion > New

    b. Type = Products

    c. Attachment = products-lexile-YYYYMMDD.csv

TitleLeaf • Status