Original topic:

samsung Health data export

(Topic created on: 01-20-2021 05:35 PM)
1482 Views
Tonoose
Active Level 1
Options
Galaxy S
I downloaded the data from Samsung Health and tried to open in excel. The data is illegible.  Any ideas?
0 Likes
6 Comments
asifakberali
Active Level 8
Galaxy S
Is the file in CVS? What is the extension of the file you downloaded? Maybe I could help once I know its ext.
0 Likes
Tonoose
Active Level 1
Galaxy S
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
0 Likes
Halston
Moderator
Moderator
Options
Galaxy S

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.

0 Likes
Tonoose
Active Level 1
Galaxy S
I applied the short date format expanded the cell width and still get hash marks. Any thoughts?

20210123_095748_14345.jpg

Phishdog
Beginner Level 3
Galaxy S

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

0 Likes
fr0st42
Beginner Level 2
Galaxy S

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

0 Likes