---
title: How to change the separator when saving an Excel file as CSV
description: Our User CSV tool accepts comma delimited files only. Follow these steps to get a CSV file with commas.
---
[Skip to content](https://support.edapp.com/change-csv-separator#main-content)
English
Show submenu for translations
![EdApp - logo dark mode-1.png\]](https://support.edapp.com/hs-fs/hubfs/EdApp%20-%20logo%20dark%20mode-1.png?height=40&name=EdApp%20-%20logo%20dark%20mode-1.png)
- [Default HubSpot Blog](https://edapp-5741180.hs-sites.com/blog)
Open main navigation
Close main navigation
- [Default HubSpot Blog](https://edapp-5741180.hs-sites.com/blog)
- English
Show submenu for translations
- [edapp.com](https://www.edapp.com/)
[edapp.com](https://www.edapp.com/)
Hello. How can we help you?
- There are no suggestions because the search field is empty.
1. [Help Center](https://support.edapp.com/?hsLang=en)
2. [Tips and tricks](https://support.edapp.com/tips-and-tricks?hsLang=en)
3. [Programme Success](https://support.edapp.com/tips-and-tricks?hsLang=en#programme-success)
# How to change the separator when saving an Excel file as CSV
## Our User CSV tool accepts comma delimited files only. Follow these steps to get a CSV file with commas.
Having trouble uploading a CSV file to [manage your users](https://support.edapp.com/export-all-learner-information?hsLang=en#upload-settings-upload-csv)? This may be because your data is separated by semicolons instead of commas.
In countries such as the US, UK and Australia, the default list separator is a **comma**, so you get CSV comma delimited.
In European countries, a comma is reserved for the decimal symbol, and the list separator is generally set to **semicolon**. In this case the file is CSV semicolon delimited.
### To change your default CSV setting in Windows:
1\. Open the Windows Start Menu and click Control Panel
2\. Open the Regional and Language Options dialog box
3\. Click the Regional Options tab
4\. Click Customize/Additional settings (Windows 10)
5\. Type a comma into the 'List separator' box (,)
6\. Click 'OK' twice to confirm the change
### To change your default CSV setting on Mac:
1\. In Spotlight Search, find "Language & Region"
2\. Select "Advanced"
3\. Make sure the number separators for grouping are set to comma (,)
### To indicate separator directly in CSV file:
For Excel to be able to read a CSV file with a field separator used in a given CSV file, you can specify the separator directly in that file.
1. Open your file in any text editor. For example, Notepad or TextEdit
2. Type this string before any other data: sep=,
3. Open your text file in Excel, from Excel itself or your file explorer
- [Getting started](https://support.edapp.com/getting-started?hsLang=en#main-content)
- [Get Started in 5 Minutes](https://support.edapp.com/getting-started?hsLang=en#get-started-in-5-minutes)
- [Lessons & Courses](https://support.edapp.com/getting-started?hsLang=en#lessons-courses)
- [Basic User Management](https://support.edapp.com/getting-started?hsLang=en#basic-user-management)
- [Course Library](https://support.edapp.com/getting-started?hsLang=en#course-library)
- [Definitions](https://support.edapp.com/getting-started?hsLang=en#definitions)
- [Admin portal](https://support.edapp.com/admin-portal?hsLang=en#main-content)
- [Advanced User Management](https://support.edapp.com/admin-portal?hsLang=en#advanced-user-management)
- [Lesson Management](https://support.edapp.com/admin-portal?hsLang=en#lesson-management)
- [Course Management](https://support.edapp.com/admin-portal?hsLang=en#course-management)
- [App Customisation](https://support.edapp.com/admin-portal?hsLang=en#app-customisation)
- [Peer Learning](https://support.edapp.com/admin-portal?hsLang=en#peer-learning)
- [Engagement](https://support.edapp.com/admin-portal?hsLang=en#engagement)
- [Analytics](https://support.edapp.com/admin-portal?hsLang=en#analytics)
- [Features](https://support.edapp.com/admin-portal?hsLang=en#features)
- [EducateAll](https://support.edapp.com/admin-portal?hsLang=en#educateall)
- [Sharing Content](https://support.edapp.com/admin-portal?hsLang=en#sharing-content)
- [Integrations](https://support.edapp.com/admin-portal?hsLang=en#integrations)
- [Learner's app](https://support.edapp.com/learners-app?hsLang=en#main-content)
- [Logging In](https://support.edapp.com/learners-app?hsLang=en#logging-in)
- [Taking Courses](https://support.edapp.com/learners-app?hsLang=en#taking-courses)
- [Features For Learners](https://support.edapp.com/learners-app?hsLang=en#features-for-learners)
- [Extras](https://support.edapp.com/learners-app?hsLang=en#extras)
- [Star Bar](https://support.edapp.com/learners-app?hsLang=en#star-bar)
- [Creator Tool](https://support.edapp.com/creator-tool?hsLang=en#main-content)
- [Branding](https://support.edapp.com/creator-tool?hsLang=en#branding)
- [Templates](https://support.edapp.com/creator-tool?hsLang=en#templates)
- [Course & Lesson Configurations](https://support.edapp.com/creator-tool?hsLang=en#course-lesson-configurations)
- [Copying Slides/Lessons/Courses](https://support.edapp.com/creator-tool?hsLang=en#copying-slides-lessons-courses)
- [Translations](https://support.edapp.com/creator-tool?hsLang=en#translations)
- [Content](https://support.edapp.com/creator-tool?hsLang=en#content)
- [Tips and tricks](https://support.edapp.com/tips-and-tricks?hsLang=en#main-content)
- [Learning Programme Management](https://support.edapp.com/tips-and-tricks?hsLang=en#learning-programme-management)
- [Authoring](https://support.edapp.com/tips-and-tricks?hsLang=en#authoring)
- [Best Practices](https://support.edapp.com/tips-and-tricks?hsLang=en#best-practices)
- [Programme Success](https://support.edapp.com/tips-and-tricks?hsLang=en#programme-success)
- [Engagement](https://support.edapp.com/tips-and-tricks?hsLang=en#engagement)
- [Launch Kit](https://support.edapp.com/tips-and-tricks?hsLang=en#launch-kit)
- [FAQ](https://support.edapp.com/faq?hsLang=en#main-content)
- [Lessons & Courseware](https://support.edapp.com/faq?hsLang=en#lessons-courseware)
- [Authoring](https://support.edapp.com/faq?hsLang=en#authoring)
- [User Registration & Management](https://support.edapp.com/faq?hsLang=en#user-registration-management)
- [Display](https://support.edapp.com/faq?hsLang=en#display)
- [Engagement](https://support.edapp.com/faq?hsLang=en#engagement)
- [Peer Learning](https://support.edapp.com/faq?hsLang=en#peer-learning)
- [Knowledge Performance](https://support.edapp.com/faq?hsLang=en#knowledge-performance)
- [Analytics](https://support.edapp.com/faq?hsLang=en#analytics)
- [System & Technical Support](https://support.edapp.com/faq?hsLang=en#system-technical-support)
- [Subscriptions & Pricing](https://support.edapp.com/faq?hsLang=en#subscriptions-pricing)
- [Educate All](https://support.edapp.com/faq?hsLang=en#educate-all)
- [Contact & Support](https://support.edapp.com/faq?hsLang=en#contact-support)
- [Webinars](https://support.edapp.com/webinars?hsLang=en)
- [Technical / API documentation](https://support.edapp.com/technical-api-documentation?hsLang=en#main-content)
- [Single Sign On for the Learner's Portal](https://support.edapp.com/technical-api-documentation?hsLang=en#single-sign-on-for-the-learners-portal)
- [Single Sign-on for Admin Portal](https://support.edapp.com/technical-api-documentation?hsLang=en#single-sign-on-for-admin-portal)
- [Integrations](https://support.edapp.com/technical-api-documentation?hsLang=en#integrations)
- [API](https://support.edapp.com/technical-api-documentation?hsLang=en#api)
- [Legal documentation](https://support.edapp.com/legal-documentation?hsLang=en#main-content)
- [Third Party Gateway](https://support.edapp.com/legal-documentation?hsLang=en#third-party-gateway)
- [Privacy & Terms](https://support.edapp.com/legal-documentation?hsLang=en#privacy-terms)
- [Troubleshooting](https://support.edapp.com/troubleshooting?hsLang=en)
- [EdApp to SC Migration](https://support.edapp.com/edapp-to-sc-migration?hsLang=en)
- [Default HubSpot Blog](https://edapp-5741180.hs-sites.com/blog)
[](http://edapp.com)
EdApp Help Center
Copyright © 2026, EdApp Pty Ltd