Paste data in named range

Dear forum,

To create a robust template used by other users, I would like to have your expert view on a part of the workflow.

My part: create from SQL a .csv file with fixed columns, dynamic rows and send to other users.
Their part: get this data in a pre-made template sheet in a named range.

The problem:
- the template is send in advance
- we cannot use VBA
- the user might only be familiar with copy and pasting
- The user might not handle named ranges properly or correctly edit them

How do I get the most robust WF?

Thank you in advance,

Max