Linkly & Microsoft Excel live feeds
Linkly now supports live data flowing into Microsoft Excel.
How to Get Live Feeds of Your Click Data into Microsoft Excel
1
Open your Excel workbook.
2
Go to the Data tab and click From Web.
Go to the Data tab and click From Web.
3
Copy the data URL from Linkly.
Right-click on the Data as CSV tab in the Linkly dashboard and select Copy link address.
Copy the data URL from Linkly.
4
Paste the URL into the dialog and click OK.
Paste the URL into the dialog and click OK.
5
Click Load to import the data.
Click Load to import the data.
6
Open the Queries & Connections pane.
If the pane isn't visible, go to Data → Queries & Connections.
Open the Queries & Connections pane.
7
Right-click on the query and select Properties.
Right-click on the query and select Properties.
8
Enable automatic refresh.
Tick Refresh every and enter 999 in the minutes field, then click OK. More frequent refreshes may get rate limited on Linkly.
Enable automatic refresh.
Excel Live Feeds FAQs
How often does the data refresh?
Excel will refresh the data based on the interval you set in the query properties. We recommend 999 minutes (approximately 16 hours) to avoid rate limiting.
Track 500 monthly clicks for free.