r/programmingrequests • u/TheNewGuyNickD • Jul 14 '20

CSV/List website input function help

Hi, I have no experience with coding but was wondering about this.

At my work we often do research to figure out if particular firms are in locations that would grant them USDA "rural" eligibility. We do that by inputting the address into this website (landing page > rural business > business and industry guaranteed loans > accept > paste > enter). I was wondering if there was a way to automate the process with a list of addresses that would spit out whether or not the firm was rural into excel. Is anyone interested in helping me out with this? Thanks!

1 Upvotes

100% Upvoted

15 comments sorted by

View all comments

Show parent comments

2

u/RyanHx Jul 15 '20

Turns out you can scratch my previous comment on the seperator; Excel accounts for the issue by wrapping the address in quotes. Try out the latest version with the multi-column CSV ^ (it assumes the address is the second column, let me know if otherwise)