I want to see the data table of a service in Excel

[DougBrowning]

I have been bugging the ArcGIS for Office group for years to allow me to see the data form a service in excel.  I even met them in person.  It would be so cool to just add a service URL in excel and see the table. I try really hard to not do exports in my workflows.  Just an antiquated workflow.  I have been trying to use the Office integration since the day it came out.  All of my use cases are seeing data in excel and not once has anyone wanted a map in excel.

This would be a home run!  Please consider its been so many, many years now.  

Thanks

[ShannonCardoza]

This is an awesome addition and we appreciate the feedback @DougBrowning @ScottFortman1 🤝

[DougBrowning]

Ok for my next crazy idea @ShannonCardoza  can you some how add photo links in?  Esp from 123 forms this would be super sweet!  Even just a URL that opens a page would be great.  

Then I thought popups.. Most of my images are in a repeat table though.  But one layer I tried I noticed I can turn popups on and make an active layer but I cannot turn off the other layers?  Hard to find the right symbol when they are all stacking up on each other.  Unless I am missing something?  Not seeing a TOC in excel.

I am going to try and make a map, enable photos in the popup and see if I can get it.  Has anyone tried this yet?

Answered my own question and its a yes!  Hopefully I can figure out a repeat.  Still stacking issues though.  Update I got a repeat table of photos to work also.

Also If you select a record in the table does it select it in the map?  Does not seem to.  Also to be able to select map records and it selects in Excel would be really cool.  Then also on to filter in excel filters the map.

thanks

[ShannonCardoza]

@DougBrowning calling all ideas even the crazy ones! 😊

I think you will just love, love the new UI/UX experience we have coming in ArcGIS for Excel (and the other Microsoft 365 components such as Sharepoint). Stay tuned!

[QuantitativeFuturist]

@ShannonCardoza Big thanks to you and your team for being so open to ideas and responding quickly with implementations. This is a breath of fresh air for us as long time esri users, other teams in esri could learn a lot from your team. Keep up the great work!

[DougBrowning]

Ok @ShannonCardoza  for my next crazy idea.  Some type of widget in the side bar for AGOL forms similar to the ExB widget.  This could go in the window where the map is now.  The reason is we now have forms that have a bunch of arcade in they to generate field values, etc.  If the users go in via ArcGIS for Excel now they can skip all of our arcade causing incomplete records.  Or if editing in Excel would kick off the arcade just like a widget even better!  (Probably hard to do).

I could also see adding a Survey123 widget in there.

Then some way to restrict the edits to using a form.  Not even AGOL will limit you though I believe.

thanks a lot.  

[ShannonCardoza]

Ok now @DougBrowning, I see what you are putting down...well kind of. Can you elaborate on what is meant by "if the users go in via ArcGIS for Excel now they can skip all of our arcade causing incomplete records." Also, say we have the form option in ArcGIS for Excel, as seen in ArcGIS Online once a user selects forms it takes me to form builder, from from builder you would expect to see this form 'formatted' in Excel? 

Feel free to reply and reference a link or 2 so I can see what you are imagining here! Great stuff though and keep it coming 🙂

-SC

[DougBrowning]

In New Map View you can now make Forms that have calculated values (plus you can control Editable, Required, and Visible).  In our workflow we have the user fill out some fields then have some auto calculations in the background fields that calculate important values for us like due dates, project size, etc.  We would want those calculated fields to fire off when editing in Excel.  I doubt you could get them to go when editing a cell?  Constraining to a widget on edits would be ok for us.  That may mess up your nice domain drops down also not sure.

For the actual editing you could look at the Experience Builder widget as an example.  You may even be able to just use their code.  They have a 123 widget as well.

Thanks a lot for considering.