Tips on cleaning up PDF exported to Excel RRs?
I've picked up a few tricks for doing this like TRIM/power query but I'm curious if anyone else has some additional tips/tricks. Any youtube video I've seen on the subject has used pretty "clean" excel docs. Anyone who has received PDF versions of rent rolls knows what I'm talking about... Tragic
Just at a curiosity, what function are you using?
TRIM() is great to remove excess/unwanted space
Text to columns is another great tool as well to split up data that got mashed together
I'm a bit of a noob w/ power query but I've found it useful for cleaning out useless data
From, adventures in CRE, I learned a pretty slick way of gathering all market rent/in-place rent from a MF rent roll using index/match
Simple copy and paste w/ transpose is also pretty useful
I am by no means an expert in Excel, but as simple of a function as it is, I have been using the snipping tool for PDF rent rolls and importing the picture through the "From Picture" function and producing really clean data. It's been crazy easy with certain RR's.
That's fucking NUTS. I'll have to give this a shot. Do you have any examples you'd be willing to share?
I am not sure with confidentiality agreements that I am able to share anything. But, it is really simple and I have had lots of success using that feature. What I did before that was uploading the PDF into Adobe and then selecting each row in a big data set and inserting it row by row, which was effective but incredibly inefficient for large data sets.
With this market you gotta just scrap the deal when broker sends PDF RR
I work in brokerage and the amount of PDFs I receive from clients is unreal lol
Able2Extract is the best PDF to excel converter I have come across. It's $150/year, but well worth it.
No. Merged. Cells.
Nihil dolorum ut possimus optio sit. Et natus cupiditate adipisci est. Quisquam in quibusdam illo. Rerum consequatur ratione culpa quod aut veniam dolorem.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...