Turn a bank export into a clean Excel file
Bank and shop exports come as CSV with semicolons, empty lines and double rows. Clean the lines, then get an Excel file with real numbers.
The steps
- Take out the empty lines. Blank rows between the entries go. Remove empty lines
- Take out double rows. Each entry stays once. Remove duplicate lines
- Turn it into Excel. Semicolons and decimal commas are understood. Save the Excel file. CSV to Excel
An Excel file with one row per entry.