Meemic Foundation Winners CSV to HTML Converter

This tool converts a CSV file from the Meemic Foundation Team into the HTML needed for the Meemic Winners Accordion control.
Just drop a CSV file onto this page, and its contents will be shown.
You can then click the ‘Copy Table to Clipboard’ button to get the table’s HTML code.

The input file requires this format

Column 1 Column 2 Column 3 Column 4 Column 5 Column 6...n
Last Name First Name School City State Blank cells get ignored

Below is the output that the Meemic Winners control is expecting.

Column 1 Column 2 Column 3
Last Name, First Name Nominated School Name City, State

The Meemic Foundation Winners page is located here: https://www.meemicfoundation.org/recipients/popin-winners

Meemic Foundation Winners List Webpage

Steps to add an Accordion Item to the Meemic Foundation Winners List Webpage:

  1. Get the Accordion Title:
    • Get the title from the ticket or the Meemic Foundation home page: Meemic Foundation.
    • The title format should be: <Month Year> PopIn2Win Grant Winners - <PopIn2Win Title>.
    • The <PopIn2Win Title> can usually be found in the grant section on the right side of the page.
    • Example: February 2025 PopIn2Win Grant Winners - RBI 25-Player Basic Percussion Instruments Kit.
  2. Open the PopIn-Winners Page in AEM (Author):
  3. Modify the Accordion:
    • Add a new accordion item.
  4. Enter the Accordion Title:
    • Use the title from Step 1.
    • Scroll to the Description section and click the "Source Edit" icon.
  5. Open the Winners List Tool in a Separate Browser Window:
  6. Upload the CSV File:
    • Open your file explorer and drag and drop the CSV file onto the Winners List Tool Drop Zone.
    • The contents of the file will display on the page, and the "Copy Table to Clipboard" button will become enabled.
  7. Copy and Paste the Table:
    • Click the "Copy Table to Clipboard" button.
    • Paste the clipboard content into the Description text area in the control, then click the "Source Edit" icon.
  8. Save and Reorder:
    • Drag the new accordion section to the top.
    • Click the checkmark in the upper right to save.
    • Note: Drag one accordion position at a time.
Drop the Meemic Foundation Winners CSV file here

 

Table HTML copied to clipboard!