Excel spreadsheet --> web form macro/automation?

[konichiwa]

Hi--

I've got a lot of data in an Excel spreadsheet that I need to transfer into a web-based contacts program. It's name, email, phone number(s), address, etc kind of information. It's becoming incredibly tedious to do this by hand, one contact after another (thousands of contacts) and I'm wondering if anyone has any ideas as to how I could automate this process?

I'm not very experienced using Excel or advanced macros in Office but I've used Office for long enough and been programming (lightly, as a hobby) enough that I have the basic tools I would think I need for this type of thing, I just don't really know where to start.

Can anyone point me in the right direction or provide some insight?

Thanks!

 

[Armitage]

Save it as a CSV file, then write a simple script to parse out the fields.
You can probably have the script push the data into the contacts program via the web interface - I'd have a look at the CURL library, or hack together a lynx script.

 

[WW]

a quick way is to use the sendkeys function in an excel vba macro....

basically it simulates a keystroke...so have it duplicate the keystrokes you use now...alt tab, copy, paste, tab, etc

see here for sendkey commands

maybe use macro recorder in excel to get you started...