🌱 Leadership Assessment Data Converter

Convert Formspree emails to Excel-ready tab-separated format

📋 Excel Header Setup:
SSL Sheet: email age consent q1 q2 q3 q4 q5 q6 q7 q8 q9 q10 q11 q12 q13 q14 q15
PMQ Sheet: See instructions in PMQ tab below
DHI Sheet: See instructions in DHI tab below

📧 SSL - Story Seeds of Leadership (Part I)

Formspree ID: mdkyownr

Instructions:

  1. In Excel, create headers (Row 1): email age consent q1 q2 q3 q4 q5 q6 q7 q8 q9 q10 q11 q12 q13 q14 q15
  2. Copy the SSL email notification from Formspree
  3. Paste it in the box below
  4. Click "Convert SSL Data"
  5. Click "Copy to Clipboard"
  6. In Excel: Click cell A2 (first data row), press Ctrl+V (or Cmd+V on Mac)

Total columns: 18 (email, age, consent, 15 questions)

🧘 PMQ - Personal Mindfulness Quotient (Part II)

Formspree ID: xyzlynyz

Instructions:

  1. In Excel, create headers (Row 1):
    email timestamp total_score characterize_score externalize_score sympathize_score revise_score strategize_score rehistoricize_score publicize_score western_mindfulness_score q1 q2 q3 q4 q5 q6 q7 q8 q9 q10 q11 q12 q13 q14 q15 q16 q17 q18 q19 q20 q21 q22 q23 q24 q25 q26 q27 q28 ssl_q1 ssl_q2 ssl_q3 ssl_q4 ssl_q5 ssl_q6 ssl_q7 ssl_q8 ssl_q9 ssl_q10 ssl_q11 ssl_q12 ssl_q13 ssl_q14 ssl_q15
  2. Copy the PMQ email notification from Formspree
  3. Paste it in the box below
  4. Click "Convert PMQ Data"
  5. Click "Copy to Clipboard"
  6. In Excel: Click cell A2, press Ctrl+V

Total columns: 52 (1 email, 1 timestamp, 8 PMQ scores, 28 PMQ questions, 15 SSL questions)

Note: Includes SSL Part I data (ssl_q1 through ssl_q15) carried forward

💬 DHI - Dialogue Health Index (Part III)

Formspree ID: xkgknqnv

Instructions:

  1. In Excel, create headers (Row 1):
    email organization role industry timestamp total_score section1_score section2_score section3_score section4_score section5_score q1 q2 q3 q4 q5 q6 q7 q8 q9 q10 q11 q12 q13 q14 q15 ssl_q1 ssl_q2 ssl_q3 ssl_q4 ssl_q5 ssl_q6 ssl_q7 ssl_q8 ssl_q9 ssl_q10 ssl_q11 ssl_q12 ssl_q13 ssl_q14 ssl_q15 pmq_q1 pmq_q2 pmq_q3 pmq_q4 pmq_q5 pmq_q6 pmq_q7 pmq_q8 pmq_q9 pmq_q10 pmq_q11 pmq_q12 pmq_q13 pmq_q14 pmq_q15 pmq_q16 pmq_q17 pmq_q18 pmq_q19 pmq_q20 pmq_q21 pmq_q22 pmq_q23 pmq_q24 pmq_q25 pmq_q26 pmq_q27 pmq_q28 pmq_total pmq_section1 pmq_section2 pmq_section3 pmq_section4 pmq_section5 pmq_section6 pmq_section7 pmq_section8
  2. Copy the DHI email notification from Formspree
  3. Paste it in the box below
  4. Click "Convert DHI Data"
  5. Click "Copy to Clipboard"
  6. In Excel: Click cell A2, press Ctrl+V

Total columns: 77 (5 DHI info, 1 timestamp, 6 DHI scores, 15 DHI questions, 15 SSL questions, 28 PMQ questions, 9 PMQ scores)

Note: Includes complete data from all three parts (SSL + PMQ + DHI)

✅ Converted Data (Tab-Separated)

Copy this and paste into Excel starting at cell A2:

Summary