Hello, I'm a musician and as in the 1st picture, Excel is the platform that we use to share our playlists with other musicians. And using this data on Excel, I prepare myself cards on Word like in the 2nd picture. And I make them a pdf and view them on stage via iphone or ipad...



So my first question is; instead of me reading the data from Excel and writing all of them into Word one by one, is it possible to retrieve the data from Excel file and put them into the related places in Word automatically?

And here comes my second question; is there an easier way of preparing cards like this other than using Word? For example if there were boxes for every type of information on a single card, then I wouldn't have to worry about sizing or coloring them each time...


Thank you!
Umut