How can you change the delimter in csv export files from semicolons to commas?

Jump to solution
rmorrison2
Community Member

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.

Labels (1)
0 Likes
1 Solution
chriscas
Community Coach
Community Coach

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

View solution in original post