Fix Incorrect Date Format in Zendesk CSV Upload
Why are dates formatted incorrectly when uploading a CSV to Zendesk?
When uploading a CSV to Zendesk, dates might appear incorrectly due to Excel's default settings. Excel often changes the date format from dd/mm/yyyy to a two-digit year format, like dd/mm/yy. This can cause Zendesk to display dates incorrectly, such as showing "September 8, 16" instead of "September 8, 2016".
To resolve this, ensure that your dates are formatted with a four-digit year before saving your CSV file. You can adjust this in Excel by setting the date format to dd/mm/yyyy and ensuring the Locale is set to United Kingdom (English). Alternatively, using Google Sheets to create your CSV can prevent this issue, as it does not alter date formats. For more detailed instructions, you can refer to theoriginal help document.
More related questions
How can I change the date format in Excel for Zendesk CSV uploads?
To ensure correct date formatting in your Zendesk CSV uploads, you need to adjust the settings in Excel. By default, Excel might change the year format from four digits to two, which can lead to incorrect date displays in Zendesk. To fix this, open…
Can I use Google Sheets to avoid date format issues in Zendesk CSV uploads?
Yes, using Google Sheets can help you avoid date format issues when uploading CSV files to Zendesk. Unlike Excel, Google Sheets does not automatically alter the date format, which can prevent common issues with date displays in Zendesk. When you…
What is the correct date format for Zendesk CSV uploads?
The correct date format for Zendesk CSV uploads is dd/mm/yyyy. This format ensures that dates are displayed correctly in Zendesk user profiles. If you're using Excel, make sure to adjust the date format settings to include a four-digit year and set…
Interested indeflectingover 70% of your Zendesk support tickets?
Zendesk Support Tickets
Zendesk Messaging (live chat)
Join1,000+ companies reducing their support costs and freeing up support agents for more important work
“We needed an AI agent integrated within our current tools. My AskAI was the only solution that wasn't going to disrupt our operations.”
Zeffy
“At the end of last year I was given the challenge - how can we provide the same or better service, without hiring anyone?”
Zinc
“My AskAI blew everybody else out of the water. It made the selection process very easy for us.”
Customer.io($50M+ ARR)
“It now resolves 71% of queries (over 35,000 every month), meaning more time solving complex issues and improving UX.”
Freecash
“We needed an AI agent integrated within our current tools. My AskAI was the only solution that wasn't going to disrupt our operations.”
Zeffy
“At the end of last year I was given the challenge - how can we provide the same or better service, without hiring anyone?”
Zinc
“My AskAI blew everybody else out of the water. It made the selection process very easy for us.”
Customer.io($50M+ ARR)
“It now resolves 71% of queries (over 35,000 every month), meaning more time solving complex issues and improving UX.”
Freecash
Reduce support costs.Spend more time on customer success.
