Convert PDF to Excel without PDF converter - EBOOK VBA EXCEL

EBOOK VBA EXCEL

EVBA.info ( Ebook VBA Excel ) Welcome EVBA.info - Nothing Is Unable ... About Excel Tricks, Learning VBA Programming, Dedicated Software, Accounting, Living Skills ...

Search This

Tuesday, December 3, 2019

Convert PDF to Excel without PDF converter

Convert PDF to Excel without PDF converter

Does it sound familiar?
Excel Tips - PDF to Excel
There are many online-converters.  I tried a few of them (freebies) but the result was not satisfactory sometimes.  I don’t blame them as I had managed my expectation. 

Without PDF converter, what I tried to do was COPY and PASTE… as you may already know, there is no luck…  The following screen shot shows what I got from COPY and PASTE….Excel Tips - PDF to Excel 2 (well, the clip art was added afterward.)
See!? Data on different columns were concatenated by space, all in column A.  There is no simple way for me to re-organize the pasted data back into a table format, not even with Text to Columns as there is no fixed delimiter nor width.  And there were 10 pages of data…
One day, I read an article about viewing PDF file from OneDrive: PDF file we put in OneDrive would be viewed in Word Online… Then I tried to connect the dots…  BINGO, that’s the solution although imperfect.

1) Login OneDrive (previous known as Sky Drive)Excel Tips - PDF to Excel 3

(Note: You should have it already if you have in email account by Microsoft, e.g. hotmail.  If you don’t, you may sign up for one)

2) Upload your PDF file simply by drag and dropExcel Tips - PDF to Excel 4

3) Click on the file you have just uploadedExcel Tips - PDF to Excel 5

4) Word Online is opened to show you the content of the pdf file.  Click “Edit in Word”.Excel Tips - PDF to Excel 6

5) wow… Word Online is going to convert the PDF to Word for me to edit.  Sound good!  Select “Convert”.  Excel Tips - PDF to Excel 7

6) Yes.  There is a limitation.  I can do nothing but accept it.  Let’s “Edit”.

Excel Tips - PDF to Excel 8

7) Let’s “OPEN IN WORD“.  Yes, the familiar Word on your computer.  (note: you may be prompt to login again)Excel Tips - PDF to Excel 9

8) This is what you get!  Because it is Word, it communicates with Excel much much better.  What follows is just simple steps of COPY and PASTE.

Excel Tips - PDF to Excel 10

9) Here we go!

Excel Tips - PDF to Excel 11

As you may have noticed, the output is imperfect:
  • The headers are sitting on two rows instead of one, and they are merged.
  • To scroll down, we see blank rows which was page break in the original PDF file.Excel Tips - PDF to Excel 12
  • Further editing may be required as some layout may not be converted properly.
  • Degree of further editing may vary depending on how the original PDF was created.
Nevertheless, it is already a BIG STEP forward, isn’t it?.  This trick saves me more enough time to compliment than to complain.
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

No comments:

Post a Comment