Pixnub Home Forums Sports Photo Automation CSV setup for multiple images/composites of the same player Reply To: CSV setup for multiple images/composites of the same player

#7035021
Angelo McComis
Participant

    If you have Microsoft Excel, there’s a way to take data that has a field with comma-separated values (e.g.  img1.jpg,img2.jpg,img3.jpg) and unpack that to separate rows, which is what SPA needs (per Damon’s “one row per composite” mantra).

    Although I know how to do this, I struggle to explain it, so I did a chatgpt run-through, with a shareable link here:
    https://chatgpt.com/share/67c6fba8-e020-8003-9f01-9a0c751722f2  — it shows how to do it in both Excel and Google Sheets.