Every entry is only supposed to be a single line. There can be no multiline entries.
I apologize for the previous brevity of the intended workflow. Maybe the following will help out more.
Alignments are supposed to be set up by labels created with any regular title template.
I realize the layout part of this endeavor is a little annoying, but compared to the alternative of creating an individual "card" for each data set, it's nothing.
Most spreadsheet data looks something like this (this is all made up data I downloaded as a sample):
Creating a list is phenomenally easy (depending on your spreadsheet setup. All the data points in this sheet are "single line". Just copy the entries from your columns (click and drag down the column) and paste them into Selectable list Data Entry. They will paste into the parameter as separate individual lines of text. (There should be a newline at the end of the last entry). In this example, addresses are split up into Street, City, County, and State. In a "work copy" of the spreadsheet, I deleted the County column, selected City State and Zip and pasted into BBEdit which formatted the text as City[tab]State[tab]Zip[newline]. I created a regex that would find the tabs, replace one of them with a ',' and the other with a space, then copied the list from BBEdit into Selectable List. [the "grep" Find pattern looks like: ^([^\t]+)\t(\w+)\t\s*(\d+)\n and the replace pattern looks like: \1, \2 \3\n — in case you need it.] You might be able to Merge columns of data, but I don't really know how that works out.
You add another Selectable List effect for each type of data. [You could just format the data as one long string and set it up to display like that. eg: CoName - 123 Street - City, State Zip - Phone - Note.]
All the Selectable List effects you add to a single clip (title, generator, image or video) can be saved as a "single effect" (Effect Preset) so that it can be applied to another clip, altogether at the same time with all the data you've inputted.
I have found that if you keyframe the individual Data Point parameters over a range of frames, you can create a synchronized image sequence (you may have to export the clip and use another application to create a PNG image sequence if you need transparency). If you use this on a Basic Title, you can export with full transparency to create overlays if you want video backgrounds.
[I actually have another product that will let you set which frame you want to display, like a freeze frame but it doesn't cut the clip or require any other modifications... you don't absolutely need it but it is a way to control the Data Point parameters of all the individual effects without exporting media, creating an image sequence, etc... everything is handled right in the same clip all the effects are added to. It's called S•C Retimer and it was designed to do all kinds of fun and interesting things - but it does none of those things automatically. At its most basic, it simply displays the frame "under the Playhead" parameter (not the same playhead as the storyline playhead!) You just add it as another effect at the end, and set the playhead value to display the frame you want - it lasts the entire duration of your clip.]
I've already created an update to Selectable List (which I will email you shortly). It increases the number of Data Entry lines supported (100). It gets rid of the Fade functions and replaces it with Text and (optional) Outline Color. If you need fading, that can actually be done with Shape Masks for each individual Selectable List effect. I also added an OnScreen Control to drag and place the text [you will have to change the cursor tool from Select (A) to Blade (B), Trim (T), Hand (H), Range (R) or Position (P) in order to gain access to the OSC - Text objects take priority with the Select tool is active. The letters in parentheses are the keyboard shortcuts to change the current tool.]
If you don't want to deal with all the overhead with this effect, I just coincidentally saw this show up on my twitter feed today:
https://www.fcp.co/motion/tutorials-for-apple-motion/2371-create-multiple-motion-projects-including-text-media-assets-from-csv-files-with-csv-to-motn-v2-5
