Add option for trimming footer
Fidelity and perhaps other banks add a footer to the csv file (I suppose technically that isn't a CSV if they do that, but regardless they do). This requires manual editing of the file prior to ingesting in the tool.
Addition of an option to "Prune/Ignore X lines from the end" would remove this restriction.
An example of what this footer looks like for Fidelity:
The data and information in this spreadsheet is provided to you solely for your use and is not for distribution. The spreadsheet is provided for -- informational purposes only, and is not intended to provide advice, nor should it be construed as an offer to sell, a solicitation of an offer to buy or a recommendation for any security or insurance product by Fidelity or any third party. Data and information shown is based on information known to Fidelity as of the date it was exported and is subject to change. It should not be used in place of your account statements or trade confirmations and is not intended for tax reporting purposes. For more information on the data included in this spreadsheet, including any limitations thereof, go to Fidelity.com. Brokerage services are provided by Fidelity Brokerage Services LLC, 900 Salem Street, Smithfield, RI 02917. Custody and other services provided by National Financial Services LLC. Both are Fidelity Investment companies and members SIPC, NYSE. Insurance products at Fidelity are distributed by Fidelity Insurance Agency, Inc., and, for certain products, by Fidelity Brokerage Services, Member NYSE, SIPC. Date downloaded" 12/16/2022, 11:14 AM
After looking at some of the other enhancement requests this is unique but fits in the spirit of trim Headers (and footers) so it probably could be merged into a single enhancement
Thank you for your report @PilotJeff. I agree this is a similar situation as with the header rows. The functionality to cut off the first few rows is already there and it should be added for the bottom rows in a similar fashion. I will not have capacity to handle this anywhere near in the future but marking this as a welcome enhancement 🙌