I need an excel expert for formatting a txt file in ecxel

€8-30 EUR

Đã hoàn thành

Đã đăng vào

gần 4 năm trước

€8-30 EUR

Thanh toán khi bàn giao

For a research project I need to transform the txt data export of the results of a scientific search engine in to the correct excel format. The metadata of a scientific contribution is represented block-wise in the txt file - there the title is represented with a T in the beginning, authors with an A, journal types with aB, publication date with a D and the abstract with a X (all others fields are not relevant). As every publication has a different number of authors or some fields are not filled out, every "block" has a different length which makes it quite hard for me to automate the transposition. In the end I want the data to look like in the provided screenshot showing the title, authors, journal type, year and abstract row-wise. (screenshot shows the desired solution for the first "block" of the txt file) I have 4 of those txt files with overall about 700 of those publications which I want in two excel sheets.

Excel

Visual Basic

Microsoft Office

Mã dự án: 26565434

Về dự án

24 đề xuất

Dự án từ xa

Hoạt động 4 năm trước

Bạn muốn kiếm tiền?

Địa chỉ email

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian

Nhận thanh toán cho công việc

Phác thảo đề xuất của bạn

Miễn phí đăng ký và cháo giá cho công việc

Đã trao cho:

@dreamvisualizer7

Hello, This is what I do in my everyday research life. Working with XLSX,XLS and CSV files, formatting for specific purposes is a regular job for me. I can do it well for you. ~Cheers Krishna

€10 EUR trong 1 ngày

5,0

(1 nhận xét)

0,5

24 freelancer chào giá trung bình €20 EUR cho công việc này

@daniyal3214

I can perfectly help you with that. I am an advance level Excel user holding years of experience. I will be happy to discuss in detail.

€30 EUR trong 1 ngày

4,8

(114 nhận xét)

6,7

@imtyzooel71n

Hello Dear, Can we discuss more? I can formatting a txt file in excel with 100% accuracy right now. If you need any sample please let me know. I am expert and have great working experience in Lead Generation, Web Search, Web Scraping, Virtual Assistant, Product upload in ecommerce site, Excel, PDF to word/excel conversion, Data processing, Data Entry, etc. I have 10+ experience in this area. Please send me a message to discuss more. Thank you Imtiaz

€8 EUR trong 1 ngày

4,9

(80 nhận xét)

6,0

@MartinDudumi

Hi there, I'd like to be considered for your request. I’m a data guy with a strong background developing several excel tools including vba automation and complex formulas and functions applied in excel and I can assure quality and accuracy in a short time based on your request. For more than 10 years i've worked on different sets of files having to deal with a lot of complex projects. I have a deep passion to finish in time every project that i am involved in. You can see my profile for better understanding what i was involved with. I highly evaluate professionalism and hold my self strictly accountable to fulfill my client need. I aim to form a great working relationship. Thank you for your consideration. Martin

€25 EUR trong 1 ngày

5,0

(41 nhận xét)

5,2

@bktk

Sir YOUR SATISFACTION IS MY PRIORITY. Hello, this is very simple for me, sir I will do this project of formatting publication in excel very well and perfectly right now within 24 hours. If you are interested in working with me, feel free to message me and i will help you immediately. Hence Bid price is not fixed It is negotiable.

€10 EUR trong 1 ngày

4,7

(82 nhận xét)

5,0

@Jatin77777

Hello, I have gone through with contents and understand the requirements. I am interested to do this work and break your huddle. Please allow me to do this job. I am available to support you 24*7 just ping me once. I have a good knowledge of Excel, Advance Excel functions and VBA. I know Sumifs, Countifs, Averageifs, Index, Match, Vlookup, Hlookup, Sorting, Pivot table, Slicers, Developer functions & Conditional formatting, etc. Please check my portfolio to know more Thanks, Jitender Kumar

€27 EUR trong 2 ngày

5,0

(22 nhận xét)

4,7

@workguruu

Hello Lets start it now to deliver back for shortest time. so that you can proceed forward with your content. Should we talk ?Waiting

€30 EUR trong 1 ngày

0,0

(0 nhận xét)

0,0

@shivanidubey487

I give you the best result as you want. Relevant Skills and Experience Worked with excel and data entry.

€23 EUR trong 1 ngày

0,0

(0 nhận xét)

0,0

@amirulislam8391

Dear sir , I will be perfectly do your work , I am a professional Microsoft office expert, I have more than 6 years experience in real life, I am new here but expert with Microsoft office, please give me a chance , I am sure you will be satisfied.

€20 EUR trong 7 ngày

0,0

(0 nhận xét)

0,0

@mcrahul

I am an expert in Excel work and have industrial experience of 1 year. Since I am a beginner in freelancing I can offer free work and expecting a good rating for the work I have done.

€8 EUR trong 1 ngày

0,0

(0 nhận xét)

0,0

@monishk716

I m working on excel since last 5 year. I am quite good in excel you can trust me. I can do your work with in given time frame I only deliver a high-Quality Job. I Love to hear Hi from you. Thank you

€14 EUR trong 1 ngày

0,0

(0 nhận xét)

0,0

@MBILALMEHDI

Hi, I am a data entry expert and done many projects. kindly reply me I convert your file and I will show your file

€19 EUR trong 7 ngày

0,0

(0 nhận xét)

0,0

@maxwell707

Hello I can do this project in the shortest possible time and with the highest quality and you will be satisfied if you trust my skills. thank you

€19 EUR trong 7 ngày

0,0

(0 nhận xét)

0,0

@anooshakafeel112

Hey hope you will fine .I am expert in excel, PowerPoint,word ,PDF converter ,web researching and typing . If you consider me as your employee I will do this project free if you agree and I hope you will be interested .. grateful if you hire me

€12 EUR trong 2 ngày

0,0

(0 nhận xét)

0,0

@akimranbd

Dear Hiring manager I am an expert excel freelancer. I can do it with in 3day. Relevant Skills and Experience I am a Web designer Microsoft offic, excel,PowerPoin, word expert.

€24 EUR trong 3 ngày

0,0

(0 nhận xét)

0,0

@diab132

i believe im right person for that, im expert in excel for 15 years, almost most kinds of issues passed to me, and solutions is exist , will be happy to discuss in inbox for more details

€17 EUR trong 7 ngày

0,0

(0 nhận xét)

0,0

@Fatom112

Hello there ! It's Fatima Farhan. I am a researcher and i have worked with different types of data. I have great experience with excel, Microsoft office and visual basic since i have been using those tools for more than 4 years. You will surely not regret hiring me and working with me . I have done my all previous works by handling them smoothly and of course professionally. I do my work with paying attention to small details and i believe that i'm compatible enough to this project. So, if you think I am compatible enough for this job then pick me. Thank you.

€20 EUR trong 7 ngày

0,0

(0 nhận xét)

0,0

@mpmalabika

I am Data Entry expert. I am proficient in typing and transcriptions. I will do your work with responsibility and delivery in time. Relevant Skills and Experience I am proficient in Excel , Word, Access, PowerPoint presentation

€23 EUR trong 10 ngày

0,0

(0 nhận xét)

0,0

@Ravishan2211

Hi I can do this project as in the screenshot and possible time and with the highest quality if you trust my skills. thank you

€20 EUR trong 3 ngày

0,0

(0 nhận xét)

0,0

@afaqahmad2748

Hi sir I can perform this task because of my experience in the data entry field its a piece of cake for me and its a simple task. The project will be delivered to you in 3 days.

€8 EUR trong 7 ngày