Extract data from PDF tables using Tabula

Extract data from PDF tables using Tabula : Tabula PDF Extract


1
2		Extract data from tables in PDFs using Tabula (Convert to CSV)
3
4	Table name : daily historical stock prices & volumes
5	Date	Open	High	Low	Close / Last	Volume
6	01/04/2017	62.48	62.75	62.12	62.3	21,325,140
7	01/03/2017	62.79	62.84	62.125	62.58	20,655,190
8	12/30/2016	62.96	62.99	62.03	62.14	25,575,720
9	12/29/2016	62.86	63.2	62.73	62.9	10,248,460
10	12/28/2016	63.4	63.4	62.83	62.99	14,348,340
11	12/27/2016	63.21	64.07	63.21	63.28	11,743,650
12	12/23/2016	63.45	63.54	62.8	63.24	12,399,540
13	12/22/2016	63.84	64.1	63.405	63.55	22,175,270
14	12/21/2016	63.43	63.7	63.12	63.54	17,084,370
15	12/20/2016	63.69	63.8	63.025	63.54	26,017,470
16	12/19/2016	62.56	63.77	62.42	63.62	34,318,500
17	12/16/2016	62.95	62.95	62.115	62.3	42,452,660
18
19	http://www.nasdaq.com/symbol/fb/historical
20	Date	Open	High	Low	Close / Last	Volume
21	01/04/2017	117.55	119.66	117.29	118.69	19,594,560
22	01/03/2017	116.03	117.84	115.51	116.86	20,635,600
23	12/30/2016	116.595	116.83	114.7739	115.05	18,668,290
24	12/29/2016	117	117.531	116.06	116.35	9,925,082
25	12/28/2016	118.19	118.25	116.65	116.92	11,985,740
26	12/27/2016	116.96	118.68	116.864	118.01	12,034,590
27	12/23/2016	117	117.56	116.3	117.27	10,885,030
28	12/22/2016	118.86	118.99	116.93	117.4	16,226,770
29	12/21/2016	118.92	119.2	118.48	119.04	10,747,610
30	12/20/2016	119.5	119.77	118.8	119.09	13,673,570
31	12/19/2016	119.85	120.36	118.51	119.24	15,871,360
32	12/16/2016	120.9	121.5	119.27	119.87	25,316,220
33
34	Notes
35
36	Tabula is an excellent application (Mac, Windows, Linux) for extracting data held within tables in PDFs.
37	This CSV file of the extracted data can then be easily imported for use in Google Sheets as above.
38
39	Learn more about Tabula
40
41	Click here to view the source PDF for the Tabula extraction above
42
43	Created by Leighton Price

Published by Google Sheets–Report Abuse–Updated automatically every 5 minutes