How to display raw data from CSV in Excel

Question

When I open a CSV file in Excel, data is formatted into values that aren't useful.

For example, I have a CSV with raw data

id,        studyid, studystartdatetime,      19960333152518,     19960444074329
10219922,  330732,  2020-10-26 07:22:03.000, 13.728111605495413, 0.8199649107182145
10222451,  331814,  2020-11-03 10:28:10.000, 43.369795528728545, 0.8648709765481933

and when I open this in Excel, it shows me

id,        studyid, studystartdatetime,   2E+13,     2E+13
10219922,  330732,  22:03.0,              13.72811,  0.81996
10222451,  331814,  28:10.0,              43.36979,  0.86487

How can I disable any type of formatting that occurs and view the raw data? There is going to be hundreds of columns in the CSVs I am using, so reformatting each column is not an option.

Answer 1

1. Go to Data -> From Text/CSV
2. Choose your CSV file from File Explorer
3. Select Transform Data
4. Select all cells with Ctrl-A
5. Click Use First Row as Headers
6. Click Datatype: Any and select Text and click Replace current, if prompted.
7. Click Close and Load