Not primarily related to Excel, gut maybe you can help. Need to extract pdf data into an Excel sheet, structure is always the same, I.e. Headline in column A, first sentence in column B, next paragraph im column C, etc.
Do you have recommendations for a good parser or some sort of AI tool to do that? Pdf has 330 pages and should populate roughly 150 rows in Excel with given structure. Thanks a lot!

like
Posting as :
works at
You are currently posting as works at

Power Query in Excel can do this. Parsing 300 pages will be slow but it'll get the job done.

like

Thanks!

Related Posts

How is the IBM Consulting practice in Canada? How does it compare to the Big4 consulting practices, and what sort of projects/clients does it work with?

funnylike

Notice period in jpmc is 1 month or 2 months?

like

Does anyone have any experience with taking additional classes after undergrad to raise gpa?

like

I need Christmas gift ideas. I need gifts for my portfolio managers, sales staff and one for the lobby attendant. I don’t like gift cards. Ideas?

like

Hello fishes, what should be the right salary range for 9.5 yoe in development. Technology is Python and Java. Amazon Newco Larsen & Toubro Infotech IBM Tech Mahindra

like
like

Republican or Democrat... I think we can all agree with this 👇

Post Photo
likefunnyhelpful

Anyone live in east harlem in New York around 104th street? Thinking of leasing near there. Is the neighborhood fairly safe?

like

How much value do organizations give to managers/principals/partners who are great at developing internal talent? Does it make it easier to move up?

funnylikehelpful

29, Currently a Deli Manager with over 3 years experience. I am completely burned out. I need a immediate career change we’re I can continue to support my self. I have experience in Banking, Real Estate, Shipping, caregiving, and the obvious retail experience. I do unfortunately have a deferred adjudication for theft it was dismissed a year ago, so I have 4 more years to seal the record. I would appreciate any recommendations. Background check anxiety holds me back .

Looking for encouragement/ inspirational books for my teenage (14) nephew 🙏🏾☀️

like

How the market right now? Is it a good time to make a move?

funnylike

Any SAP PP job opening in Pune, please ping and refer, looking an apportunity for my husband who's holding 6 years of total exp. And 3 years into SAP PP Infosys Wipro Deloitte Tata Consultancy Accenture SAP

like

Hi all, I’m gonna join pwc ac Bangalore next month. I need your help In knowing the holiday calendar or holidays available in last week of December I.e in between Dec 25th to Dec 31st. To plan my vacation. Please help

Need a letter of recommendation from someone outside my network.

Anyone in the world of willing to help me out?

like

First time home buyer and I have no idea what I can afford. Excellent credit. I know to get a preauthorization before looking but want to skim homes the meantime. Any good rule of thumb when searching?

like

I’m a manager in PwC’s human capital practice. I’m getting recruiting messages from the other Big 4, as I imagine most of us are. I’m interested in hearing about human capital consultants who went from PwC to one of the other firms, as well as people who came from one of the other firms to PwC. Happily ever afters as welcome as horror stories here. Thanks!

like

Hii fishes
I had applied for consultant role in Societe generale. The application status is under status "Under Consideration".If you could please help me out as there has been no update and it is going to be 1 month since I applied.

S&P Global I am starting my new job tomorrow at S&P Global
Any tips and tricks to remember in order to do better at my new work place.

like

Additional Posts in Excel Genius

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

How do you fix microsoft excel cannot paste data error?

like

How do I compare two sheets to make sure they are identical?

like

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

Would anyone be willing to teach me vlookup?

like

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

like

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

Still don't have xlookup. #fomo

like

Any book recommendations on excel modeling for real world business applications?

like

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal