Skip to content
Back to Sakalis Digital
Demo · made-up data · runs in your browser

Report job: messy CSV in, clean Excel out

Morvik Wholesale is a made-up wholesaler for cafés. Its shop system exports orders as a CSV file that nobody can use as it is. The job below cleans it and writes the Excel report.

Everything runs in this browser tab. Nothing is uploaded or stored.

1The export

morvik-orders-export.csv 63 lines · 3.6 KB
  1. 1 Order ID ; Date ; Customer ; Product ; Qty ; Unit price
  2. 2 MW-10231;2026-07-17;Green Fork Bistro;Oat milk 1 L;8;1,85
  3. 3 MW-10232;19.07.2026;Green Fork Bistro;Paper cups 12 oz (50);20;€ 4.20
  4. 4 MW-10233;3/7/2026; Cafe Lumo;Cane sugar sticks (500);4;9.80
  5. 5 MW-10234;28 Jul 2026;Cafe Lumo;coffee beans 1 kg;5;18,90
  6. 6 MW-10235;2026-07-03;Green Fork Bistro;Cocoa powder 500 g ;24;7.50
  7. 7 MW-10236;21.07.2026;Northside Bakery;Coffee beans 1 kg;10;18.90
  8. 8 MW-10236;21.07.2026;Northside Bakery;Coffee beans 1 kg;10;18.90
  9. 9 MW-10237;6/7/2026;Green Fork Bistro;Cane sugar sticks (500);2;9,80
  10. 10 MW-10238;5 Jul 2026;Kiosk 21;Coffee beans 1 kg;12;18.90
  11. 11 MW-10239;2026-07-25; Kiosk 21;Cocoa powder 500 g;20;€ 7.50
  12. 12 MW-10240;02.07.2026;Kiosk 21;Green tea 100 g;3;6,40
  13. 13 MW-10241;11/7/2026;Harbour Deli;Oat milk 1 L;12;1.85
  14. 14 MW-10242;25 Jul 2026;Northside Bakery;paper cups 12 oz (50);4;4.20
  15. 15 MW-10243;2026-07-17;Green Fork Bistro;Green tea 100 g;4;6,40
  16. 16 MW-10244;17.07.2026;Northside Bakery;Green tea 100 g ;12;6.40
  17. 17 MW-10245;12/7/2026; Cafe Lumo;Paper cups 12 oz (50);4;4.20
  18. 18 MW-10246;17 Jul 2026;Harbour Deli;Paper cups 12 oz (50);6;4,20
  19. 19 MW-10247;2026-07-13;Harbour Deli;Coffee beans 1 kg;12;18.90
  20. 20 MW-10248;04.07.2026;Kiosk 21;CANE SUGAR STICKS (500);10;9.80
  21. 21
  22. 22 MW-10241;2026-07-11; Harbour Deli;Oat milk 1 L;12;1,85
  23. 23 MW-10249;27/8/2026;Harbour Deli;Oat milk 1 L;6;1,85
  24. 24 MW-10250;18 Aug 2026;Cafe Lumo;cocoa powder 500 g;4;7.50
  25. 25 MW-10251;2026-08-18; Kiosk 21;Coffee beans 1 kg;4;18.90
  26. 26 MW-10252;22.08.2026;Northside Bakery;Green tea 100 g;5;6,40
  27. 27 MW-10253;8/8/2026;Harbour Deli;Oat milk 1 L ;20;€ 1.85
  28. 28 MW-10254;17 Aug 2026;Kiosk 21;Coffee beans 1 kg;20;18.90
  29. 29 MW-10255;2026-08-13;Harbour Deli;Oat milk 1 L;20;1,85
  30. 30 MW-10256;07.08.2026;Harbour Deli;Green tea 100 g;12;6.40
  31. 31 MW-10257;1/8/2026; Green Fork Bistro;Green tea 100 g;3;6.40
  32. 32 MW-10258;8 Aug 2026;Green Fork Bistro;paper cups 12 oz (50);8;4,20
  33. 33 MW-10259;2026-08-21;Harbour Deli;Cane sugar sticks (500);4;9.80
  34. 34 MW-10260;14.08.2026;Northside Bakery;Green tea 100 g;12;€ 6.40
  35. 35 MW-10261;27/8/2026;Green Fork Bistro;Cocoa powder 500 g;8;7,50
  36. 36 MW-10262;11 Aug 2026;Northside Bakery;Paper cups 12 oz (50) ;20;4.20
  37. 37 MW-10263;2026-08-10; Green Fork Bistro;Cocoa powder 500 g;20;7.50
  38. 38 MW-10264;06.08.2026;Cafe Lumo;Oat milk 1 L;5;1,85
  39. 39 MW-10265;4/8/2026;Harbour Deli;Paper cups 12 oz (50);20;4.20
  40. 40 MW-10266;16 Aug 2026;Kiosk 21;oat milk 1 l;3;1.85
  41. 41 ;;;;;
  42. 42 MW-10267;2026-09-18;Harbour Deli;Cane sugar sticks (500);24;9,80
  43. 43 MW-10268;20.09.2026;Harbour Deli;Coffee beans 1 kg;20;18.90
  44. 44 MW-10269;9/9/2026; Green Fork Bistro;Cocoa powder 500 g;3;7.50
  45. 45 MW-10270;10 Sep 2026;Northside Bakery;Oat milk 1 L;10;1,85
  46. 46 MW-10271;2026-09-16;Green Fork Bistro;Cane sugar sticks (500) ;6;9.80
  47. 47 MW-10272;03.09.2026;Cafe Lumo;Paper cups 12 oz (50);10;4.20
  48. 48 MW-10273;18/9/2026;Cafe Lumo;Cocoa powder 500 g;8;7,50
  49. 49 MW-10274;26 Sep 2026;Green Fork Bistro;green tea 100 g;6;€ 6.40
  50. 50 MW-10275;2026-09-22; Harbour Deli;Coffee beans 1 kg;20;18.90
  51. 51 MW-10275;22.09.2026;Harbour Deli;Coffee beans 1 kg ;20;18,90
  52. 52 MW-10276;03.09.2026;Kiosk 21;Oat milk 1 L;2;1,85
  53. 53 MW-10277;22/9/2026;Northside Bakery;Paper cups 12 oz (50);2;4.20
  54. 54 MW-10278;23 Sep 2026;Harbour Deli;Green tea 100 g;3;6.40
  55. 55 MW-10279;2026-09-05;Harbour Deli;Paper cups 12 oz (50);8;4,20
  56. 56 MW-10280;19.09.2026;Cafe Lumo;Coffee beans 1 kg ;20;18.90
  57. 57 MW-10281;28/9/2026; Cafe Lumo;Coffee beans 1 kg;4;€ 18.90
  58. 58 MW-10282;20 Sep 2026;Cafe Lumo;green tea 100 g;10;6,40
  59. 59 MW-10283;31.09.2026;Kiosk 21;Oat milk 1 L;6;1,85
  60. 60 MW-10284;2026-09-29;Harbour Deli;Coffee beans 1 kg;;18,90
  61. 61 MW-10285;2026-09-30;Northside Bakery;Green tea 100 g;4
  62. 62 MW-10286;30 Sep 2026;Cafe Lumo;Cocoa powder 500 g;two;7,50
  63. 63 MW-10287;2026-09-30;Kiosk 21;Paper cups 12 oz (50);-4;4.20

  Stray spaces are marked.

2What the job does

Press the button. Each rule shows how many rows it touched.

  1. Read the file

  2. Skip empty lines

    Lines with no values at all.

  3. Trim stray spaces

    Spaces before, after and doubled inside a value.

  4. One date format: YYYY-MM-DD

    Reads 2026-07-03, 03.07.2026, 3/7/2026 and 3 Jul 2026. Day first when both could be the day.

  5. Numbers with comma or dot decimals

    1,85 and € 4.20 become plain numbers.

  6. Same spelling for the same name

    Upper and lower case differ: the most used spelling wins.

  7. Set aside broken rows

    Missing values, unreadable dates or numbers, wrong number of columns. Each with a reason.

  8. Remove duplicate rows

    Rows that are the same after cleaning. The first one stays.

  9. Add the amount: qty × unit price

    And the month of each row, for the summary.

In real use a job like this runs on a schedule, for example as a Python script: it picks up the export, applies the same rules, writes the Excel file and sends it out. Here the same rules run in your browser so you can watch them.

Morvik Wholesale, its customers and orders are made up. Demo by Sakalis Digital.