Dear Lucas,
it’s been a while.
Now I have a file with more measurements, and the extracted CSV file is larger.
consider that by opening it with Numbers (I have mac), the date setting is correct as intervals wants it.
but when I load the file into Wellbeing it still tells me this.
what do you think?
Thanks for your help.
I will also send you the CSV file generated by the scale.
The message is clear. The FIRST column must be the date in the format expected by Intervals, yyyy-mm-dd.
Your csv file opened in a text editor must look like:
date, metric1, metric2, metric3
2024-01-14, 22, 52, 43
2024-01-13, 26, 56, 45
The column header must be exactly the same as the name of the wellness field. (Case sensitive!)
Her’s an example:
Download some Wellness data from Intervals and reconstruct that format for anything you wnat to send.
Stop using a spreadsheet or other software to open the csv files. Open them with a plain text editor.
As @MedTechCD has said, use the download as the template, then add to it before uploading. Also, the column headers don’t have spaces.
Example: Weight is Weight, not Weight (Kg).
pretty sure my manual for that was very detailed but ofc I can try to help.
just try to do it step by step (sry I barely remeber that, but I’m 100% sure there was a step to convert the data)
where can I find your file?
How did you manage to export this CSV data? from tanita smartphone app?
I managed to get API Access but it only provide data for Weight and bodyFat and not the amount of data you got from your CSV you shared prev… sadness
HI,
I got the csv file from the web page, or even from the Tanita app for IOS. It doesn’t change from both.
I have to find a way little by little.
HI,
yes you are right. I’ll try again as soon as I have time. Maybe I missed a step.
Thank you. I don’t want to bother you any further 
Use my manual for mfp but:
-just open a new excel file
-import per manual into a new sheet
-select first column → right click → format cells → date → sellect correct format
-this should get rid of the hours
-go to intervals and add data fields (capital letters etc. read rules)
-you can start with some basics like weight only for now just to check if it works --delete other fields from your excel for now
-export per manual again
format should be ok
/as far I remember the problem with mfp was if you had two reading for a day, it would mess up the import bc intervals can’t sum up on the fly. so it is adviced not to do two readings at one day
-you will need to edit all the colum names to match the data fields created in intervals
-when you prepare an excell correctly, all further readings you can copy inside (it will be much easier bc all the column names will be already corrected
-first check for simple data like weight and tell if it worked 
Hi,
I am trying to upload a CSV file but I have the same message than above: first column must be date but I opened with text editor and it seems date the first column.
It’s a colon instead of a comma?
You created a European csv where the comma is used as a decimal separator and the semi-colon as a field separator.
Intervals expects a US formatted csv with dots as decimal separator and comma as field separator.
Either you configure the used app to format it as US, either you use a text editor and FIRST replace comma’s by dots, then semi-colon by comma’s.
missed the “,” for the decimal separators.
Thanks!
I changed but it says that CTL is missing but I didnt touch the ctl values
Hi,
I am wondering if is possible to do the following:
see above
The number off fields in the headers and in each line must be exactly the same. The values can be non-existing, but the number of colons must always be exactly the same on each line.
I created a template in Excel, then I copy and paste values under each heading. This would be when I’m trying to fill gaps on some columns that aren’t populated, eg. weight.
Then, add data as required.
Hi, ok thanks a lot. I will try this if its works
