I have the problem that I need to import data from excel to mysql, however I can not even with code and through the button that is in mysql, I also have the heidi application and it does not allow me to send me errors, I want to review what is it what am I doing wrong.
Maybe the indicador_id column in your table is autoincrementable. If so, the column that corresponds to that field must leave it empty, that is, the column A of your file CSV .
With HeidiSQL , you have the option to import CSV , so the first thing you should do is save your Excel file, in CSV format separated with commas.
This is already a personal recommendation, edit the CSV, in the notepad, save it in a format compatible with UTF8 .
Then in the HeidiSQL , within tools, use the Import CSV File ... option ...
Select the options that best suit your file and should be loaded without problems.
The only thing to keep in mind is that the CSV columns must correspond to the same database order, otherwise it will give you problems