Universal Parser and Converter to CSV

Download and convert HTML, XML, JSON, CSV, Plain Text

Stocks quotes, option chains, financial reports, and much more

Five features you will like

1

Download and convert web data to CSV

Just specify the URL and the output file name.

WEB.CSV downloads the page, extracts data and converts the data to CSV.

  1. webcsv.exe WebToCSV http://www.nasdaq.com/symbol/aapl/dividend-history aapl.csv
2

Download data as is and parse downloaded files

You may download web data to local files and extract required data in several steps.

For example, financial report pages from Google Finance contain six reports.

  1. webcsv.exe WebToText "https://www.google.com/finance?q=AAPL&fstype=ii" aapl.htm
  2. webcsv.exe TextToCSV aapl.htm AAPL-IncomeStatement-Quarterly.csv /rootpath=2
  3. webcsv.exe TextToCSV aapl.htm AAPL-Balance-Quarterly.csv  /rootpath=4
  4. webcsv.exe TextToCSV aapl.htm AAPL-CashFlow-Quarterly.csv /rootpath=6
3

Automate your tasks in an easy way

WEB.CSV supports task files that contain URLs, output file names, and parser parameters.

You may export task files from a database and use a simple command in batch files like this:

  1. webcsv.exe WebToCSV @tickers.txt
4

Add columns to output CSV and customize output formats

WEB.CSV has a lot of options frequently used for parsing web data.

You may add required columns and customize the output for further import to a database easily.

  1. webcsv.exe WebToCSV https://finance.yahoo.com/q/hp?s=AAPL aapl.csv ^
  2.     /add=Symbol=AAPL;LoadDate=Date() /dateFormat=yyyy-MM-dd /separator=;
5

Download multiple pages in one command

WEB.CSV is a smart tool with a long history. It detects next page URLs and can download all of them.

For example, you may load option chains from Yahoo Finance for all expiration dates at once:

  1. webcsv.exe WebToCSV https://query1.finance.yahoo.com/v7/finance/options/AAPL aapl.csv ^
  2.     /rootPath=*.*.*.calls,*.*.*.puts /pages=20

You are ready!

Just try! You will like it.

Pricing

FeaturePersonalEnterprise
Loading web data
Loading multiple pages
Converting HTML, XML, JSON, and CSV to CSV
Task files
Perpetual license, per copy$49$99
Subscription, 1 year, per copy$24$49
Commercial usex
BuyBuy

Want more tools?

Try an SQL command line utility, gsqlcmd, that allows importing CSV data to databases.

Also, take a look at a specialized tool, Market.csv, that allows loading data from Yahoo Finance to databases.

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.