Clean up data and format in Excel

Closed

This is a data cleansing project in Excel.

The task is to transfer data from one Excel spreadsheet to another. The first spreadsheet contains tables from an old MS Access database, one worksheet is one table in MS Access. The second spreadsheet contains templates for the new SQL Server database, one worksheet is one table in the SQL Server.

You need to transfer data from the Source Spreadsheet (SS) to the Destination Spreadsheet (DS), column by column. This process cannot be fully automated, because the data in the SS must be cleaned before being transferred to the DS. Therefore, the data should be transfer column by column, with clean up and check up.

The SS workbook has about 30 worksheets, the DS workbook has about 8 worksheets.

The SS workbook contains worksheets of Customers, Stock Items, Purchases etc. There are about 300 customers, 500 Items and 500 Purchase Invoices. The total size of SS in Excel is about 1 MB.

It took me about 20 work hours to do the first such transfer myself.

This project is for one transfer from SS to DS, but we have about 40 identical projects. If your performance on the first project is good, then you may be invited to continue this work over the next two months.

If you are short-listed on this project, you will receive the SS and DS without data but with a count of records in each, to get a better idea of the amount of work and to adjust your bid accordingly.

This is a basic level work, which requires no special Excel skills, but it requires from you to be persistent and very, very tidy. The criterion of your achievement is how easily and quickly your DS can be imported into SQL Server. If SQL Server rejects your DS and I have to do many corrections, then you have not done your job well.

Please supply any references for similar work done before (person name and email/phone).

Skills: Data Entry, Excel

See more: data clean project, will format your, source format, ms project it templates, how to get the data entry projects, how to get a data entry job easily, how to get a better job, how many references should i have, excel special, data entry worksheet, data entry in ms access , database entry job level, automated data entry, spreadsheet contains tables access database, clean data format, excel clean, job invoices, how to count work hours, how to count hours, email clean up, ms access job, how do i get a data entry job, name format, MS Excel projects, in process access

Project ID: #1427587

32 freelancers are bidding on average $97 for this job

SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

$225 USD in 5 days
(23 Reviews)
5.7
wikkipk

Ready to do it.

$199 USD in 5 days
(25 Reviews)
4.4
kulhanekd

I can do this project for you. Thanks Donna

$150 USD in 5 days
(12 Reviews)
4.4
habayabah

Please read my PM for details of my bid.

$30 USD in 1 day
(3 Reviews)
3.1
khanshabb

Hi can do it and ready to start

$100 USD in 5 days
(2 Reviews)
3.2
thiyagus25

Greetings! Thank you very much for giving us an opportunity to bid for your project. Will finish till this bid ends, Please see PMB

$30 USD in 10 days
(6 Reviews)
2.2
deeplyshrouded

Hello, I would need to see a sample of your data. I do not understand why you cannot automate this process. As a programmer, data is made to be manipulated.

$250 USD in 3 days
(1 Review)
1.3
kieron90

Hi there, I am new to the site, I am very efficient at the microsoft office package, including access, excel and word. I have prior data entry and spreadsheet experience, would love to get some projects under my belt a More

$40 USD in 5 days
(1 Review)
1.0
Aarvi

Ready to work on this project.

$200 USD in 10 days
(0 Reviews)
0.0
dljubica

I m interested about it,please tell me about it. Hvala, Ljubica

$80 USD in 5 days
(0 Reviews)
0.0
shreeyajoshi25

Hi.. This is shreeya,good at editing work... gimme the project,i 'm sure i wont let u down..

$100 USD in 5 days
(0 Reviews)
0.0
rochish

9 years of working experience in MS excel

$30 USD in 1 day
(0 Reviews)
0.0
sunilgun

Hi Sir I have experienced in data clean up and formating for SAP implementation. Working as an accountant in a reputed industrial Company.Hope I'll be able to do this 100% acurancy and ontime completion.

$100 USD in 5 days
(0 Reviews)
0.0
latanasov

I`m new but ready to finish the job

$30 USD in 2 days
(0 Reviews)
0.0
perlalouna

I'm programmeur I can do this job

$30 USD in 15 days
(0 Reviews)
0.0
samavacorp

Hello my name is Maneesh Varma and I am the CEO of STP Research. Although we are new to this website we are highly experienced in Excel anddta entry. I can offer you all of our services in business solutions with great More

$128 USD in 4 days
(0 Reviews)
0.0
aviket

I can do the work. I can create some formulas or VBA code to partially automate the work. Thanks

$100 USD in 10 days
(0 Reviews)
0.0
geomustafa

AOA, HRU BROTHER, I WOULD LIKE TO JOIN YOU AND COMPLETE THE SAID PROJECT, PLEASE BE ASSURE IT IS EASY FOR ME TO DO WORK WITH IN THE MENTIONED PERIOD. TAKE CARE GHULAM

$70 USD in 10 days
(0 Reviews)
0.0
ashokcr1985

Hi, I have 3 years and 10 months of experience in IT. I have managed to maintain intricate Excel sheets and write very advanced SQL queries. If given a chance in this project, i would use the funds for my higher More

$120 USD in 3 days
(0 Reviews)
0.0
gearner

Ready to work.

$200 USD in 5 days
(0 Reviews)
0.0