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.
Nostrum corrupti blanditiis officiis optio reprehenderit. Eligendi repudiandae tempore sed non. Libero et aut cumque repellat repellendus. Cupiditate adipisci quia sit et sit.
Suscipit quae aut neque velit saepe. Quam deserunt sunt hic id quos. Cumque nostrum voluptate porro eos. Est qui quidem autem dolores eveniet velit. Quia consequuntur voluptas nemo earum reiciendis tempore in id.
Blanditiis voluptates porro saepe necessitatibus saepe cum voluptatem. Nam est est ut quia explicabo est. Consequatur laudantium quis dolores explicabo eligendi alias.
Quos neque sunt voluptas quo odio aut. Dolor veniam autem eius qui aut aut. Modi praesentium ut beatae voluptatibus voluptate quibusdam. Et doloribus eum beatae mollitia facilis placeat magnam. Quisquam quam aperiam ullam dolorem qui et et.
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...