Anyone have any easy (or easier) methods to convert Intercom's exported CSV files from a Custom Report into a consistent one?

Question

Currently, the output is a text field that isn't consistent, instead it varies based on the content. So I can have results of 17m 2s; 16m; 11m 52s; etc. which don't allow easy conversion to numbers/time in any way.  The ideal would be for them to be in 24 hour format, so for the above examples:00:17:02; 00:16:00; 00:11:52But even if we could just get to: 17m 02s; 16m 00s; 11m 52s would be an improvement :)  This is a huge hassle to fix when trying to manipulate the data and in the end I'm stuck with manually updating and fixing them by eye (I am no Excel/GSheets macro expert).

Aparna · Accepted Answer

Hey @adam w11​!  I totally see where you are coming from. We can flag a feature request for you with the team for now.

Join the Intercom Community 🎉

Intercom Customers and Employees

Login to the community

Intercom Customers and Employees

Scanning file for viruses.

This file cannot be downloaded