Need to Parse Excel Sheet

$30-250 USD

Closed

Posted

about 6 years ago

$30-250 USD

Paid on delivery

We have an excel document with one column that has a field with many attributes in one. I need a macro to properly split these attributes into columns so i can import that in properly. You can see this column in the picture below . It has a specific structure. There are many attributes that are different for many of the rows. I need this column parsed into many rows on one row you can see the data is the following Type=Ethernet Switch|*|Form Factor=Rack-Mountable|*|Brand=3Com|*|MPN=3CR17251-91|*|Layer=3|*|Number of LAN Ports=48|*|Max. Data Transfer Rate=1000Mbps/1Gbps|*|Ethernet Technology=Gigabit Ethernet (1000-Mbit/s) I would need the tool to split this field into many columns: the columns should be Type Form Factor Brand MPN Layer Number of LAN Ports Max. Data Transfer Rate Ethernet Technology

Project ID: 16709157

About the project

43 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

43 freelancers are bidding on average $88 USD for this job

@jaylancer43

Hello, My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story). About Me - I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required in advance, please pay me once the job is 100% complete. Thanks, Jay

$250 USD in 3 days

5.0

(831 reviews)

8.9

@seaanddream

Hi, my name is Sevinc. I checked your columns structure, I can write a macro for you to fix it in 1-day as per your needs. I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses. I had many similar excel tasks, including automated data extraction, aggregation and reporting, all achieved with 5/5 rating. Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too... I bid my best for you to start business, and I am ready to prepare an excel workbook template for you to check & validate, once you give me a reply...regards.

$100 USD in 1 day

4.9

(363 reviews)

8.3

@schoudhary1553

Hello, I have the good knowledge of Need to Parse Excel Sheet. I have more than 5 years of experience in Data Entry, Data Mining, Data Processing, Excel, Python. We have worked on several similar projects before! We have worked on 300+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,

$180 USD in 3 days

4.9

(509 reviews)

8.4

@sohandas

Hi there, I just checked the project details and i'm very interested to discuss with you. I have great knowledge in excel formula and macros. Feel free to pm so that we can discuss and share sample work! Regards. Sohan D.

$50 USD in 1 day

5.0

(376 reviews)

8.0

@FINGERRPRINT

Hi there, we can do this by excel formula instead of other script. we can get you the result very quickly. this job is our daily task. Thank you

$59 USD in 1 day

4.9

(387 reviews)

8.3

@P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$100 USD in 3 days

5.0

(486 reviews)

8.0

@ponnarasiBabu

I read and understood your requirements - Need to Parse Excel Sheet and can do as instructed. So i hope you would open a PM to discuss about the work . Regards, Ponsi

$100 USD in 2 days

5.0

(448 reviews)

7.9

@paris2785

Hi, there. I just read your brief and it sounds very interesting. My name's Paris Pallas and I'm a very experienced VBA developer. I've developed hundreds of projects integrating code into MS Office apps such as Excel, Word, Access, and PowerPoint. I'm really interested in your project. I strongly suggest using a macro that will split the contents of each cell into separate columns (Type, Form Factor, Brand, MPN, Layer, Number of LAN Ports, Max. Data Transfer Rate, and Ethernet Technology). I can start right away and deliver within a couple of hours! Please, let me know if this is something you find interesting and would like to know more about it. Regards

$50 USD in 0 day

4.9

(375 reviews)

8.1

@mirniyazuddin92

Dear Sir/Ma'am, I have good experience in parse excel data I can do samples to show you kindly PM me to discuss further. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir

$50 USD in 1 day

4.9

(440 reviews)

8.1

@dgled

I have the knowledge and experience to implement your need on Microsoft Excel and VBA. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application, scripting including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. I offer you 35+ years of experience working in a variety of companies including, VC's, privet investors, entrepreneurs, startups, marine and land transportation, retailers, power plants, farms, insurance, universities, real estate & constructions, medical equipment manufacturer, among others.

$250 USD in 3 days

4.9

(95 reviews)

7.5

@TonmoyRoy111

Dear client I have previously carried out a number of projects in excel using macros and formulas. I understand the scope of work in this project and i certainly believe I can help you in this project. Kindly contact me Roy

$100 USD in 2 days

4.9

(479 reviews)

7.4

@zebracaro

I can do it for you quickly and exactly . Please contact me for saving your time and your money .

$70 USD in 2 days

4.9

(120 reviews)

7.1

@aubrey03

This can be easily done using Excel VBA. I can help you find the most efficient way. Feel free to contact me for details.

$33 USD in 2 days

4.9

(220 reviews)

7.0

@Attractionnet

Hello. I'm a vb.net programmer. Vb is the language used by excel. I will write a script which you can run anytime, in order to split the cells and add the values to the columns. It will be able to automatically create new columns when new values and field names are found. I can start today and have it ready within 1 day.

$77 USD in 1 day

5.0

(196 reviews)

7.0

@aarifakhtar

Hi: I can create a macro that will take the Excel file as input and generate the output will data split into multiple columns. I would like to highlight that I have over 7 years of experience in Excel and macros and completed several similar automation projects. I would request you to visit my profile to know more about my past experience and work quality. Thanks. Look forward to working with you.

$50 USD in 1 day

4.9

(182 reviews)

7.2

@chriskerpini

Hello, My name is Chrys. As you can see from my profile, I have 17+ years experience working with Excel/VBA and 13 years teaching them both (all levels). I can certainly do excellent work with your project. I reviewed the attached files, and everything is clear to me. Please contact me to further discuss the details. Looking forward to hear from you, Kind regards, Chrys

$70 USD in 1 day

4.9

(73 reviews)

6.8

@rohitagarberg

HI Sir I will develop a macro to parse the given row Regards

$80 USD in 3 days

5.0

(436 reviews)

6.7

@paulmd369

Hey, Do you have pen and paper? Take it that and give 100 marks for me out of others. Because, i have the exact taste of you. If not, hire me. Because, I don't have pen and paper as same like you. Thank you.

$100 USD in 4 days

5.0

(150 reviews)

6.6

@axiomswb

I have expertise in excel VBA. Client's satisfaction is my first priority and believe in long-term relationship with clients. Thank you..

$50 USD in 1 day

5.0

(49 reviews)

6.5

@exansoft

Hello I'm experienced Python developer and I'm interested with your task. I have extensive expertise in processing Excel spreadsheets with python code. I'm able to create the program that will parse the specified field. Let's discuss it in detail. Regards, Alex.

$200 USD in 1 day