Change separator in Excel for .CSV files


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.

Panel de control

We look for the word "region" and click on it.

Region

We position ourselves in the format option.

3

From the tab that is displayed, we select “Spanish (Mexico)”.

Español(México)

We click on accept to save the changes made.

5

Now we just have to start Excel again and dIn this way our .CSV files with "Separator" comma (,) will be displayed correctly.

Previous GifCam: the easiest way to create animated GIFs in Windows
Next Web server. Program safely

2 Comments

  1. Nicholas
    01/03/2018
    Reply

    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!

  2. Ricardo Vera
    07/07/2016
    Reply

    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.

Leave a reply

Your email address will not be published. Required fields are marked *