Insert datatable data to Microsoft Business Central


I have looked into updating the table through webservices, but the table can’t be published, so I’m back scratch.

I made the workflow type into every field in every line, but my idea was to build a DT and then paste it into BC, but the formatting is incorrect and BC doesn’t recognize the data as valid. it comes with an error saying that 8 lines cant be pasted into 1 line.

It’s possible to copy an Excel sheet by selecting the range and Ctrl C, and then paste it in, using Ctrl Shift V - how can this be made so that the format is preserved.