In Progress

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 [url removed, login to view] 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, 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:
( 59 reviews ) La Plata, Argentina

Project ID: #8522347

Awarded to:

rohitagarberg

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

$20 USD in 1 day
(54 Reviews)
4.4

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) [url removed, login to view] is for reference only? More

$34 USD in 1 day
(46 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
(81 Reviews)
5.9
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
(59 Reviews)
5.4
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
(114 Reviews)
5.5
faheems189

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

$35 USD in 0 days
(44 Reviews)
5.4
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
(83 Reviews)
5.5
gatsu58

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

$35 USD in 0 days
(63 Reviews)
5.0
deepabittu

A proposal has not yet been provided

$35 USD in 0 days
(77 Reviews)
5.5
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
(92 Reviews)
5.1
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
(56 Reviews)
5.1
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
(35 Reviews)
4.8
zebracaro

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

$30 USD in 1 day
(39 Reviews)
4.4
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
(2 Reviews)
4.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
(20 Reviews)
4.1
CristianRam

TXT to XLSX | I can comfortably complete all your tasks within 2 hours, but I need clarification on the final point about restaurant ID. It looks like output already has the fields "restaurant number" and "restaurant More

$35 USD in 0 days
(4 Reviews)
3.4
wissamSabry

I am an advanced user with over 10 years of MS Office experience. As A Microsoft Certified System Administrator I am Excellent in word editing, processing , spread sheets I can very quickly help you with any Microsoft More

$40 USD in 1 day
(7 Reviews)
3.5
sayli2

"TXT to XLSX" ------------------------ I AM HUMAN :) ---------------------------- I am programmer/developer. Expert in Excel/Macro. I will write program for you in C# that convert your text file into excel. Maximu More

$29 USD in 2 days
(25 Reviews)
3.6
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
(14 Reviews)
3.5
SashaPinsk

TXT to XLSX Dear customer, I am a .net developer with 2+ production experience. I will complete this task in 2 hours. Happy to inform you that almost whole last week I have dealt with programming excel with O More

$35 USD in 1 day
(1 Review)
3.2
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
(6 Reviews)
3.2