How do I avoid errors in my DPRP CSV file?
The short answer
CDC's answerSave the file as CSV with all the data on a single sheet, with Table 5's column names in Table 5's order, every value coded right, and no invalid dates or blank rows. Leave out all personally identifiable information.
- Data specialist
The answer
The CSC article and the Standards list the common errors. Check these before you upload:
- Save the file in CSV format. On an Apple computer, choose CSV (Comma Delimited).
- Keep all the data on 1 sheet. A CSV file holds a single tab.
- Use the variable names, codes and values of Table 5, the Data Dictionary. Keep their spelling, and put the columns in Table 5's order.
- Include every data element that applies, and code each one correctly.
- Check for invalid dates, typos and blank rows.
- Send no personally identifiable information about participants or Lifestyle Coaches.
- Correct what the portal flags after you upload. Once the CDC accepts a file, it cannot be submitted again.
How Lukio does it
Export the CDC file
In Lukio, the CDC file page makes the file you send to the CDC from your session records, and the count beside Freeze and download names each record and what it is missing.
Steps: Export the CDC fileAnswer the checks
In Lukio, Checks on each session flag a weight that changed too fast, more activity minutes than a person could do, or a person marked present with no weight, for you to fix or accept.
Steps: Answer the checksWhere this comes from
This answer draws on the CDC National DPP Customer Service Center's article Guidance for Submitting Data to the DPRP Data Submission and Administration Portal and the CDC Diabetes Prevention Recognition Program Standards and Operating Procedures (2024). Those are the authority; this page says how Lukio applies them. Use of this material does not imply endorsement by CDC, HHS or the U.S. Government of Lukio or its services.
From the article:
Files must be in CSV format. If using an Apple computer, the format should be CSV (Comma Delimited) and not CSV (Mac).
In the CDC Diabetes Prevention Recognition Program Standards and Operating Procedures (2024): page 30.
For a question about your own program, ask CDC. Open Technical Assistance Support in the CDC National DPP Customer Service Center, or write to NationalDPPAsk@cdc.gov. For a question about your data file, write to the DPRP at DPRPdata@cdc.gov.
Last updated November 15, 2026.
More in Data collection and the CDC submission
New to Lukio?
Lukio keeps your National Diabetes Prevention Program's records, from the first registration to the CDC data file.
Other organizations offer tools and services for National DPP programs too, such as Welld Health, HabitNu and the American Diabetes Association's DPP Express. Each works its own way. If Lukio's way fits your program, we're here to help.
All questions in Data collection and the CDC submission.
To reach a person, open Lukio support.