Find Jobs
Hire Freelancers

Clean up data and format in Excel

$30-250 USD

Em Andamento
Publicado há aproximadamente 12 anos

$30-250 USD

Pago na entrega
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).
ID do Projeto: 1497808

Sobre o projeto

14 propostas
Projeto remoto
Ativo há 12 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
Hi, Please check PMB for details. Thanks,
$100 USD em 3 dias
5,0 (7 avaliações)
4,6
4,6
Avatar do Usuário
Dear Sir, I'm very much familiar with MS SQL Server ( SSIS SSAS SSRS) and also during last three years I involved many project in ETL, data warehousing, BI reporting and five years of application development experience. I would highly appreciate if you assign this job to me and also I'm Microsoft Certified Technology Specialist (MCTS) for Microsoft SQL Server 2008 for Business Intelligence Development and Maintenance & Microsoft Office SharePoint Server Application Development. Please reply me for farther details Thanks, Jinesh
$30 USD em 1 dia
5,0 (3 avaliações)
3,3
3,3
14 freelancers estão ofertando em média $83 USD for esse trabalho
Avatar do Usuário
Looking forward to working with you...
$45 USD em 0 dia
5,0 (74 avaliações)
5,9
5,9
Avatar do Usuário
I can automatically do the transfer with a macro.
$30 USD em 2 dias
4,8 (30 avaliações)
4,4
4,4
Avatar do Usuário
Reay to start now
$30 USD em 0 dia
5,0 (13 avaliações)
3,9
3,9
Avatar do Usuário
Excel & VBA Experts are ready to start now.
$50 USD em 4 dias
4,5 (5 avaliações)
3,9
3,9
Avatar do Usuário
Dear concern i am expert on excel and also data entry
$40 USD em 7 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I can do this. Please see PMB.
$80 USD em 4 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I wish to help you in this work. Please hire me for this project. I will work as hard as i can to get your work done. Thank You
$190 USD em 2 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hello! I am the best bidder for this job! My attention to detail is impeccable, my work is fast and thorough, and I always exceed expectations. If you award me this project I can promise you will want to develop a long-term relationship as I am friendly, motivated, and never miss a deadline. My bid is higher than most due to my 15+ years of experience. I do believe you get what you pay for :-)I am willing to negotiate my price and milestone if you are serious about using me as your go-to girl.
$225 USD em 5 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
hi i can do this
$80 USD em 10 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hello, i will complete project only a day
$30 USD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hi, I would like to be part of this project. I have a prior experience of migrating data from excel to SQL. Thanks.
$200 USD em 5 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) PAKISTAN
hyderabad, Pakistan
0,0
0
Membro desde mar. 9, 2012

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.