samsung Health data export

[Tonoose]

I downloaded the data from Samsung Health and tried to open in excel. The data is illegible.  Any ideas?

[asifakberali]

Is the file in CVS? What is the extension of the file you downloaded? Maybe I could help once I know its ext.

[Tonoose]

It's a csv file and opens in excel, but the date/time field is a large integer. when I apply a date format to the field it does not yield a date, just hash marks

[Halston]

Hi Tonoose,

Microsoft Excel might show ### in cells when a column isn't wide enough to show all of the cell contents. Formulas that return dates and times as negative values can also show as ###.

If the dates are too long, click the Home > arrow next to Number Format, and pick Short Date or adjust the column width.

You can manually adjust the column width or row height or automatically resize columns and rows to fit the data.

Note: The boundary is the line between cells, columns, and rows. If a column is too narrow to display the data, you will see ### in the cell.

Resize columns:

>Select a column or a range of columns.

>On the Home tab, in the Cells group, select Format > Column Width.

>Type the column width and select OK.

[Tonoose]

I applied the short date format expanded the cell width and still get hash marks. Any thoughts?

[Phishdog]

I, too, am looking for a solution to converting to date.

[fr0st42]

In Excel use the following formula and then format the column as a date: =(CELL/1000/60/60/24) + DATEVALUE("01-JAN-1970")