Sending sensor readings in file from esp32 to ThingSpeak via MQTT

I am trying to send my sensor readings to thingspeak via MQTT in a file but there is a problem when my file is received not all the data will put in the exporting file. like when I send a 4 lines of data in the file the first cell in exporting file will show the first value in the sent file and the second cell in exporting file will show the last value in sent file.

Note: I am sending a csv file to thingspeak

Is thingspeak supports receiving light files via MQTT?

If yes, what is the maximum file size can thingspeak receive? and why the data is untidy؟

[Christopher Stapels]

Can you show what you mean by untidy? Ive never sent files to ThingSPeak via MQTT, but I suspect it might work if you send a file that has the syntax in the correct format e.g. field1=xx&field2=yy etc.