I create data in Excel 2013 and save it as .csv. We have an application that imports files of type .address so after saving the file as customer.csv, I change the extension to customer.address. This is a custom file format specific to us, but essentially this is just CSV.
When I want to edit this customer.address file, I open this in Excel by selecting the
- Delimited option
- Select Comma in Delimiters
- Finish
I edit my changes and when I press Save, this is the default dialog box that pops-up.
When I click Yes, it saves my file as Tab delimited not Comma delimited.
What I'm actually expecting is this, to preserve the commas.
How do I make this work such that when I save, the default option should be CSV (Comma delimited)?
