How to import data from unique Excel Spreadsheets to MySql Data Table?

[Steven Cronson]

Excel Spreadsheet of manufacturers products fields to a custom MySql table for products listings with over 50 fields how to map the manufactures data columns to those of the retailers fields and import the data?

Forexample how to map a MAP (manufactures price to another field by another name, like MSRP) or other name.
and connecting even the same field but out of order with its corresponding field.

Example

Product Name Product Name
SKU SKU
MSRP Selling Price
Product Title Product Title
MAP MSRP
Model Number MAP
Colors Colors


See above the tables have different orders for their rows. But each
Manufacturer varies in the orders of their columns and even the title name of the columns. Or have extra fields to be skipped.

So how to the Data table in MYSQL beside the Excel Data Table of the Manufacturers to map/point the Columns from the Manf Excel Sheet to the correct table row in the MYSQL Database. Without having to change the manufactures table to fit the Products Table in MySQL