Re: single sourcing to Excel spreadsheets

[Robert Lauriston <robert -at- lauriston -dot- com>]

Use a web query:

https://support.office.com/en-us/article/Get-external-data-from-a-Web-page-708f2249-9569-4ff9-a8a4-7ee5f1b1cfba#bmcreate_a_web_query

Refresh it when you open the file:'

https://support.office.com/en-us/article/Refresh-connected-imported-data-e76a38b0-e2e1-400b-9f2f-c87b9b18c092

Probably you could write a macro to do that automatically.

On Thu, Feb 18, 2016 at 2:20 PM, Tom Johnson <tomjohnson1492 -at- gmail -dot- com> wrote:
> Does anyone know how to export content from an HTML source to Excel
> spreadsheets?
>
> Our delivery group uses Excel spreadsheets to customize the request
> elements customers use in an API (filtering the body request down from
> hundred of elements to a manageable handful). Other than somehow generating
> a CSV export from a source, I have never tried to single source content
> into a Excel spreadsheet output.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Visit TechWhirl for the latest on content technology, content strategy and content development | http://techwhirl.com

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

You are currently subscribed to TECHWR-L as archive -at- web -dot- techwr-l -dot- com -dot- 

To unsubscribe send a blank email to
techwr-l-leave -at- lists -dot- techwr-l -dot- com


Send administrative questions to admin -at- techwr-l -dot- com -dot-  Visit
http://www.techwhirl.com/email-discussion-groups/ for more resources and info.

Looking for articles on Technical Communications?  Head over to our online magazine at http://techwhirl.com

Looking for the archived Techwr-l email discussions?  Search our public email archives @ http://techwr-l.com/archives