Forum Discussion
Convert excel to csv
Hello I am trying to convert Excel file too csv file to use this in a python/pandas file.
But I always get a ; in stead of a , .
Can you please help me or give me instructions how to manage.
When you save an Excel file as a CSV (Comma-Separated Values) file, the delimiter used depends on your regional settings in Excel. If you're getting a semicolon ; instead of a comma ,, it might be due to regional settings using semicolons as the default CSV separator.
Here is how you can change the CSV separator in Excel:
- Open your Excel file.
- Click on "File" in the ribbon.
- Choose "Options" at the bottom of the left-hand menu.
- In the Excel Options dialog box, select "Advanced" from the left-hand menu.
- Scroll down to the "Editing options" section.
- Find the "Use system separators" option.
- Uncheck the "Use system separators" option.
- Set the "Decimal separator" to a period . and the "Thousands separator" to a comma ,.
After making these changes, try saving your Excel file as a CSV again. The commas should now be used as separators in the CSV file.
Here is how to save an Excel file as a CSV:
- Click on "File" in the ribbon.
- Select "Save As."
- Choose the location where you want to save the file.
- In the "Save as type" dropdown, choose "CSV (Comma delimited) (*.csv)."
- Click "Save."
If you have made the changes to the regional settings correctly, this should save the file with commas as the separators in the CSV file. The text and steps were edited with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
When you save an Excel file as a CSV (Comma-Separated Values) file, the delimiter used depends on your regional settings in Excel. If you're getting a semicolon ; instead of a comma ,, it might be due to regional settings using semicolons as the default CSV separator.
Here is how you can change the CSV separator in Excel:
- Open your Excel file.
- Click on "File" in the ribbon.
- Choose "Options" at the bottom of the left-hand menu.
- In the Excel Options dialog box, select "Advanced" from the left-hand menu.
- Scroll down to the "Editing options" section.
- Find the "Use system separators" option.
- Uncheck the "Use system separators" option.
- Set the "Decimal separator" to a period . and the "Thousands separator" to a comma ,.
After making these changes, try saving your Excel file as a CSV again. The commas should now be used as separators in the CSV file.
Here is how to save an Excel file as a CSV:
- Click on "File" in the ribbon.
- Select "Save As."
- Choose the location where you want to save the file.
- In the "Save as type" dropdown, choose "CSV (Comma delimited) (*.csv)."
- Click "Save."
If you have made the changes to the regional settings correctly, this should save the file with commas as the separators in the CSV file. The text and steps were edited with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
Hello,
your answer was clear and helpfull but for my situation it's give not any solution.
The ; is staying and can't change in ,
Perhaps there must be something changed in the system of my computer.
I use Microsoft Office 365 so I can't understand why its not working properly.
Also it's possible that my laptop HP is from American orgine and I'm living in the Netherlands
so proberly its need a different install in the system register but I'm afraid for doing that
because I'm heave not the knowlidge to do that.
Anyway
Thank you so much for helping me and the Excel files should stay in the excel extension and not in csv.
If you have tried changing the regional settings in Excel, and the issue persists, there might be additional factors affecting the CSV output. Here are a few suggestions to address the problem:
1. Excel CSV Settings:
- Make sure you have unchecked the "Use system separators" option in Excel's advanced settings.
- After making changes, close and reopen Excel before saving as CSV.
2. Save As CSV (MS-DOS):
- Instead of choosing "CSV (Comma delimited) (.csv)," try choosing "CSV (MS-DOS) (.csv)" from the "Save as type" dropdown when saving.
3. Text Editor:
- Open the CSV file in a text editor (like Notepad) and check if the semicolons persist. This helps verify whether the issue is with Excel or the file interpretation.
4. System Locale:
- Check your system locale settings:
- In Windows, go to "Settings" > "Time & Language" > "Region" > "Additional date, time, & regional settings" > "Change date, time, or number formats."
- Ensure that the format matches your requirements.
5. Reinstall Office:
- If the issue persists, consider reinstalling Microsoft Office to ensure all settings are properly configured.
6. Regional Settings:
- Adjust your system's regional settings:
- In Windows, go to "Settings" > "Time & Language" > "Region" > "Country or region" and set it to the Netherlands.
If none of these solutions work, you might want to consult a service support in your region for more in-depth assistance, especially considering the potential differences in regional settings between the U.S. and the Netherlands on your HP laptop.
Thank you for your understanding and patience
