How to scrape in python into excel

Question

I would like to know how I would have a python web scrape dump all of it's results into excel. It's not that I don't know how to webscrape, it's just I do not know how to scrape into excel.

Check [this other thread](http://stackoverflow.com/questions/4257771/python-writing-to-excel-2007-files-xlsx-files) — Christian, Apr 21 '12 at 00:48
http://writemycode.net - give us something to comment on please — jdi, Apr 21 '12 at 00:49
I've developed a product that uses JavaScript rather than Python but sounds like what you need. It creates Excel so you can have multiple sheets. The demo and example projects that should provide an good start with it. [Script Scraper](http://www.scriptscraper.com/index.php) thanks, Martin — martsbradley, May 15 '12 at 21:25

score 2 · Answer 1 · edited May 23 '17 at 12:03

2

You say you know how to web-scrape, presumably into memory.

Then you just need to dump the contents into Excel. Use an Excel Python API .

edited May 23 '17 at 12:03

Community

1
1

answered Apr 21 '12 at 00:47

johnsyweb

136,902
23
188
247

It has been a while since the question you quoted and I have learned since then. Thanks for the link. – Damian Stelucir Apr 21 '12 at 01:18

score 2 · Answer 2 · answered Apr 21 '12 at 00:51

2

if you don't want to introduce a full excel library, you can write an HTML table or CSV and Excel will happily import those. The downside with this is that you're limited to one worksheet and no formulaes.

answered Apr 21 '12 at 00:51

Lie Ryan

62,238
13
100
144

How to scrape in python into excel

2 Answers2