Script to download manually generated excel file on reference website?
<p>I am specifically looking at the ReferenceUSA website. To download information, one has to manually select all the items, then click download, and then on another page click to generate a CSV file. Is there anyway to automate this kind of process?</p>

<p>You could try Selenium, here is an example to open a web page, and click a button.</p>

<pre><code>&gt;&gt;&gt; from selenium import webdriver
&gt;&gt;&gt; browser = webdriver.Chrome()  ## now web browser opened
&gt;&gt;&gt; browser.get("https://www.python.org")  ## now python.org web page opened
</code></pre>

<p>There is a button "GO", its page source code like this:</p>

<pre><code>button type="submit" name="submit" id="submit" class="search-button"... 
</code></pre>

<p>Now, click this button</p>

<pre><code>&gt;&gt;&gt; browser.find_element_by_id("submit").click()
</code></pre>

python automation