Exporting a report in csv format

[Nurture_Ninja]

Can we export a Marketo report in .csv format? The default format is .xls.

Thanks

NN

[SanfordWhiteman]

@Nurture_Ninja please return to your thread and check responses.

[Disha_Goyal6]

Hi @Nurture_Ninja, I don't think so there is any way to change the format of the file.

[Darshil_Shah1]

You can save the file as csv once downloaded— however, you might lose some formatting that’s not supported in the csv file format. What’s your use-case for this? Hopefully, we are not solving the XY problem here.

[Nurture_Ninja]

Thank you. The use case involves intercepting the file at the point of generation to extract and transfer it into an external system for report creation. This interception is feasible only when the file is in CSV, JSON, Avro, or Parquet format within Marketo’s subscription reporting framework.

[SanfordWhiteman]

You’d have to add XLS transformation to your ETL pipeline. As the others mentioned, there’s no canonical representation of canned reports in formats other than XLS.

[uditmathur · Accepted solution]

Hi @Nurture_Ninja ,

Apparently there is no direct way to export in .csv, but as a work around you can use report subscription get the report in your email as attachment & while saving the report you can use the .csv format.

Hope this Helps 😊