Now, when you open a CSV file in Excel it will automatically find the data fields and open it appropriately. Follow the steps in the Text Import Wizard, where. In the Choose a File dialog box, locate and click the CSV, HTML, or text file that you want to use as an external data range, and then click Get Data. go to Start | Control Panel | Regional and Language Options In the Import dialog box, click the option for the type of file that you want to import, and then click Import.Solution #3: Changing Regional and Language settings In your Windows Control Panel, change your Regional and Language settings.

In your CSV file(s), use a text editor to replace all commas, with semicolons.Change the CSV file extension to TXT (when you open a TXT file with Excel it will start the text file import wizard where you can choose the delimiter).But on European Windows versions this character is reserved as the Decimal Symbol and the 'List Separator' is set by default to the semicolon:.On American Windows versions, the comma is set as default for the 'List Separator', which is okay for CSV files. Open the Excel file that youre trying to change in terms of data formatting.The standard field delimiters for CSV files are commas: ,.When opening standard CSV (Comma Separated Values) files in Excel you may find that Excel did not recognize the fields and simply displays all data in the first column. Change the CSV file extension to TXT (when you open a TXT file with Excel it will start the text file import wizard where you can choose the delimiter) In your. Trouble With Opening CSV Files With Excel? The Comma and Semicolon Issue in Excel Due to Regional Settings for Europe

Convert csv into excel columns