Satisfaction Guarantee
EZIaccounts - Making Accounting Easy

Making life easier.

Demo | Login | FAQ
Search box displays here

Create CSV file from HTML


How to create a csv comma delimited file from html follow the 10 easy steps :


Step 1:
Open the HTML file in a good text editor and delete all information before and after the TABLE with all your bank transactions inside and save.

Step 2:
Open your Excel program and have it blank with a reduced window so you can now see your files and the BLANK Excel window.

Step 3:
Drag each html file into it your Excel window.

Step 4:
In Excel click the following: "View tab"..."Arrange All" ...select "Verticle" radio button ...and .."OK"

Step 5:
All files should be cascaded in one view down that page. On the first page with the Lowest dates remove all lines that are NOT transactions including Opening and Closing balance lines.

Step 6:
Begin from the second page of lowest to highest, select and highlight the transaction lines required...cut and then paste to the below the last transaction on the FIRST page and follow the same for each remaining page until all pages have been done.

Step 7:
All pages have been cut and only the one page of transactions remains.
Click to focus on the first page with all the transactions and click the icon at the left top corner and click "Save as"...."Other Formats".....select "CSV comma delimited" and save where required.

Step 8:
Close the other pages and DO NOT SAVE ....so they are still as they were when you started.

Step 9:
Open the newly created CSV file and you should see all the lines of transactions.

Step 10:
In order to clear out unwanted import properties....click the top of the "amount columns" (C,D etc) and change cells to number format making sure the number format is set to 2 decimal places

Done...task complete.