Keeping UK Date format in CSV Export

[Peter_Griffiths]

Hi Folks,

I have a google sheet which has several columns that are dates in the dd/mm/yyyy format. This data is then sliced a number of different ways for a variety of uses. Some of the sliced data is then available for users to export as csv however the date always comes out in this file in the mm/dd/yyyy format.

Is there any way to ensure the csv keeps the original date format or does appsheet alter the format but displays it correctly according to the user’s locale?

[Steve · Accepted solution]

Adding Locale Support for CSV Import and Export Announcements

I am adding Locale support to the CSV Import and CSV Export data actions. The change is described in the article “Import data from CSV” in the “Tips and Tricks” topic. See Import data from CSV - #91 by Phil

[Peter_Griffiths]

Superb!! That was exactly what I needed to know