topic Re: Experience Builder (Excel Export Date Formatting Issue) in ArcGIS Experience Builder Questions

Experience Builder (Excel Export Date Formatting Issue)

JacobBlankenship1 — Fri, 24 Mar 2023 13:41:40 GMT

I am exporting a CSV from a table in Experience builder (through action widget) and the date format comes out as 3/22/2023 in the CSV. However the correct time format should be 3/22/2023, 5:37 PM. In Experience Builder it shows the correct information but gets truncated in the CSV export for some reason.

Not sure if there is a setting I am missing or what.

I am using Enterprise Experience Builder Developer edition.

Thanks

Re: Experience Builder (Excel Export Date Formatting Issue)

jcarlson — Fri, 24 Mar 2023 14:29:33 GMT

Can you check the contents of the CSV in its raw text? Open it with Notepad or something similar, and verify how the date values are being saved. I've noticed that Excel applies default formatting to imported CSVs sometimes that I don't want.

Re: Experience Builder (Excel Export Date Formatting Issue)

JacobBlankenship1 — Fri, 24 Mar 2023 14:38:22 GMT

@jcarlson Looked at it in notepad and it still came out in the same format of 3/23/2023

Re: Experience Builder (Excel Export Date Formatting Issue)

JacobBlankenship1 — Fri, 24 Mar 2023 18:48:47 GMT

More information:

Experience builder Table View

When I export it as a JSON format the GPS time will be exported in Unix Epoch Time and than can be converted to a readable data format.

However, I need it to be in a csv format for the user to use.

Re: Experience Builder (Excel Export Date Formatting Issue)

JacobBlankenship1 — Tue, 28 Mar 2023 17:26:51 GMT

@Jianxia Do you know of anyone that might be able to answer this question?

Re: Experience Builder (Excel Export Date Formatting Issue)

Jianxia — Wed, 29 Mar 2023 00:48:32 GMT

@JacobBlankenship1, it turns out a known issue. We will investigate it. Although the issue below is for the Query widget, it applies to any export to CSV actions.

BUG-000153124 In ArcGIS Experience Builder, the export as CSV option for the Query widget does not generate the full date and time

Re: Experience Builder (Excel Export Date Formatting Issue)

SolanaFoo2 — Wed, 24 Apr 2024 05:29:02 GMT

Any updates on fixing this bug? Thanks

Re: Experience Builder (Excel Export Date Formatting Issue)

MarlboroughDistrict_Council — Thu, 22 Aug 2024 04:05:28 GMT

I've just come across this as well. Clearly its not been fixed yet! Any update on a fix ESRI?

Re: Experience Builder (Excel Export Date Formatting Issue)

Raquel — Mon, 29 Sep 2025 09:49:52 GMT

Hello @Jianxia!
This also happens when text fields contain commas, meaning the data from a table cannot be correctly converted to Excel because the CSV cannot be properly formatted.
Could you please add a download option or a widget similar to the Table to Excel geoprocessing tool in ArcGIS Pro? This way, there are no issues with line breaks or commas.
Thank you!

Thanks!