Convert pdf document to excel file

Thinking of upgrading your handphone or PC again? Trying to manage your children's use of technology? Come and share your experiences!

Convert pdf document to excel file

Postby Jennifer » Tue Oct 27, 2015 6:30 pm

I googled and realized there are a few software that can convert pdf document into excel file.

Anyone can recommend which software they are using.

I need the converted data to be useable as part of formula computation, not merely text fields.

Many thanks in advance.

Jennifer
KiasuGrandMaster
KiasuGrandMaster
 
Posts: 23240
Joined: Fri Sep 05, 2008 1:10 pm
Total Likes: 106


Re: Convert pdf document to excel file

Postby atrecord » Wed Oct 28, 2015 3:11 pm

Jennifer wrote:I googled and realized there are a few software that can convert pdf document into excel file.

Anyone can recommend which software they are using.

I need the converted data to be useable as part of formula computation, not merely text fields.

Many thanks in advance.


Not sure about free software, but I know that Adobe Acrobat Pro (not the Reader) can easily convert PDF docs into the application files if they were created in MS Word or Excel.

atrecord
KiasuGrandMaster
KiasuGrandMaster
 
Posts: 2222
Joined: Wed Feb 17, 2010 11:25 am
Total Likes: 6


Re: Convert pdf document to excel file

Postby Jennifer » Wed Oct 28, 2015 4:24 pm

atrecord wrote:
Jennifer wrote:I googled and realized there are a few software that can convert pdf document into excel file.

Anyone can recommend which software they are using.

I need the converted data to be useable as part of formula computation, not merely text fields.

Many thanks in advance.


Not sure about free software, but I know that Adobe Acrobat Pro (not the Reader) can easily convert PDF docs into the application files if they were created in MS Word or Excel.


Thank you for sharing.

My source is from MYOB, not MS office.

:sweat:

Jennifer
KiasuGrandMaster
KiasuGrandMaster
 
Posts: 23240
Joined: Fri Sep 05, 2008 1:10 pm
Total Likes: 106


Re: Convert pdf document to excel file

Postby lynntan15 » Wed Oct 28, 2015 4:45 pm

Jennifer wrote:My source is from MYOB, not MS office.

:sweat:

Why don't you check whether MYOB allows you to save the file as Excel, CSV instead of pdf?

Most accounting software should be able to export as CSV.

lynntan15
BlueBelt
BlueBelt
 
Posts: 303
Joined: Mon Sep 13, 2010 3:17 pm
Total Likes: 2


Re: Convert pdf document to excel file

Postby Jennifer » Wed Oct 28, 2015 4:47 pm

lynntan15 wrote:
Jennifer wrote:My source is from MYOB, not MS office.

:sweat:

Why don't you check whether MYOB allows you to save the file as Excel, CSV instead of pdf?

Most accounting software should be able to export as CSV.


I wrote to them to ask about print to excel, still an editable file. Now waiting for a reply.

What is CSV?

Jennifer
KiasuGrandMaster
KiasuGrandMaster
 
Posts: 23240
Joined: Fri Sep 05, 2008 1:10 pm
Total Likes: 106



Re: Convert pdf document to excel file

Postby lynntan15 » Wed Oct 28, 2015 4:56 pm

Jennifer wrote:What is CSV?


Comma separated values text files (.csv), in which the comma character (,) typically separates each field of text.

There is a function "TEXT-to-Column" in Excel that allows you to convert CSV to excel file when you open it.

Link to convert pdf to excel online.
https://www.pdftoexcelonline.com/en/

lynntan15
BlueBelt
BlueBelt
 
Posts: 303
Joined: Mon Sep 13, 2010 3:17 pm
Total Likes: 2


Re: Convert pdf document to excel file

Postby Jennifer » Wed Oct 28, 2015 5:03 pm

lynntan15 wrote:
Jennifer wrote:What is CSV?


Comma separated values text files (.csv), in which the comma character (,) typically separates each field of text.

There is a function "TEXT-to-Column" in Excel that allows you to convert CSV to excel file when you open it.

Link to convert pdf to excel online.
https://www.pdftoexcelonline.com/en/



:thankyou: :thankyou: :thankyou:

I just tried, seems to be what I am looking for :rahrah:

edit to add: format is ok, but the figures are not values.

Is it possible to change the figures into real numbers that I can sum up?

Jennifer
KiasuGrandMaster
KiasuGrandMaster
 
Posts: 23240
Joined: Fri Sep 05, 2008 1:10 pm
Total Likes: 106


Re: Convert pdf document to excel file

Postby lynntan15 » Fri Oct 30, 2015 10:19 am

Sorry for the late reply. If you highlight the cell number, on the top left hand, you will be able to see a "yellow" sign. You can click on it and change the value to number.

http://osiprodeaodcspstoa01.blob.core.w ... ecc2c3.jpg

lynntan15
BlueBelt
BlueBelt
 
Posts: 303
Joined: Mon Sep 13, 2010 3:17 pm
Total Likes: 2


Re: Convert pdf document to excel file

Postby Jennifer » Fri Oct 30, 2015 10:31 am

lynntan15 wrote:Sorry for the late reply. If you highlight the cell number, on the top left hand, you will be able to see a "yellow" sign. You can click on it and change the value to number.

http://osiprodeaodcspstoa01.blob.core.w ... ecc2c3.jpg


:thankyou:

Jennifer
KiasuGrandMaster
KiasuGrandMaster
 
Posts: 23240
Joined: Fri Sep 05, 2008 1:10 pm
Total Likes: 106



Return to Technology & Gadgets