This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello! I have a csv file in the following format -
When I try to load the file into excel, I get it in the following format and not in separate columns like it usually happens; Can anyone please help me with this? I do not want to use the Text to Columns function in excel as that really messes up the data.
Thank you!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Okay, actually I managed to solve the problem by just adding a line to the beginning of my CSV files
sep=,
Thank you!
Sorry about that - here is the original response again hopefully without any issues
From description, this would occur if you are in a region where the "list separator" character is not a comma but likely a semi-colon
To verify what the list separator character is for your region,
#1 - Open the Control Panel app
#2 - click on Clock & Region
#3 - click on Region
#4 - click on Additional Settings
*** do not change the List separator value for your region, but instead, change the "Region" to one that uses a comma as the list separator character (i.e. United States)
#5 - open the CSV file in Excel and save it as a "tab delimited" file
#6 - close Excel and reset region back to what it was
If you want to continue using this file as a CSV file on this system, open the tab-delimited file you saved in step #5 and then save it as a CSV file. Excel will save the file using the list separator character for your region.
***note: if you want to import this file into Outlook, be aware that Outlook requires that the CSV file uses a comma as the list separator character.
Hello,
I am unable to view your complete response, would it be possible for you to reply again? Thanks!
Hi there
Try using Power Query to import the CSV files.
This is one of many videos on YouTube that could help you to solve your problem.
Regards
Jeovany
Hello BharatRawlley
Hi, I'm Karl and will be happy to help you today.
From description, this would occur if you are in a region where the "list separator" character is not a comma but likely a semi-colon
To verify what the list separator character is for your region,
#1 - Open the Control Panel app
#2 - click on
#3 - click on
#4 - click on
*** do not change the List separator value for your region, but instead, change the "Region" to one that uses a comma as the list separator character (i.e. United States>
#5 - open the CSV file in Excel and save it as a "tab delimited" file
#6 - close Excel and reset region back to what it was
If you want to continue using this file as a CSV file on this system, open the tab-delimited file you saved in step #5 and then save it as a CSV file. Excel will save the file using the list separator character for your region.
***note: if you want to import this file into Outlook, be aware that Outlook requires that the CSV file uses a comma as the list separator character.