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.
- Click
File
in the Ribbon. - Click
Save as
. - Select
CSV UTF-8
. - Click
Save
.
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?
EDIT
The 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.
.xlsx
to.xlsm
. Does this work for you?xlsm
. I've updated the question.