In Progress

Software or Data processor- Excel to txt (TAB delimited)

Hi all bidders,

I am looking for a data processing team able to transform rough data in the form of excel to a TAB delimited .txt format files. They will be for different websites therefore each file will have some things that will vary from one file to another. A sample of a rough format excel file and a finished txt file is provided with this project for your consultation.

From the rough format some values will be ignored completely.

Examples of expected:

If you look at row 4 and 5 in the excel sheet, all information is the same except for the phone number, in that case only the phone number will be used in row 5 as you see on line 40 of the txt file.

If you look at row 38 and 39 from the excel file, the company name is the same but addresses are different. In this case the outcome is different as you can see on line 430 to 454 in the txt file.

The example used is for the website [url removed, login to view]

Please analyse the two files and understand the transition required, I will answer any question you might need answered. Some excel files have as much as 3000 rows in which case every 90 rows will have a different ending as follows: 1st 90 will have an SF ending ".beauty-salons-in-london.tel" further refered as domain name as each file will have a different one. The 91st row to 180 will have an ending of ".pg2.domainname" in this example ".pg1.beauty-salons-in-london.tel". the following 90 i.e. 181 to 270th row will have ending ".pg3.domainname" in this example ".pg3.beauty-salons-in-london.tel"

If for example the 90th and 91st row is the same company the ending will only change with the next company. Notice that the SF value before the ending has no . , " or ' nor does it have double -

There will be 20 such excel files for you to do for now. If everything is done perfectly there will be much more to come.

If someone can make a software for this it would be the best but data processing will be fine as well.

The excel file can also be provided in Access.

Skills: Data Entry, Data Processing, Editing, Excel

See more: websites make software, best data entry company, software websites, london data entry, need data entry london, file processor, double data entry excel, double data entry, data processing company, data entry processor, company software, best software make website, answer tab, best case software, line processing, data processing website, best data entry websites, txt, tab 4, sf, line sheet, format excel, excel to, do excel, data 3000

About the Employer:
( 3 reviews ) Prague 2, Czech Republic

Project ID: #602951

Awarded to:

zszabo

Hi, Please see PM. Zoltan

$40 USD in 2 days
(3 Reviews)
2.2

26 freelancers are bidding on average $74 for this job

FINGERRPRINT

Thank you for this opportunity. Please check PM.

$100 USD in 3 days
(123 Reviews)
7.1
BDspeed

**PLS CHECK PMB**

$150 USD in 10 days
(236 Reviews)
6.5
spawar

Hi, I am ready to start work on this project, will make vb program to create the xls file, interested to work with you long term, using high speed internet connection, I have reviewed your text and xls file and I am More

$50 USD in 5 days
(49 Reviews)
5.9
best4best

Please refer PMB.

$50 USD in 3 days
(102 Reviews)
5.6
nagybatonyi

Such jobs are my daily practice; please see PMB for details! Regards!

$50 USD in 1 day
(39 Reviews)
5.4
agihcam

Please check PMB for the DEMO file.

$100 USD in 1 day
(42 Reviews)
5.2
UmarMahmood

Hi, I was able to spot the discrepancies in your Text file 7 hours ago when I first looked at the description and sample files. Now your clarifications have confirmed that observation as well. I wrote the macro spe More

$45 USD in 0 days
(38 Reviews)
4.6
theMagicNumber

Dear sir/madam please refer to your PMB. Thank You.

$55 USD in 1 day
(5 Reviews)
4.5
Wonderer

Hi, Will be done. Thanks, Al

$80 USD in 1 day
(18 Reviews)
4.4
FlashBack

please view the PMB

$150 USD in 7 days
(13 Reviews)
3.9
cdumitru

Hello, I would like to be the one completing your project. Here is my bid. Thank you, Best regards CD

$55 USD in 1 day
(5 Reviews)
3.2
jainv2007

Hi Pls check PM, Regards, Jain

$75 USD in 2 days
(2 Reviews)
2.8
raidontech

We have 50 seater capacity and looking for a job. I am unable to download the FINAL file here, kindly send us for the reference. Thanks

$100 USD in 1 day
(2 Reviews)
1.0
dataspecialists

Yes I got this perfectly every terms. This bid is for 20 files assuming 3000 rows there. We are trusted concerning these work. My team consists of minimum 20 members. Any kind of conversion work we can do for a long te More

$150 USD in 20 days
(0 Reviews)
0.0
ashisha95

please sir give me a work

$50 USD in 30 days
(0 Reviews)
0.0
lougr464

I am very proficient in not only Data Entry but also in Excel and Word. I would be happy to provide you the services that you need and do it in a timely manner.

$40 USD in 10 days
(0 Reviews)
0.0
Amogola

being a computer expart i think i can handle the work better

$150 USD in 2 days
(0 Reviews)
0.0
avinash011

Trust me, your project is in safe hands.

$50 USD in 30 days
(0 Reviews)
0.0
gmherath

I can design a software for this. I 'm doing this as a part time. that is y it takes 20 days. I can give the software within 20 days

$80 USD in 20 days
(0 Reviews)
0.0
jnooruddin

I need 3 days to finish the project and I want only $30 for that.

$30 USD in 3 days
(0 Reviews)
0.0