Skip to content
Solutions+
Industry's best value Save!
Smart Scheduling New!
Data Validation
Expert Help
Run your business efficiently
Cloud-based forms system
Instant market analysis
Cloud storage for appraisers
Add more users to your account
Desktop Formfilling
Report delivery
Flood maps
Websites
Read UAD XML files
Powerful cloud-based products
Sketching
Now featuring ScanToSketch
Mileage Totals
Fast and accurate comp data
Integrations for analytics, sketchers, office management, etc.

Integrated Spreadsheets Part 9: Importing from Excel

Many of you who are using WinTOTAL’s exclusive integrated spreadsheets have asked whether or not you can import your own custom spreadsheets you’ve built in Excel. The answer is: absolutely!

Knowing Excel well can be a benefit, and you can make use of the full Excel ribbon and other tools. Many appraisers are familiar with Excel, and employ its vast spreadsheet utilities in complex analytics outside of WinTOTAL. But if those analytics involve data that is either coming from (or will go back into) particular form fields in a report, it makes sense to integrate your Excel-written spreadsheets into WinTOTAL.

Here's how:

  1. Create your spreadsheet in Excel, and include any cell formatting and color scheme you normally use.
  2. Save the Excel file as an Excel 2003 (or earlier) version.
  3. From within WinTOTAL's worksheet view, click Open, and browse to your file. Link your form fields up and down as you need.
  4. Click Save.

That's it! WinTOTAL saves a copy of the linked spreadsheet into your program, and you can access it again from the default location with the Open button in your next report.

If you need a refresher on any of the previous tips on the worksheet, they're all right here in the blog. Just click "view recent posts" at the top.