From DMD we get a clean CSV with double quotes and commas. When my Excel installation saves the CSV it returns no quotes and it returns semicolons. I have tried all kinds of different encodings and Save As in different formats in Excel and haven't found the right combination. I still use the CSV import/export a lot but it requires editing in a text editor.
My colleague often succeeds in the CSV import/export but not always. On another system we are using (SCADA platform), they introduced Excel import/export a few years ago and it is very smooth.
Yeah, it appears your CSV Save-As mechanism in Excel has changed the delimiter from using a comma to using a semicolon. You may need that for OTHER application files that you are importing and or exporting from Excel (databases?). Not sure how to adjust Excel - but be careful - you might get Designer element documentation import/export working, but then break your SCADA import/export! You might need to utilize the Excel Export wizards every time you import or export (and not just use the "defaults" from the last time you did it).
Losing double quotes doesn't hurt Designer's import typically. Excel does a good job of retaining double quotes if the column contains text that also contains a comma or also contains a double quote. Designer exports every column in double quotes so that any import mechanism knows to treat it as TEXT. For example, a description might have the text "1", which Excel would interpret as a NUMERIC value, not as TEXT. Or it could contain something that starts with an EQUAL SIGN (looks like an Excel Macro). Then Excel would fail or mis-interpret or actually run the macro if it was NOT in double quotes (this is one "virus" mechanism). Again, this needs to be in double quotes.
I just tried the CSV export from Designer with lots of combinations of fields with and without double quotes in the actual data, and other fields with and without commas in the actual data, and combinations of the two. I imported those into Excel, then saved it (as Excel's CSV format, losing some of the Designer column level double quotes), then imported it back into Designer, and it worked (even though Excel stripped of the column level double quotes). I then exported that again from Designer and it MATCHED the ORIGINAL EXPORT. As long as the comma and double quote grammar is semantically identical, everything
should work.
I do know Designer does NOT support
Unicode text files it is trying to import. Designer does not support Unicode text inside edit fields. These could be other issues you might be seeing with Excel CSV files.