CSV Export to Follow Table Structure

[James_Shreeve]

Hi, 

I've got an EB page which contains a couple of tables with various dates on it, I have it set up to export to CSV as this is used by our management. Obviously CSV files export the raw data but I was wondering if there would be any way to export the data as shown in the table, which is formatted in a more friendly way for users. I can deal with removing the Global ID and Object ID, its more the date formatting. 

CSV export

EB table view

Many thanks, 

James

[VenkataKondepati]

Hi @James_Shreeve,
Not directly, the CSV export always pulls raw attribute values. To get user-friendly formatting (like readable dates), you’ll need to apply formatting before export. You can do this either by:

Adding Arcade expressions in the table widget to format dates (e.g., Text($datename, 'MM/DD/YYYY')) and exporting that field, or

Using a custom download widget or Experience Builder Developer Edition to handle client-side formatting before writing the CSV.

So, by default, no but with a small Arcade or custom export tweak, you can make it work as shown in the table.

Regards,
Venkat

[DougBrowning]

Also looking for a way to get the field name vs the alias as we can no longer use the CSV since it has spaces in the column names.

https://community.esri.com/t5/arcgis-experience-builder-ideas/table-widget-export-to-csv-is-using-th... 

[James_Shreeve]

Hi @VenkataKondepati 

I do apply formatting where it is possible. Tables direct from EB don't allow for advanced formatting as far as i'm aware. 

Below is an example of advanced formatting I've done but I still get the raw data rather than the formatted version when I export to CSV.

Thanks!