I am doing some lead generation where I have a dynamic web page with names and email address. How can get this data into excel ?
Depends a lot on the format, how the page is generated (for how automated you might make it) and what your skill set is plus tools you might have.
- Copy and paste if the data is nicely formatted.
- Copy and paste with a round of Text Soap in between.
- Select the text and run a Keyboard Maestro macro to grab and process the text into a format for pasting.
- Create a text service in Automator and push it through whatever AppleScript and she’ll script utilities it takes to format it.
By default, Excel is configured to accept tab separated records by pasting (though it is possible to have it set otherwise.
Hope that helps.