Clean up Excel spreadsheet customer data output from Quickboooks
- or -
Post a project like this1238
£12/hr(approx. $15/hr)
- Posted:
- Proposals: 17
- Remote
- #3072051
- Awarded
WordPress Expert✮Shopify Expert✮Graphic Designer✮AutoCAD 2D & 3D✮CV Writer & Designer✮Fullstack developer
Rawalpindi
Data Entry Operator, Word, Excel Expert | Fillable PDF Form | Edit PDF | Audio Editer
Colombo
25891703636573504159150333364984787488485448604874775883434915338734915715263407578
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% (219)Projects Completed
153
Freelancers worked with
136
Projects awarded
43%
Last project
19 Apr 2024
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