• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

EVP Systems

  • Home
  • Support
    • Contact
    • FAQs
    • Tutorials
  • Software
  • Services
  • Account
    • Sign-Up
    • Payments
    • Sales Material
  • About Us
    • The Company
    • EVP Office
    • Professional Services
    • EVP Everywhere
    • EVP Upload
    • Pricing
    • Mailing Lists
    • Legal and Compliance
    • Contact Us

Excel Tutorial

EstateVal can export a report to Excel, to make editing it or sending it to other people easy.

EstateVal to Excel

To prepare EstateVal to export to Excel, select Tools → Options... → Export, and set Type to “Excel”, and Path to the folder you want the export to be sent to.

Now that EstateVal is configured, enter and evaluate the portfolio as usual and select File → Export → From EstateVal → [Report Type]…. to export the data. You will be prompted to enter an export file name and click OK—EstateVal will then show “The portfolio has been exported.”

To load the exported file as a spreadsheet, open Excel and choose a Blank (new) Workbook. Click File → Open and select the file from the folder you exported it to.  (If you are unable to see the file in the Excel open dialog, select “All Files” from the drop-down at the bottom of the dialog and you will be able to see all files available.)  Excel will ask if you would like to open the file anyway, since it’s in a different format that a normal spreadsheet—click Yes.  Choose “Delimited” as file type, hit Next, select “Comma” as its delimiter then Finish.

That’s it! Your report is now in Excel. You can save it as a normal Excel workbook if you want, to make reloading later easier.

Posted on September 26, 2020 • Tagged with Excel, Export, Tutorials

Primary Sidebar

Things You Should Know

  • A Lockdown Check-In on October 5, 2020
  • Upgrade Your Invoice on September 21, 2020
  • EVP Systems Introduces Modern, Streamlined Website on August 13, 2020
  • EVP Office 8.5.0 Released on June 17, 2020
  • EVP Systems Continues to Support Retired Versions of Windows on December 4, 2019
  • EstateVal 8.4.0 Prices Foreign Currencies, Precious Metals on October 25, 2019
  • GEMS Adds EVP Everywhere for Faster, Easier Pricing on April 15, 2019
  • EVP Office 8.3.1 Now Available; Features Easy Pricing of Puts and Calls on March 15, 2019
  • Reminder: Fee Changes Coming in 2019 on December 28, 2018
  • TEdec Adds Built-In Evaluations, with EVP Everywhere on December 3, 2018
  • Primary and Composite Exchange Pricing in EstateVal
  • A Brief Introduction to EstateVal

EVP Systems: Trusted for over 35 years!

Footer

About EVP Systems

Trusted by thousands of banks, brokerages, and law firms, Estate Valuations & Pricing Systems has been the leading provider of high-quality security evaluations for estate- and gift-tax purposes for over 35 years.

Get in Touch

1531 Chapala St., #1
Santa Barbara, CA 93101
(818) 313-6300 • FAX: (818) 313-6313
support@evpsys.com
sales@evpsys.com
Twitter
Mailing Lists

Explore the Site

EVP Everywhere Import CapWatch CCPA Report

All contents copyright © 1984–2021 Estate Valuations & Pricing Systems, Inc. · Do Not Sell My Personal Information