Jump to content

Allow alternative to comma in CSV export & import

Recommended Posts


I don't intend to use Export to CSV regularly, but in case I ever should need it I tested it.

As for Import, I haven't used yet but it has possibilities for feeding in quantities of items quickly.

But - different countries have different conventions for the decimal separator. Those I have encountered are full-stop and comma.

Here (in Sweden) the comma is the decimal separator and appears in decimal values in Excel spreadsheets.

Obviously using comma in CSV files would be a disaster here. A colon is a good alternative.

In fact, saving Excel sheets to CSV files here uses the colon as default (not even sure I can change it) 

Please can we have the option to choose the separator ourselves when Exporting and Importing.

Regards; David 

Edited by davblo

Share this post

Link to post
Share on other sites

I see now that the option to export to a CSV file has been replaced by export to JSON file instead, which solves the problem I described in this thread. The only question now is how best to handle a JSON file (if I should ever need to)

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now