Can you turn the data from an excel file to a neatly laid out word document

Yes it's possible, although there are a few limitations. If you're ok with outputting non-editable pdfs rather than word docs I strongly advise mail merge - it's made for mass-outputting customised letters, labels or emails but could easily be adapted to do your resource packs. Use the 'letters' option then print to pdf - it is a pity it doesn't have a 'save to document' option.

If you really do need them as editable word docs once they've been output, this thread provides an answer where you output to email but first put outlook in offline mode so the emails don't actually send anywhere - you could then move them back to drafts, copy the content out to word docs and svae individually.

let me know what approach you end up taking!