Forum Discussion
Excel jamming and reformatting downloaded data:
Did not seem to support inserting of pictures yesterday. Anyways, in the background the file is opened in Microsoft Excel, while in the foreground it is opened in google sheets. Google sheets presents the data correctly. It seems the rows are "squished" together in Excel.
Ivoya15 OK. In Excel, on the Data ribbon, you'll find an icon "Text to columns". Follow through the steps:
Step 1) Delimited
Step 2) Comma
Step 3) In the Data preview, you'll see the columns that will be created. Most of the time Excel will guess the data type correct, but dates are alway a problem. Select the first column in the preview and set the Column data format to "Date: MDY".
Now press Finish and you should get a table similar to the one you see in Google sheets, but with correct dates.
Riny_van_Eekelen Thank you so much! I barely use Excel; I usually load .csv into python/pandas directly, but here it was ment for Tableau. Apparently Excel by default had the delimiter not set to comma, and in turn also affected this inside Tableau. Look much better now
