Just enter the prompt "Create a table from the following bank statement information:". Then copy and paste the statement information from the PDF file.Excel use to create statements from statement bank. Download a free Account Statement Template for Microsoft® Excel®, OpenOffice. Statement of Account Excel Template. In this quick tutorial video, we teach you how to use the Accounting number format in Excel and change number formats of your data. Typically, bank statements come in either PDF or CSV format. Each has its own set of challenges and advantages when it comes to conversion. In this video video you will learn how to build an income statement in Excel with data for any company. The problem is with the formatting of the financial numbers.