topic Google Sheets to Feature layer: Removing underscores from display name quickly? in ArcGIS Online Questions

Google Sheets to Feature layer: Removing underscores from display name quickly?

hoshijun — Wed, 06 Sep 2023 23:08:24 GMT

I have a Google Sheets with many columns/fields. When I import it into AGOL as a feature layer, the Display Names all automatically have underscores instead of spaces.

I would rather not manually go through each one since there are many. I also plan to update the data through Sheets occasionally so I'm worried that the names would reset.

Is there an easy way to change them back to spaces? Or a way to avoid the underscores from appearing when I import the sheet?

Re: Google Sheets to Feature layer: Removing underscores from display name quickly?

RhettZufelt — Thu, 07 Sep 2023 16:36:57 GMT

Easiest way to avoid the underscores is to remove the unsupported column name characters (space) from the Google Sheet in the first place.

Field Name—Field names cannot contain special characters, such as spaces, hyphens, parentheses, brackets, or characters such as $, %, and #. Avoid using field names that contain words that are typically considered database-reserved keywords, such as CHARACTER or DATE.

Re: Google Sheets to Feature layer: Removing underscores from display name quickly?

hoshijun — Mon, 11 Sep 2023 20:34:02 GMT

Hi R,

Thanks for the suggestion. The issue is I'd like to keep the display names with spaces included. I discovered that if I download the Google sheet into a CSV and then upload it to AGOL, it will automatically keep the spaces in the Display Name while the feature name has the underscores.