Forum Discussion
Unexpected file type behavior when saving in Excel
I am using Excel Pro Plus 2016, in Windows 10. I have been using Excel with files in Excel and csv formats since the 1990s. I am very familiar with file type saving options and Excel's behavior in g...
Hello there. It seems that at some point, when the file was opened in Excel, the Text Import Wizard was ran and the 'Comma' was removed as a delimiter. This put the data into a single stream of data (i.e. a single column). My assumption is it was then saved as txt type, although it could've been xlsx all the same.
To get your data back into csv format, you'd need to go to Data > Text to Columns > Delimited, and select the Comma type. Depending on your data, any UTF-8 conversion may alter your data, such as if you didn't have quotes surrounding commas, etc. The bottom line is, if your data is still there, you can still save it as csv format.
To get your data back into csv format, you'd need to go to Data > Text to Columns > Delimited, and select the Comma type. Depending on your data, any UTF-8 conversion may alter your data, such as if you didn't have quotes surrounding commas, etc. The bottom line is, if your data is still there, you can still save it as csv format.