topic ArcGIS Pro not reading date field from Excel table? in ArcGIS Pro Questions

ArcGIS Pro not reading date field from Excel table?

HayleyL — Fri, 12 Jan 2024 02:34:26 GMT

I have added an Excel table into Pro, with a series of date fields. In Excel they are formatted as dates to allow for Pro to read it as such. However once added to Pro it reads it as text, any pointers here?

I have tried reformatting to yyyymmdd and yyyy/mm/dd with no luck.

HayleyL_0-1705026845484.png

HayleyL_1-1705026859619.png

Re: ArcGIS Pro not reading date field from Excel table?

DanPatterson — Fri, 12 Jan 2024 03:38:35 GMT

If the excel file has its columns formatted and there are no blank cells in a column, try

Excel To Table (Conversion)—ArcGIS Pro | Documentation

and see if the date information is retained properly

Re: ArcGIS Pro not reading date field from Excel table?

HayleyL — Fri, 12 Jan 2024 05:10:20 GMT

@DanPatterson didn't work either 😞

Re: ArcGIS Pro not reading date field from Excel table?

DanPatterson — Fri, 12 Jan 2024 11:34:44 GMT

Use date fields—ArcGIS Pro | Documentation

are the data in the same format as your computer's regional settings for dates?

Re: ArcGIS Pro not reading date field from Excel table?

MarkGilbert — Fri, 12 Jan 2024 16:56:26 GMT

I don't necessarily have an answer, but do either of these resources help?

Work with Microsoft Excel files in ArcGIS Pro Specifically, take a look at the Limitations section, "...the field type specified in Excel is not used in determining the field type exposed in ArcGIS."

Date field in Excel to Table tool

Re: ArcGIS Pro not reading date field from Excel table?

Bud — Mon, 15 Jan 2024 09:14:47 GMT

Just a guess, but you could create a new field, set the format to date, then copy/paste the old field into the new field, but paste special (without formatting) so that the new field's formatting is honoured.

If that doesn't work, try using an Excel formula that outputs a date.

You could also attach a sample of the data to this forum post so that others can give it a shot.

Re: ArcGIS Pro not reading date field from Excel table?

Bud — Wed, 17 Jan 2024 04:07:14 GMT

Idea: Set field datatypes when using Excel file

Re: ArcGIS Pro not reading date field from Excel table?

Boyang_Wang — Thu, 07 Nov 2024 15:09:52 GMT

I am attaching a sample data, hoping that someone can help me to troubleshoot.

In excel, both date1 and date2 contain either Date value or General value (blank). When added to ArcGIS Pro, date1 becomes Text field while date2 becomes Date field. What is the problem with date1 column?

Thank you.