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.

Compétences : Big Data, Traitement de Données, Administration de Bases de données, Programmation de bases de données, Excel

Voir plus : 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

Concernant l'employeur :
( 59 commentaires ) La Plata, Argentina

N° du projet : #8522347

Décerné à :


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

20 $ USD en 1 jour
(54 Commentaires)

55 freelance font une offre moyenne de $29 pour ce travail


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? Plus

34 $ USD en 1 jour
(46 Commentaires)

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 Plus

35 $ USD en 1 jour
(81 Commentaires)

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 en 0 jours
(59 Commentaires)

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 Plus

35 $ USD en 0 jours
(114 Commentaires)

"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 en 0 jours
(44 Commentaires)

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 en 0 jours
(83 Commentaires)

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 en 0 jours
(63 Commentaires)

A proposal has not yet been provided

35 $ USD en 0 jours
(77 Commentaires)

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 Plus

27 $ USD en 1 jour
(92 Commentaires)

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 en 0 jours
(56 Commentaires)

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 Plus

25 $ USD en 0 jours
(35 Commentaires)

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

30 $ USD en 1 jour
(39 Commentaires)

"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. Plus

35 $ USD en 1 jour
(2 Commentaires)

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 Plus

35 $ USD en 1 jour
(20 Commentaires)

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 Plus

35 $ USD en 0 jours
(4 Commentaires)

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 Plus

40 $ USD en 1 jour
(7 Commentaires)

"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 Plus

29 $ USD en 2 jours
(25 Commentaires)

"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 Plus

35 $ USD en 1 jour
(14 Commentaires)

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 Plus

35 $ USD en 1 jour
(1 Commentaire)

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 en 1 jour
(6 Commentaires)