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

  1. Take out the empty lines. Blank rows between the entries go. Remove empty lines
  2. Take out double rows. Each entry stays once. Remove duplicate lines
  3. 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.