The pixel
The pixel

How to Convert a TSV File to Excel

by | Jun 21, 2021 | Blog

We offer a number of analytical tools that allow you to analyze the real estate and mortgage industries, but every once in a while, we need to get back to basics.

When it comes to data, not only do you want it to be highly accurate, but it’s also critical to keep it organized in order to stay on top of your game. One common organizational issue that we often hear about is converting TSV files (tab-separated values) into Excel files successfully. We know Excel can be confusing, but we’ve simplified the process for you. Follow the steps below, and you will be able to convert a TSV to Excel in no time.

  1. Start by dragging your TSV file to your desktop
  2. Open Excel, locate Desktop Files, then select “All Files”

  1. Double click the TSV file you want to open
  2. Select “Delimited” and click “Next”

  1. Check “Other” and type a semi-colon in the box
  2. Click “Next”

  1. Click “Finish”

 

And that’s it! Now your file will open as an Excel sheet. After you’ve updated your data files and analyzed the new numbers, you’ll want to check out some of the other solutions offered by The Warren Group, including:

Data Licensing – We deliver the most accurate and detailed property and transaction information available. We offer ownership, NMLS, foreclosure, probate, property characteristics, sales and mortgage history, and so much more for millions of properties across the country.

Data Analytics – Harness extensive real estate and mortgage data sets to deliver compelling and actionable analytics to your company. With our data analytics, you can predict performance, identify opportunities, gauge trends, and detect risk, as you highlight the many ebbs and flows of your industry.

Loan Originator/NMLS Data – Access the largest and most comprehensive lending database in the country with our Loan Originator Module and NMLS Data Licensing opportunities. Take advantage of our data to view market trends, monitor competitors, and find productive loan officers.

Portfolio Analysis – The need for sound collateral valuation and monitoring has never been more prevalent. Portfolio Analysis Reporting (PAR) applies custom loan-level details and analytics specific to your portfolio data.

Want to speak directly to a Data Solutions Specialist? Schedule a meeting, email datasolutions@thewarrengroup.com or call 617-896-5331.