HELP!
I get how to do the one over one simple macro scripting but I hoped either someone would assist and break this down in greater detail (FYI - I have read MOST of these posts and still did not understand how to do this) ... so I am requesting help.
How do I get this to work
site
username
password
https://en.wordpress.com/wp-login.php
xxxxx
yyyyyy
http://www.blogger.com/legacy-claim.g
abcdefg
tttttttt
How do I (does anyone have a sharable script for this EVEN if the site names are different):
a) get this to open a new firefox page with each URL (column 1 -row 2 and row 3) and READ read colum 1 ... row 2 and 3
b) READ column 2 username/password (associate username/password) to the correct site
c) is it best to use Excel OR csv OR txt
d) obviously I want to repeat this process with more rows and sites
ALL assistance here is appreciated!


There is no "best" way to do that. There is an easier way and a harder way. In my experience, if you have Microsoft Excel installed in you machine, the easiest way to do it is through the Excel actions. The format is not very important: you can open both csv and xls(x) files with the actions under "Excel" category.
This sounds like a pretty unusual Excel formatting example. Can you please attach a sample xls(x) file so that we can understand how your data is structured? There is no need for the file to have actual data in it.
==Dedicated Automation Solutions==
==Dedicated Automation Solutions==