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)
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.”
Your report is now in Excel, and you can double-click on the file to open it.