I have a .csv file with 9273 rows.
I have one column of whole numbers and one column of decimal numbers with values like 0.0001752.
I totalled these columns using Excel's sum function and got totals of 8904671 and 4750.04556.
I then imported this .csv file into a MySQL database using "LOAD DATA INFILE". The database also contained 9273 rows of data, however MySQL SUM function returns column totals of 8603588 and 4432.1793865700.
Confused, I opened the original .csv with LibreOffice and totalled the columns again. That provided column totals of 8603597.8662 (for the whole numbers) and 4432.17938657.
Finally, I thought I'd see what Google Sheets made of the data from the .csv. It totalled the columns as the LibreOffice value if the data was copied from there, and Excel if copied from Excel. Sheets also gave the Excel totals if I imported the plain .csv. However, Sheets cannot add up the columns at all unless I choose 'yes' to the "Convert text to numbers, dates and formulas" option.
As a summary, for the same .csv the column totals for the two columns are:
MySQL: 8603588, 4432.1793865700 Excel: 8904671, 4750.04556 LibreOffice: 8603597.8662, 4432.17938657 Google Sheets from Excel: 8904671, 4750.045587 Google Sheets from Libre: 8603597.866, 4432.179387 Google Sheets from .csv: 8904671, 4750.04556
(Google sheets required "convert text to numbers" option)
Which is the correct set of column totals, and why does a sum of the same values result in different totals?