I have developed the Generic Excel importer, so no need to worry about the format of the excel just create the excel file and direct import by selecting the correct Table and field name
Generic Excel Importer in Business Central Import data in Business Central table without worrying about the excel file format.
You can import any excel file Choose the table no. in Excel import journal no need to choose and select the table field manually.
It has facility to choose the field name according to the excel columns we imported (90% success).
Choose in which field data is required, by Check mark on Select column
See the video.