topic Re: Can't create multiple hosted feature layers from single google sheet with multiple tabs in ArcGIS Online Questions

Can't create multiple hosted feature layers from single google sheet with multiple tabs

StephanieIngraldi — Mon, 28 Mar 2022 14:49:58 GMT

I am generating hosted feature layers from a google spreadsheet with multiple tabs. A month ago, I had no problem uploading each tab as its own layer. Now I'm trying to re-upload the layers, but the drop-down menu with my tabs in gone and I get this error message: “A file named "[my spreadsheet name]" already exists in this folder. Please rename the file and try again.”

I've done some testing and I know the following are not causing the issue:

New tabs to the spreadsheet added/renamed/moved since I uploaded my first feature layer. I created a new test spreadsheet with multiple tabs and got the same error message when I tried to create my second feature layer.
Google form linkage
Column name duplicates in a single tab

I've tried doing this with multiple other spreadsheets with different properties and get the same error message any time I try to add the second feature layer, which leads me to think this may be a bug.

Re: Can't create multiple hosted feature layers from single google sheet with multiple tabs

ABishop — Fri, 25 Mar 2022 20:34:24 GMT

Hello Stephanie,

Try updating the current hosted feature layer instead of trying to republish over the old one.

Re: Can't create multiple hosted feature layers from single google sheet with multiple tabs

StephanieIngraldi — Sat, 26 Mar 2022 19:12:00 GMT

My reason for re-uploading instead of updating the layers is that I've since changed the columns in the spreadsheet (deleted/added new ones). When I try updating I get the 'Adding item...' buffering page but it never goes away and the layer never updates. I don't know if this is because of the column mismatch or the existing name issue.

Re: Can't create multiple hosted feature layers from single google sheet with multiple tabs

ABishop — Mon, 28 Mar 2022 12:24:16 GMT

Yes, absolutely the change of the table schema would definitely make it impossible to update.