Spreadsheets VS. DealRoom for Managing Due Diligence

It starts out straightforward: You kick off due diligence by creating a spreadsheet with the list of requests and documents that need to be tackled and gathered.

Then you assign the members tackling the work in the next column, and add due dates in another column.

It feels reasonably organized.

But it doesn't stay that way.

And as due diligence progresses, so does the exchange of emails, meetings, documents, and conversations.

Your spreadsheet quickly becomes out of date and lacks important context.

Sound familiar?

While spreadsheets are often used for due diligence, they weren’t designed for collaborating on complex work and managing lots of moving parts.

But it can be intimidating to try another tool because you don’t want to start all over from scratch.

Or getting people to shift from what they know can prove challenging.

With our Excel importer, you can import your spreadsheet right into DealRoom so you can begin managing due diligence in a collaborative, flexible tool with just a few clicks.

Why use DealRoom instead of spreadsheets?

Unlike a spreadsheet, everything is actionable and trackable in DealRoom.

Members added to the room can collaborate, communicate, assign work, and share files right in your room so everything stays connected—and everyone stays on the same page.

You can also set permissions on everything, so users don’t make accidental changes or see confidential documents.

And because DealRoom integrates with tools you already use, all project work stays connected, instead of scattered across emails, IMs, spreadsheets, documents, and other tools.

How to import an Excel file to DealRoom

If you use Excel, Google Sheets, and Smartsheet  projects into DealRoom, these spreadsheets can easily be converted to an Excel file, and then imported.

Once you’ve converted to a DealRoom excel file template:

  1. Log in to DealRoom
  2. Go to the "Requests" Tab
  3. Hit Import
  4. Download Template
  5. Format Your Excel Into Template (Copy/ Paste) and Save
  6. Be Sure to Follow Template Columns
  7. Choose File (Most Recently Saved Template)
  8. Hit Import Again

And done!

Once you’ve imported a spreadsheet to a project, any additional spreadsheets you import to the project will add to, not replace, the information you already have in the project.

Map Your Spreadsheet to DealRoom

To ensure a successful import, here are some formatting tips for your excel file:

  • Assignee: The column with the names of members responsible for the requests will be mapped to the assignee field in DealRoom.
  • Dates: You can track both start and due dates in DealRoom. In your spreadsheet, separate these dates into two columns. Your date columns need to be formatted in the standard US date format of month/day/year to import successfully.
  • Other information: In addition to file name, assignee, and dates, other columns can be mapped to custom fields. Custom fields help you categorize and track priorities; you can also sort or search by field. Some good uses for custom fields are priority, status, team, and estimated time.

Once you’ve mapped your columns and imported the spreadsheet, you can move tasks and sections around.

You will have the ability to add members, reviewers, and followers to tasks, attach files, and share status updates.

Making the Change

Change can be hard, and taking the first step to implementing a new tool and system is the hardest part.

We hope the Excel importer makes it easy to get out of tracking your projects in spreadsheets so you can manage your due diligence in a collaborative and dynamic project management tool.

Because seriously, why manage due diligence the same way you did 20 years ago?

Learn More

By
Kison Patel

Subscribe to our newsletter

Thank you for subscribing! Your submission has been received!
Oops! Something went wrong while submitting the form.