It is possible that when viewing a .CSV file in Excel it is displayed incorrectly, this is because our "separator" or "delimiter" is not correct.
For example, if we have the system in English, the default delimiter of the OS is the semicolon (;) instead of the comma (,) as usual.
For the correct visualization of the file it is necessary that our computer has the numerical format of "Spanish (Mexico)", for this we carry out these simple steps:
We enter the "control panel" of our computer.
We look for the word "region" and click on it.
We position ourselves in the format option.
From the tab that is displayed, we select “Spanish (Mexico)”.
We click on accept to save the changes made.
Now we just have to start Excel again and dIn this way our .CSV files with "Separator" comma (,) will be displayed correctly.
It worked perfect for me, it was a matter of changing the language of the OS, so as not to be juggling each .csv file that I downloaded, thank you very much!
It doesn't work for me ...
I have a VBA that saves a processed book in CSV, but it keeps it separated with COMAS (,) always even when the regional configuration is with a semicolon.
I only save the file with a semicolon (;) when I save the file manually.
In other words, it is not used to automate tasks.