how to convert pdf file to excel file using python

Question

I want to convert a pdf file into excel and save it in local via python. I have converted the pdf to excel format but how should I save it local?

my code:

df = ("./Downloads/folder/myfile.pdf")
tabula.convert_into(df, "test.csv", output_format="csv", stream=True)

score 9 · Accepted Answer · answered Nov 04 '19 at 09:41

9

You can specify your whole output path instead of only output.csv

df = ("./Downloads/folder/myfile.pdf")
output = "./Downloads/folder/test.csv"
tabula.convert_into(df, output, output_format="csv", stream=True)

Hope this answers your question!!!

answered Nov 04 '19 at 09:41

skaul05

2,154
3
16
26

score 2 · Answer 2 · edited Aug 08 '20 at 13:48

2

In my case, the script below worked:

import tabula

df = tabula.read_pdf(r'C:\Users\user\Downloads\folder\3.pdf', pages='all')
tabula.convert_into(r'C:\Users\user\Downloads\folder\3.pdf', r'C:\Users\user\Downloads\folder\test.csv' , output_format="csv",pages='all', stream=True)

edited Aug 08 '20 at 13:48

David Buck

3,752
35
31
35

answered Aug 08 '20 at 12:48

Darshil Lakhani

35
6

Khoirul Anam · Answer 3 · 2023-03-07T03:31:24.043

1

i use google collab

install the packege needed

!pip install tabula-py
!pip install pandas

Import the required Module

import tabula
import pandas as pd

Read a PDF File

data = tabula.read_pdf("example.pdf", pages='1')[0] # "all" untuk semua data, pages diisi nomor halaman

convert PDF into CSV

tabula.convert_into("example.pdf", "example.csv", output_format="csv", pages='1') #"all" untuk semua data, pages diisi no halaman
print(data)

to convert to excell file

data1 = pd.read_csv("example.csv")
data1.dtypes

now save to xlsx

data.to_excel('example.xlsx')

edited Mar 07 '23 at 03:31

answered Feb 23 '23 at 02:02

Khoirul Anam

11
3

Please fix the broken code blocks at the end of your post. Thanks! – Blue Robin Feb 27 '23 at 15:13

score 0 · Answer 4 · answered Nov 04 '19 at 09:43

Documentation says that:

Output file will be saved into output_path

output_path is your second parameter, "test.csv". I guess it works fine, but you are loking it in the wrong folder. It will be located near to your script (to be strict - in current working directory) since you didn't specify full path.

score 0 · Answer 5 · answered Apr 08 '21 at 10:03

0

PDF to .xlsx file:

for item in df:
   list1.append(item)
df = pd.DataFrame(list1)
df.to_excel('outputfile.xlsx', sheet_name='Sheet1', index=True)

answered Apr 08 '21 at 10:03

Hith

49
5

score 0 · Answer 6 · answered Dec 07 '22 at 11:31

0

you can also use camelot in combination with pandas

import camelot
import pandas
tables = camelot.read_pdf(path_to_pdf, flavor='stream',pages='all')
df = pandas.concat([table.df for table in tables])
df.to_csv(path_to_csv)

answered Dec 07 '22 at 11:31

smoquet

321
3
11