File Format to Import Historic Steps and Mileage Data

Hi all,

Hoping for some assistance please in importing historic data via the Garmin Connect Web Portal

I've read several threads on this topic but not resolved my query

I've an Excel file of historic data, it's in 3 columns, Date, Steps and Distance, these are the column headers used.

it's in .xlsx format

It's currently only a months span of data as it's my first attempt so figured keep it a small file but once I find a method which works I'd have maybe a years data in each import.

Date data is formatted as DD/MM/YYYY e.g. 30/08/2024, this is formatting option I choose upon import

Steps data is formatted as 11500, upon import I select the formatting option of 11,500.00 rather than 11.500,00

Miles data is formatted as 6.95

Every time I try an import however I get an error.

I've tried several variations on the above formatting and also a .csv file of this same data but without any luck.

Note the timeframe of this data set does not overlap with any existing Garmin data.

Can anyone advise please.

My source data example is attached below.

Thanks in advance.
H.

FB Data for July 2024.xlsx