Web Field Helper

Web Field Helper is a Word™ template or add-in for Windows that allows you to place various types of date-dependent web data like RSS, CSV, iCal, and Elvanto™ rosters directly into your document, and then have it refreshed automatically from its online source.

Instead of time-consuming and error-prone cutting and pasting every week, a quick refresh updates your weekly bulletin or information sheet with all the latest information from around the web – and in the correct fonts and formatting. You can even queue up content by date in a Google Spreadsheet and just paste in the link to have this week’s text automatically inserted!

You can use it as a template (just double click) or copy it to your startup folder and have the “Web Field Helper” tab available for every document.

This utility is free, but as a result there is no warranty!

Download here.

Check out the screenshots below for a better picture…

When you open the template a “Web Fields” tab appears on the menu bar. The highlighted fields are populated automatically from online data.

Just hit the “Edit” button to specify the source and format of the data. You can paste in RSS, CSV, Google spreadsheet, and calendar links. Or choose from the sample links in the URL drop-down as below. 

Pick a sample URL to see the kinds of details you need to specify, then just paste in your own link. For Elvanto you can specify your API Key as the default user in the menu bar (see below). For Google spreadsheets, just cut and paste from the address bar in your browser. For Google calendar you get your link by right-clicking on your calendar, and then under Calendar Settings->Calendar Address right-clicking on the “ICAL” button and choosing “Copy Link Address”. 

After a link has been loaded, you can choose other fields in the same source from the drop-down menu.

 

Use the menu to insert, edit, or refresh fields (usually also available on the right-click menu), or to specify the default username and password for links with authentication. Note that you can’t cut and paste fields between documents. Just copy the document and edit the fields. 

Web fields make use of normal Word document fields, but their data is stored behind the scenes in each document. So if you hit ALT-F9 you’ll see all the field definitions. To update them, however, you need to use the “Refresh” button, not Word’s own “Update Fields” functionality.

To use the template as an add-in in Word (i.e. available for every document), copy it to your startup folder.