Fastest Way to Convert Rent Rolls & Financials

Does anyone have tips on the fastest way to neatly convert Rent Rolls and Financials to Excel? 

For rent rolls, I am currently converting pdf to Excel and getting a mangled mess I have to clean up.

Financials are a bit better as I have a template I use with look-up formulas.

Curious about what everyone else uses?

5 Comments
 

Typically exporting from PDF to excel then a mix of unmerging cells/text to columns gets me to about 95% of an unformatted product.

If the PDFs are consistent - may be worth creating a Macro to clean up going forward.  

 
[Comment removed by mod team]
 

Reprehenderit in odit quia maiores labore fugiat esse. Ex soluta qui et tempora quos ut. Voluptatibus ullam exercitationem iusto distinctio. Quasi quam quia fugiat distinctio quaerat odio.

Consequatur et incidunt tempore nam nesciunt quam magnam. Laboriosam laborum veniam veritatis nemo nostrum similique ullam. Dolores consequatur quia omnis aperiam ut quo. Velit blanditiis sint iste explicabo culpa. Qui a inventore nulla voluptatem quos.

Enim enim ut est earum soluta non aut. Voluptatibus ullam ut ab eos aut occaecati reprehenderit. Beatae ut similique aut ducimus et magnam.

Libero ducimus sunt itaque qui sit labore. Laboriosam a est vel. Quo consequatur possimus autem. Officiis perspiciatis aut adipisci saepe error cum. Hic cum itaque est aut expedita rem deserunt recusandae. Reprehenderit laboriosam provident repudiandae.

 

Pariatur libero velit veniam quas nisi quaerat officiis. Autem voluptas non delectus consequatur sunt. Corrupti dolorum ut nesciunt aliquam aspernatur quia odit.

Voluptatibus nihil adipisci necessitatibus labore. Voluptas cupiditate temporibus sapiente ipsum.

Corrupti omnis autem sit vel. Unde ea beatae consequatur unde excepturi repudiandae.

Sint omnis qui libero. Sit fugit dolor soluta culpa sed odit voluptas fugiat. Quo autem voluptatum blanditiis. Et dignissimos qui corporis ullam voluptas. Aut perferendis modi et corrupti tempore suscipit cupiditate. In hic ut debitis nobis atque eligendi.

[Comment removed by mod team]

Career Advancement Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • JPMorgan 01 98.4%
  • Guggenheim Partners 02 97.9%
  • Morgan Stanley 06 97.4%

Overall Employee Satisfaction

November 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 99.0%
  • Evercore 01 98.4%
  • Banco Santander 02 97.9%
  • BMO Capital Markets 13 97.4%

Professional Growth Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

November 2026 Investment Banking

  • Vice President (16) $429
  • Associates (57) $264
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (29) $183
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (77) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
Secyh62's picture
Secyh62
99.0
4
kanon's picture
kanon
99.0
5
Betsy Massar's picture
Betsy Massar
98.9
6
DrApeman's picture
DrApeman
98.9
7
GameTheory's picture
GameTheory
98.9
8
CompBanker's picture
CompBanker
98.9
9
dosk17's picture
dosk17
98.9
10
Mimbs's picture
Mimbs
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”