
Clean up Excel spreadsheet customer data output from Quickboooks
- or -
Post a project like this1862
£12/hr(approx. $16/hr)
- Posted:
- Proposals: 17
- Remote
- #3072051
- Awarded
WordPress Expert✮Shopify Expert✮Graphic Designer✮AutoCAD 2D & 3D✮CV Writer & Designer✮Fullstack developer

Trusted CRM Consultant and Data Automation Expert. Automating your business, designing your future!

Helping ambitious, self-motivated business owners achieve time and cost savings by automating spreadsheets to allow for pro-active data-led decision making.
Data Entry Operator, Word, Excel Expert | Fillable PDF Form | Edit PDF | Audio Editer

25891703636573498478723854364349153264240648604871641649571526247445650333363873491
Description
Experience Level: Entry
Hello, I have a database of customers which has been exported from Quickbooks.
The data needs work to clean it up as data such as mobile phone numbers, customer postcodes or customer vehicle registration plates have been put into different rows.
This task requires someone with excellent Excel skills and a decent amount of common sense.
The main tasks I'd like you to carry out are:
1. Look for number plates and post codes and move them into separate columns. The data looks similar but all postcodes end with 1 number followed by two letters where as most vehicle regitrations end with three letters
2. Look for all mobile phone numbers and move them into a new column. In our spreadsheet, mobiles start with 07 or +447 or just 7 and can be differentiated from land lines which are usually 01 or 02
3. Highlight where there is duplicate data.
Please mention apples when applying for this job so I know that you have read it properly.
I don't expect the spreadsheet to be perfect at the end of this job but I am looking for the key data points to be tidied up, making the spreadsheet easer to manage. There are around 14,000 rows of data. I have put in a basic per hour figure but please send me your quote. I also have a sample data set which I can send to you.
Many thanks.
The data needs work to clean it up as data such as mobile phone numbers, customer postcodes or customer vehicle registration plates have been put into different rows.
This task requires someone with excellent Excel skills and a decent amount of common sense.
The main tasks I'd like you to carry out are:
1. Look for number plates and post codes and move them into separate columns. The data looks similar but all postcodes end with 1 number followed by two letters where as most vehicle regitrations end with three letters
2. Look for all mobile phone numbers and move them into a new column. In our spreadsheet, mobiles start with 07 or +447 or just 7 and can be differentiated from land lines which are usually 01 or 02
3. Highlight where there is duplicate data.
Please mention apples when applying for this job so I know that you have read it properly.
I don't expect the spreadsheet to be perfect at the end of this job but I am looking for the key data points to be tidied up, making the spreadsheet easer to manage. There are around 14,000 rows of data. I have put in a basic per hour figure but please send me your quote. I also have a sample data set which I can send to you.
Many thanks.
Ben C.
100% (221)Projects Completed
155
Freelancers worked with
138
Projects awarded
43%
Last project
21 May 2025
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies