HeidiSQL: Import CSV
As per documentation your error is:


  Error: 1261 SQLSTATE: 01000 (ER_WARN_TOO_FEW_RECORDS)
  Message: Row %ld doesn't contain data for all columns


Thus it appears that your table have more column than the file. You will have to specify the column-names explicitly. Also the remaining columns should be nullable. (You might want to share table definition if below command doesn't work)

Try this:

LOAD DATA INFILE 'path/to/file' INTO TABLE your_table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' IGNORE 1 LINES (id,date,date_,pow,ene,reac);

If you are interested you might want to refer this blog post which explains various use-cases for loading delimited data to mysql.