I have several dozen Microsoft Excel files in
xlsx format. These files are the "master" copy for editing and include various formatting to make them easier to edit.
However, the data from these files is imported into a CMS as CSV, so ultimately I need to generate CSV files.
To generate the CSV files, this is what I do currently.
Filein the Ribbon.
However, when I do this, Excel automatically closes the
xlsx file and opens the new
CSV UTF-8 file. This is a problem because the formatting is still there, so it looks like the
xlsx file, and sometimes I make additional changes to the CSV file, when the changes need to be made to the master file.
For now, I have made it a habit to very carefully close the CSV after export and then re-open the
xlsx file to prevent this kind of mistake.
How can I generate a CSV file from an
xlsx file without having Excel close the
xlsx file and open the CSV file?
xlsx files are stored in Google Drive, and sometimes users update them via Google Sheets. So I can't convert to
xlsm because then the files will no longer be editable in Sheets.
.xlsm. Does this work for you?
xlsm. I've updated the question.