Forum Discussion
superbeau
Oct 08, 2020Copper Contributor
Multiple issues with saving .xlsx file as a .csv
I haven't done this in a while, but I'm now trying to convert an .xlsx file to a .csv file. I need to have a .csv file to import a bunch of data into a computer system at work. I've done this before ...
superbeau
Oct 09, 2020Copper Contributor
Detlef_Lewin yes, if I open the .csv file in Notepad, the leading zeros are there. So I guess I should just plan to Save As a .csv file and then not open that file again with Excel. But I wonder why then Excel opens the newly formed .csv file automatically in an Excel window right after you create it? And why does that file look correct, but if you close and reopen, it gets messed up?
Detlef_Lewin
Oct 09, 2020Silver Contributor
superbeau wrote:But I wonder why then Excel opens the newly formed .csv file automatically in an Excel window right after you create it?
I have no idea. It does not happen on my system.