Cogwheel & Crank customers

customers.csv cleaned by CleanSheet · 2 blank rows skipped

194rows in
186rows out
1078values changed
8duplicates removed
5values to check

Check before you use it

Columns

ColumnRead asFilledChangedTo checkSpellingsExamples
Customer IDid100%00194
First namename100%37073 → 48ollie → Ollie
ISLA → Isla
SAM → Sam
Last namename100%27050 → 30novak → Novak
ASHBY → Ashby
MCALLISTER → McAllister
Emailemail100%331194 → 186 bea.brennan@gmail.com → bea.brennan@gmail.com
rhys.evans@proton.me → rhys.evans@proton.me
lena.patel@btinternet.com → lena.patel@btinternet.com
Phonephone93%164217507912 295217 → +447912295217
+44 7705 983348 → +447705983348
(07576) 935 737 → +447576935737
Signup datedate day-first100%1591185 → 17828/9/2024 → 2024-09-28
02/01/2021 → 2021-01-02
3/1/2023 → 2023-01-03
Last purchasedate day-first81%179012117/08/2026 → 2026-08-17
01/08/2026 → 2026-08-01
04/05/2026 → 2026-05-04
Total spentnumber100%1321186£3,698.87 → 3698.87
761.38 GBP → 761.38
£868.21 → 868.21
Newsletterboolean87%16107 → 2yes → true
Y → true
N → false
Citycategory100%3508 → 5bristol → Bristol
bristol → Bristol
BRISTOL → Bristol
Countrycategory100%8906 → 2IE → Ireland
IE → Ireland
england → United Kingdom
Bike typecategory96%62013 → 6E-Bike → E-bike
E-Bike → E-bike
gravel → Gravel
Shop notes from Notestext5%002

Values to check (5)

LineColumnValueWhy
14Signup date31/02/2024not a date
32Emailollie.hart@gmailnot an email address
32Phoneask in shopnot a phone number
50Total spentTBCnot a number
130Phoneask in shopnot a phone number

Duplicates removed (8)

LineKept lineMatched on
1257Amara · Ferreira · amara.ferreira@yahoo.co.uk
5824Owen · Fenwick · owen.fenwick@icloud.com
10842Dev · Petrov · dev.petrov@outlook.com
15273Hana · Mackay · hana.mackay@yahoo.co.uk
14793Yusuf · Novak · yusuf.novak@icloud.com
194136Malik · Ashby · malik.ashby@proton.me
173154Maya · Marsh · maya.marsh@proton.me
178175Idris · Lindqvist · idris.lindqvist@icloud.com

First 15 cleaned rows

Customer IDFirst nameLast nameEmailPhoneSignup dateLast purchaseTotal spentNewsletterCityCountryBike typeShop notes
CC-1001DaraThornedara.thorne@icloud.com+4479122952172024-09-282026-08-173893.47trueKeynshamIrelandE-bike
CC-1002OwenIyerowen.iyer@outlook.com+4477059833482021-01-022026-08-013698.87trueBristolIrelandCargo
CC-1003FinnAshbyfinn.ashby@yahoo.co.uk+4471179884682023-01-032026-05-04761.38BristolUnited KingdomE-bike
CC-1004OlliePetrovollie.petrov@yahoo.co.uk+4475769357372021-07-252026-02-2369.75falseBristolUnited KingdomGravel
CC-1005NoahOkafornoah.okafor@yahoo.co.uk+4472021441532025-05-012026-10-28868.21trueBristolUnited KingdomE-bike
CC-1006AmaraFerreiraamara.ferreira@yahoo.co.uk+4474183394772025-08-271992.38trueKeynshamIrelandE-bike
CC-1007BeaBrennanbea.brennan@gmail.com+4476322839552023-04-242026-10-273596.50falseBristolIrelandRoad
CC-1008BenMarshben.marsh@yahoo.co.uk+4475614470412021-03-102026-02-055934.27BristolUnited KingdomGravel
CC-1009ChloeOkaforchloe.okafor@icloud.com+4478548729572023-06-052026-06-1856.27trueBristolUnited KingdomHybrid
CC-1010BenThorneben.thorne@btinternet.com+4473635364652024-07-192026-11-032355.35trueBathUnited KingdomE-bike
CC-1011TomásFerreiratomas.ferreira@gmail.com+4474764156552021-08-25745.66BathUnited KingdomGravel
CC-1012QuinnWhitfieldquinn.whitfield@proton.me+4476084677822022-04-13389.26trueBristolIrelandHybrid
CC-1013ZoëIyerzoe.iyer@icloud.com+44782539472331/02/20242026-10-284020.19trueBristolUnited KingdomGravel
CC-1014OllieNovakollie.novak@gmail.com+4479435982222021-11-182026-11-033561.00trueBristolUnited KingdomMountain
CC-1015IdrisFenwickidris.fenwick@icloud.com+4477401070532022-02-142026-08-051735.88trueKeynshamUnited KingdomHybrid