Found this content helpful? Log in or sign up to leave a like!
How can you change the delimter in csv export files from semicolons to commas?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
When I export my grades as a csv file, they are delimited by semicolons. When I open the file in Excel it defaults to a comma as the delimiter and all the data is in the first cell. I need to change something so that they are in sync.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @rmorrison2,
If you go to your Account menu, then click Settings, you should have an option at the bottom of the page to "use semicolons to separate fields in compatible spreadsheet exports." For me that option is off (red X icon) and I get commas, so I assume yours must currently be on (green checkmark). If you turn it off, I think you should get commas.
Let us know if this fixes things up for you!
-Chris