Clean brand list
Budget: $10 – $30 CAD
The attached 'brandslist.csv' file contains a list of 21,925 brand names including many duplicates with minor typos and spelling variations.
Using chat GPT, run the command below on all 21,925 brands in the list using the following command example:
Suggest which brands in the list below might be matches based on minor spelling variation. Put the matching names in a spreadsheet with each possible match in a separate column:
2M COSMETICS
2mcosmetics
2nd Look Day Spa
2percentjazz
2Posh2Pull
2tech ltd
2UDirect.co.uk
2UNDR
2Wild
3 Apples Bakery
3 Monkeys
3 P Naturals
3 Pieces/Pack
3 Sprout
3 Sprouts
3-D Belt Company
3's Company Boutique
3's Company Clothing Boutique
306 Fitness Repair & Sales
306 Sports Card
306 Sports Cards
321 GLO
34 Heritage
34 HERITAGE
340 g / 1 kg
34HERITAGE
360 Athletics
360 ATHLETICS
360 Bikes 'n Boards
360 Cashmere
360 Conditioning
360 Skull Cashmere
360 SKULL CASHMERE
360STERILE
3A Game
3acres
3acres-test
3AM
3B Scientific
3C Easy Markham
3D Build Lab
3D Car Care
3D Dental
3D Energy
3D Light FX
3D Printernational
3D PrinterNational
3D Printing Canada
3D Printz Ltd
3d Wall Panel company
3DBUYER
3DHUB
3DHUB CANADA
3DimensionGames
3DreamDesigns
3DXTech
3DXTECH
3Eagles Trading Co.
3FiveDesign
3M
3M Filtrete
3M-ESPE
3Meals
Chat GPT will generate a spreadsheet for each batch of brands. Copy paste the command output information from GPT into excel and provide 1 final master list in csv format. See 'sample-output.csv' attached.
The final output file should include all 21,925 brands with possible matches in one csv file.
**NOTE: Chat GPT will work if you run a small batch of brands at a time but will crash if you try to run all 21,000 brands at once.
Using chat GPT, run the command below on all 21,925 brands in the list using the following command example:
Suggest which brands in the list below might be matches based on minor spelling variation. Put the matching names in a spreadsheet with each possible match in a separate column:
2M COSMETICS
2mcosmetics
2nd Look Day Spa
2percentjazz
2Posh2Pull
2tech ltd
2UDirect.co.uk
2UNDR
2Wild
3 Apples Bakery
3 Monkeys
3 P Naturals
3 Pieces/Pack
3 Sprout
3 Sprouts
3-D Belt Company
3's Company Boutique
3's Company Clothing Boutique
306 Fitness Repair & Sales
306 Sports Card
306 Sports Cards
321 GLO
34 Heritage
34 HERITAGE
340 g / 1 kg
34HERITAGE
360 Athletics
360 ATHLETICS
360 Bikes 'n Boards
360 Cashmere
360 Conditioning
360 Skull Cashmere
360 SKULL CASHMERE
360STERILE
3A Game
3acres
3acres-test
3AM
3B Scientific
3C Easy Markham
3D Build Lab
3D Car Care
3D Dental
3D Energy
3D Light FX
3D Printernational
3D PrinterNational
3D Printing Canada
3D Printz Ltd
3d Wall Panel company
3DBUYER
3DHUB
3DHUB CANADA
3DimensionGames
3DreamDesigns
3DXTech
3DXTECH
3Eagles Trading Co.
3FiveDesign
3M
3M Filtrete
3M-ESPE
3Meals
Chat GPT will generate a spreadsheet for each batch of brands. Copy paste the command output information from GPT into excel and provide 1 final master list in csv format. See 'sample-output.csv' attached.
The final output file should include all 21,925 brands with possible matches in one csv file.
**NOTE: Chat GPT will work if you run a small batch of brands at a time but will crash if you try to run all 21,000 brands at once.