Forum Discussion
Excel jamming and reformatting downloaded data:
https://imgur.com/a/N2dNn8Z
Excel opens and displays the data in a squished manner, where the cells are interchanged - as shown on the table in the background. The correct format should be what is displayed in the foreground - opened in google sheets.
In english, the yellow warning says: "possible loss of data - some functions may be lost if you save the workbook in .csv format. If you want to keep these setting/functions, you must save the project folder as an Excelt-fireformat".
My other groupmembers are beeing shown the correct format of the data in Excel as well as in Tableau. Rather urgent as this is an exam project.
- Thanks in advance
5 Replies
ivraq Not sure I follow, but you seem to open a CSV file by simply double-clicking it. It defaults to be opened by Excel, where all the data is neatly split in cells based on the commas found in the raw data.
Once done, you need to save the file as an Excel workbook (.xlsx) to preserve the data in rows and columns. The "loss of data" message will not show anymore when you open the XLSX file.
By the way, the dates in the CSV file seem to be US style (d/m/y) but your Excel, apparently, is set to recognise European style dates (d/m/y), as 1/17/1977 gets transformed to a text as it is not recognised as a valid date. On the other hand, 3/9/1981 is seen as a date 3rd of September. But, most likely, the intended date is the 9th of March. Best to go through "Get external data", Text on the Data ribbon. Follow the steps in the Text import wizard. In step 3 of 3, select the correct "format" for the dates to be imported. In your case MDY.
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.
