But you use the same column correct? and the data that is messed up is the same type? Unless the data that is messed up is very hard to detect using a script, it should be possible.
I suggest making a script to fix it, rather than fix it manually. It is very easy to use, so basically program then export to excel then run officescript. Also don’t tell anyone you made a script, tell them you are doing it manually.
https://learn.microsoft.com/en-us/office/dev/scripts/overview/excel
There is many formats that excel uses, the issue is probably with XLSX format, my guess the problem will be solved by either using a different software or changing the format to csv. If Microsoft doesn’t want to bother solving the problem. It is very hard to pinpoint the exact problem without seeing the program, but I will never do something like this manually, I will probably make a script to fix it.
I think you mean export to xls, also each program will have a different way for exporting. It might be that the way excel does it breaks it.
He can also use an alternative to excel like OpenOffice or libreoffice, I don’t know why would they would use excel when it causes issues.
I doubt they would care about Lemmy, there is hardy anyone on [email protected] compared to /r/manga. Posts of One Punch for example have over a 100 comments while on [email protected] there is no comments. If [email protected] becomes popular they will probably go after it, now it is probably not worth the hassle.