google cloud platform – The values of a table are not pulled into the BigQuery

admin

I have created a table in a BigQuery dataset and upload it from my files, however when checking the table I see a difference in values(see the images), in particular the following variables, TimeAct, TotalIntensity and AverageIntensity.

In the BigQuery table they have values 0 as oppose to the original dataset in Excel where their value is NOT 0.

Schema was auto-detected and I had 1 header row to skip.
I made sure the columns are formated in the correct format.
I tried different formats (left it as STRING)

Any ideas?

Thanks in advance.

[Original Dataset]
enter image description here

[BigQuery Table]
enter image description here

Read more here: Source link