Completed

Convert One Text File to Many Excel Files

Hi people, how is it going all?

Start your BID writing: "TXT to XLSX" to know you are not a bot. I'll filter bids reading this.

I need a fast turnaround this time.

I'll hire someone who has the right skills (and experience) for next tasks:

- Convert one Text File to Excel format (the Excel files need to have at the most, 200K rows (200.000 rows) each one.

- For example, if the Text File has 1.345.000 lines, I will expect 7 Excel files with 200k each one, except the last one which will have 145.000 rows.

- Check the file "[url removed, login to view]" to see how the Text File will be presented. This attached file is just a sample with few lines inside. The right candidate will receive the complete file then.

- You can get the Excel attached here, called "[url removed, login to view]" to know how should be presented each Excel file. The Text File has fields separated by "|" (pipe).

- Please, trim all empty spaces to the left (start of the string) and to the right (end of the string) of each field before to generate the excel files.

- Finally, get the file attached here, called "[url removed, login to view]" and do a simple join using first column ID and update the corresponding column in the Excel files (you should do this before to convert it to Excel, guess is better for you). Ask me for this point to be sure you can do it.

I will expect this task completed today, in no more than 2 hours of time (if you know what you are doing). It is simple task, just many data to manipulate.

** My MAX Budget is $ 35. **

Thanks, and good luck for everyone.

Skills: Big Data Sales, Data Processing, Database Administration, Database Programming, Excel

See more: writing task one, text to string, how to hire the right people, hire someone to do excel, file expect, expect file, convert word table excel files, large excel files access file, convert audio files mp3 file, convert excel files stand alone program, convert photoshop files html file, excel file program text file, convert pdf files fillable file, Convert Excel files, convert excel files vb6, convert dat files excel files

About the Employer:
( 62 reviews ) La Plata, Argentina

Project ID: #8522347

Awarded to:

rohitagarberg

placed the bid. thanks...............................................................................................................

$20 USD in 1 day
(244 Reviews)
6.0

55 freelancers are bidding on average $29 for this job

Beacon09

Hi I have read the description carefully. 1) I would like to know how 1.345.000 lines will result in 7 excel files if each has 200K rows? Isn't the calculation wrong? 2) [login to view URL] is for reference only? More

$34 USD in 1 day
(71 Reviews)
6.6
deepabittu

A proposal has not yet been provided

$35 USD in 0 days
(206 Reviews)
6.4
dpune

TXT to XLSX Hi, Do you need a program to do multiple time or is it only one time task ? I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 250 proj More

$35 USD in 1 day
(132 Reviews)
6.3
MohsanEijaz

TXT to XLSX I think I am a good fit for this job because I have all the qualities that you are looking for. Experience is the golden factor in this project where you find in me at least 3+ years of working experienc More

$18 USD in 1 day
(63 Reviews)
5.9
zebracaro

i can do it for you quickly and exactly. Please contact me!!!

$30 USD in 1 day
(84 Reviews)
6.1
Attractionnet

TXT to XLSX Hello. I have created many programs like this one. I will create a small application in vb.net which will import,split and export the files the proper way. I can start asap. You can reach me via ch More

$35 USD in 1 day
(98 Reviews)
5.9
fatimatuzzohura

"TXT to XLSX" Hi, I have read the project and understand your requirement. I definitely have some questions when we discuss project with you I am very much interested and have experience to do manual/ automated i More

$35 USD in 1 day
(116 Reviews)
6.0
gokulanand

TXT to XLSX Hello, I can get you the task done in the next 2 hours using a macro. Let me know if you are interested. Thanks

$25 USD in 0 days
(101 Reviews)
6.0
gangabass

TXT to XLSX I need less than a hour to create the program you want. All I need to know is what OS you will run it. I can create Windows, Mac or Linux executable. Thanks. Roman

$30 USD in 0 days
(137 Reviews)
6.1
RRajeshR

"TXT to XLSX" Hi, I can complete your task as per your requirement. I would like to have a clarification on the requirement: 1. The sample text file provided has 8 field, but the structure needed has only 7. More

$35 USD in 1 day
(39 Reviews)
6.0
expertatwork

TXT to XLSX... Hey there...we carefully studies both text and excel files and we understood how data is mappped and extracted...we can do this with 100% accuracy...please reply..we can discuss further..hopefully, we ca More

$35 USD in 0 days
(153 Reviews)
5.9
gatsu58

TXT to XLSX Hello, I can complete the project within 2 hours I have a question: The [login to view URL] have 8 column, and the [login to view URL] have 7 column. Regards, Jay

$35 USD in 0 days
(101 Reviews)
5.5
catstevens2009

TXT to XLSX ================ Hi there! Have done this type of work before, and am an Excel expert doing quick, quality and accurate Excel work! Please feel free to message me with additional information or with que More

$25 USD in 0 days
(84 Reviews)
5.7
faheems189

"TXT to XLSX" Hello sir, i can complete this work in next 2 hours [login to view URL] pm me, i have saample ready for attached "[login to view URL] " Thanks.

$35 USD in 0 days
(86 Reviews)
6.0
dviruki

Jorge, hi! I looked through the files and it's something I can do quite fast. I'm available at the moment, so please let me know if you still need help with this project. Regards, Roman

$24 USD in 0 days
(65 Reviews)
5.4
adityasl

TXT to XLSX Hello, I am interested in the project. I have converted the sample text file in excel. I will like to show before confirming. I have Excel 2003 which supports 65k rows only. What is the size of More

$27 USD in 1 day
(121 Reviews)
5.3
mdkass

A proposal has not yet been provided

$34 USD in 1 day
(13 Reviews)
4.7
serdaryalcin

TXT TO XLSX Hi I have completed some projects like the one mentioned. Millions of records were read and arranged more or less as you required. Will you share the file and ask for the result XLSX files, or do More

$25 USD in 1 day
(21 Reviews)
4.5
slenders13

TXT to XLSX Dear client, I have a lot of experience with VBA and Excel. Send me a message for more information. Looking forward to work with u. Kind regards, Rens Slenders SlenDATA

$35 USD in 1 day
(16 Reviews)
4.5
Rakibhasannur

A proposal has not yet been provided

$55 USD in 1 day
(24 Reviews)
4.1