Looking for the latest product updates? What's new for Spring 2024 is now available!

csv export option to format date

0 Votes
when i export csv of campaigns, date comes with date and time, and i am unable to change the format in excel (i.e. remove time, want only date)
2 Comments
Caitlin_M
Administrator
Status changed to: Voting Open

Hi @web_design1. I apologize for the delay in our reply but thank you for bringing this to our attention. I'm seeing the same thing happen when I download a CSV file of campaigns. There is a workaround by using the text to column feature in Excel that can make the column editable. I'll include a third-party link that includes more information about how to achieve this but please note that our support teams would not be able to assist with the creation of this file and it would need to be done on your own time. I'll open this request up for voting. 

Frankie_P
Moderator
Status changed to: Closed - No Action

Hi everyone,

 

The good news is you can update this formatting in excel by highlighting column > Number > Short Date. Because this is also more of an Excel related issue, we recommend contact support directly. We are also going to close this idea. This doesn't mean that we aren't listening to your feedback! Please feel free to comment or vote on any of the other open ideas to let us know what you would like to see.

Updates
Introducing our new Feedback area

Our Feedback board is changing! From updated statuses to clearer processes, we're working to improve the conversation between you and our Product teams

Visit the Blog
Upcoming Webinars
Mar 28
Making it to the Inbox in 2024: What’s changed and what hasn’t
2PM - 3PM EST
Announcements
What's New?

See the latest Constant Contact product release notes and updates.

Learn More