PDF to Excel

[VaticanAssassin]

Anyone know a good way/program for converting...

Other than tab delimited.

Lots of numbers and columns......

 

[VaticanAssassin]

useless fuckers!

 

[Disgustipated]

Do you mean Excel to PDF?

 

[Wings]

You can't just insert it like a picture?

 

[VaticanAssassin]

Do you mean Excel to PDF?

nope. I need to turn a PDF to Excel.

 

[VaticanAssassin]

You can't just insert it like a picture?

I could...but the whole idea is to be able to manipulate 137 pages of PDF that include 7 columns and 23 rows of raw data. (numbers)

 

[Disgustipated]

nope. I need to turn a PDF to Excel.

PDF to Excel Coverter

 

[O-dad's Medium]

useless fuckers!

PDF to Excel Coverter

Impatient fucker.

 

[VaticanAssassin]

I have tried about four different converter from online...So far they are all fucking useless!


My admin is going to hate me, but I am passing this shit off. Good thing she types fast

 

[O-dad's Medium]

Open the PDF.

Select all the cells.

Copy.

Paste to Notepad.

Save as .txt

Import to Excel as Tab Delimited.

...oy

 

[thør]

My admin is going to hate me, but I am passing this shit off. Good thing she types fast

It all pays the same........

 

[VaticanAssassin]

Open the PDF.

Select all the cells.

Copy.

Paste to Notepad.

Save as .txt

Import to Excel as Tab Delimited.

...oy

This^

Works 90% of the time. But for some reason this data pastes in to notepad as one long as column. Then when I import it is absolutely worthless. I have seen it happen before and just ended up doing it manual. But giving the size of the document I was hoping to spare someone hours of work....


Thanks anyway!

 

[O-dad's Medium]

This^

Works 90% of the time. But for some reason this data pastes in to notepad as one long as column. Then when I import it is absolutely worthless. I have seen it happen before and just ended up doing it manual. But giving the size of the document I was hoping to spare someone hours of work....


Thanks anyway!

My condolences.

However even if you do get one long ass column, it's quicker to move the cells about than to re-key it all.

 

[about_average]

Notepad is a piece of shit.
Use a real editor like jedit. You should be able to use a macro to then do what you want.
Where did the PDF come from? can you get a copy of the document they exported to pdf?

 

[VaticanAssassin]

Notepad is a piece of shit.
Use a real editor like jedit. You should be able to use a macro to then do what you want.
Where did the PDF come from? can you get a copy of the document they exported to pdf?

I will try jedit next time.

But I did figure out the issue. Most the shit I deal with comes from Brokers excel spreads that they then send in Adobe. This one was exported from their system in to word. Because all the word formating it would not allow me to convert to excel correctly. I converted to word first then excel and all was good.....

 

[about_average]

Most the shit I deal with comes from Brokers excel spreads that they then send in Adobe. This one was exported from their system in to word.

Why people insist on distributing stuff like that in a proprietary format is beyond me. It's not like csv is hard to do.