Automatically refresh layer data from Excel

Question

I have seen quite a few posts in the same realm of what I am looking for but nothing has solved my issue.

I have an excel document with data that is refreshing/changing every 15 minutes. I have successfully made a layer on my map with the latitude/longitude values in the spreadsheet. However, the data on the map is not refreshing itself even with the refresh interval set at 1 minute. It simply shows the data from the time I put it in.

Basically what I am asking here is if there is a way to get that data to refresh automatically at the same rate as the Excel sheet. I should add that I am new to ArcGIS and using a free trial to test it out for another company. Not sure if that's relevant or not but any help would be appreciated.

excel data‌   arcgis-online‌

ThomasButton · Answer

Just wondering if this was ever resolved. im looking at the same things now as i have a excel table with a power query pulling data on an hourly refresh with Lat / Lng from the DB but need this in AGOL without manual updates every  few hours/days

MansiPatel · Answer

Hi Joey Needham,

I have same issue that i am updating excel file in my one drive but changes are not reflecting on AGOL data tab.

i also wants to update a data in AGOL when changes occurs in excel on one drive but without manual operation.

Is this possible or not? can anyone suggest me right path?

Below, i have attached screenshot of data in AGOL while excel has more data entered but its not showing me in AGOL. you can check screenshot of excel data as well.

Thanks a lot in advance.

JoeyNeedham · Answer

So I have the problem solved, it's a roundabout way of getting it done but it works. Saved the spreadsheet to my google drive as a CSV file and then modified it's "shareable link address" (shown here https://solvemethod.com/google-drive-direct-link/).

Then adding the file from the web with that address it now updates the information at the set interval with whatever is last SAVED on the spreadsheet.