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

EVP Systems

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

Excel Tutorial

EstateVal can import lots from, and export reports to, Excel.

Excel to EstateVal (Import)

While in Excel, save your data as a “CSV (MS-DOS)” file. “CSV” stands for comma-separated values, and will cause the data to be output as it is stored in the spreadsheet—Column A will be the first item, Column B the second, etc.

After doing so, you can open EstateVal and go to Tools → Options... → Export and set Type to “Custom (Field)”. Enter the file’s extension (“CSV“) and point Path to where the file is located. Also, enter the columns that the Security Identifier and Shares are saved in. For instance, if the CUSIP was in Column C in your spreadsheet and the Shares were in Column F, you would enter 3 for Symbol Field and 6 for Shares Field.

Now, you are ready to import. Go to File → Import → To EstateVal, select the file and click Import. That’s it! All your securities are now in EstateVal.

Note: Should you have any trouble with the imported numbers, go back to your spreadsheet file and make sure to change the CUSIP column to a text format and the Shares column to a numeric format, without a comma, and the entries left-justified, before you save out the CSV.

Excel to EstateVal (Copy-and-Paste)

You can also simply copy-and-paste one or more columns—either the whole column or specific rows—from Excel and paste them directly into the grid in EstateVal.

EstateVal to Excel (CSV)

To prepare EstateVal to export to Excel, select Tools → Options... → Export, and set Type to “Excel (CSV)”, 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.

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

EstateVal to Excel (XLSX) and Excel (XSLX, Simple)

To prepare EstateVal to export to Excel, select Tools → Options... → Export, and set Type to “Excel (XLSX)” or “Excel (XLSX, Simple), 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.”

Your report is now in Excel (either in a format that mirrors the traditional report, or in a simpler format that shows one security per row), and you can double-click on the file to open it.

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

Primary Sidebar

Things You Should Know

  • Good to Know: Reports on April 9, 2025
  • Happy Holidays from EVP Systems! on December 9, 2024
  • Fee Changes for 2025 on November 1, 2024
  • We're Going to Disneyland---for NAEPC 2024! on October 18, 2024
  • CrowdStrike BSOD and EVP Systems
  • EVP Office 9.1.3 Now Available on July 18, 2024
  • EVP Office 9.1.0: Now Available, Featuring Name Preview on January 8, 2024
  • EVP Systems at Heckerling 2024 on January 3, 2024
  • Happy Holidays from EVP Systems! on December 11, 2023
  • EVP Systems at the California Probate Referees Conference on November 30, 2023
  • Join us at NAEPC 2023 on November 11, 2023
  • Good to Know: The Grid on August 23, 2023
  • Announcing Fee Changes for 2023 on October 7, 2022
  • "Single Broker Quotes" Available Again on April 14, 2022
  • EVP Systems Prepared for Russia / Ukraine Conflict on March 14, 2022
  • Expat and Open Source at EVP Systems on March 1, 2022
  • EVP Office 9.0.1 Offers Built-In Calculator, More Crypto, New Export on February 8, 2022
  • Jack Barthel, 1937 - 2021 on January 19, 2022
  • EVP Systems Unaffected by log4shell and Associated Vulnerabilities on December 13, 2021
  • EVP Office 9: Something Big! on October 13, 2021
  • EVP Office 8.5.3: Secure by Default on July 13, 2021
  • Ready for Windows 11 on July 2, 2021
  • EVP Office 8.5.2: Native Excel Export, Better Copy-and-Paste, Mailing Lists on April 8, 2021
  • 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

Don’t let death and taxes ruin your day!

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 40 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 Systems Foreign Currencies CCPA Support Training Mode

All contents copyright © 1984–2025 Estate Valuations & Pricing Systems, Inc. • Do Not Sell My Personal Information • Service Status