PowerShell Excel Parsing Script

$30-250 USD

Completed

Posted

over 5 years ago

$30-250 USD

Paid on delivery

Need a PowerShell script that can parse a library of commonly formatted spreadsheets and extract the data into a series of pipe delimited files. I will provide a sample spreadsheet and indicate which sections need to be extracted in which files. Col A of Every CSV Row written must be the xls file name ('Sample Freelancer [login to view URL]' in the example provided). All green values are csv column names (fields) and the grey cells are their corresponding values. Ignore 'Dropdown Lists' tab. Every time the PS Script is run, it should append to the existing csv files specified. PS Script will need to read a folder that has numerous xls files (with this same format ) that need to be parsed. The following files will need to be updated from each xls that is processed by the PS script. [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL]

Excel

Powershell

Project ID: 18523919

About the project

20 proposals

Remote project

Active 5 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

Awarded to:

@markelof

Hello, I have a question, can it be written in C# as a custom software with friendly user interface instead of Powershell script? If yes then I can create such a tool for you.

$155 USD in 3 days

5.0

(23 reviews)

4.6

20 freelancers are bidding on average $149 USD for this job

@schoudhary1553

Hello, I have gone through your job PowerShell Excel Parsing Script and i am sure i can deliver you the quality job. Please see my profile i have deliver almost 430 projects with 100% client satisfaction. I have the good knowledge of Excel, Powershell. Please ping me for further discussion.

$180 USD in 3 days

4.9

(299 reviews)

7.8

@zekovicm

Hi there,I am scripting expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan

$200 USD in 2 days

4.9

(98 reviews)

7.0

@vlayausa

Hello, I have a lot of experience with PowerShell and this script sounds like something I could do. I would love to help you with it. I really believe I could finish it very quick. Please contact me for more information.

$108 USD in 3 days

4.9

(130 reviews)

5.8

@lightingdavid

Hello. Nice to meet you. I have read your project description carefully and i can make PS script for this. I have some questions following: 1. Do you want to make PS script to parse all excel files in folder? 2. In a Folder, there are only excel files?(no Folder) 3. All excel files have same green color and grey color? I hope to contact with you. Thanks.

$140 USD in 3 days

4.8

(73 reviews)

5.6

@lkhelladi

Hello, I'd be glad to develop the excel parsing tool for you. Looking forward to chat with you soon for more details. Best regards,

$77 USD in 0 day

5.0

(7 reviews)

4.5

@dany3j

Hi there! Dear colleague. I can help you with this Powershell project. I would like to know more about it. Contact me by Chat to get more information. My Best Regards

$100 USD in 5 days

4.9

(10 reviews)

3.8

@DebasisB

HI there, I am interested in the project. I can provide the script exactly as per your requirement. Thank you.

$155 USD in 2 days

5.0

(4 reviews)

3.4

@AhmadSameer

Hey there I'm a System Engineer with coding skills. I had developed tons of scripts using Powershell. I'm downloading the attached file to check. I can help. Regards.

$155 USD in 3 days

5.0

(7 reviews)

3.5

@goodwork20k

I am good in powershell and perl along with devops, i used to work with data conversion project and id did similar projects Please let me know if you are good to award this project to me

$211 USD in 7 days

4.9

(6 reviews)

3.4

@kostiapl

How are you? I am interested in your project and would like to work on it. Can start without any prepayments to show my skills. I am planning to use COM OLE to work with Excel files and add some additional features like logging to simplify debugging if it will be needed. Feel free to ask any questions.

$88 USD in 3 days

5.0

(5 reviews)

2.5

@AdrianCJ

this looks pretty straightforward. As an admin I am pulling monthly xsl&csv reports all with powershell. I also done *.csv data manipulation on this website so please hyave a look and make a decision!

$130 USD in 3 days

5.0

(5 reviews)

2.3

@MaxFinley

I am a freelance writer who is well-versed in the English language. Whether its grammar, punctuation or sentence construction I have worked hard to get myself up to native level proficiency. I am very dedicated to my profession and find myself contented with what I do. I love to work with new people and try to nurture pleasant long-term relationships which mutually benefit us. I can assure you that I time and prioritize myself well hence I will definitely not miss any deadlines. I will treat the project as mine and will deliver the best quality I can deliver in the given time. Expecting to hear from you, thanks!

$111 USD in 3 days

0.0

(0 reviews)

0.0

@cbuky

Am a computer scientist,a Microsoft certified professional with Microsoft Dynamic CRM , very fluent and proficient with Microsoft Office suite and Office 365

$240 USD in 3 days

0.0

(0 reviews)

0.0

@DataSoolutions

Hi There...Having quite an experience in powershell, I am very much confident enough to finish the task within 2 days at a reasonable price. Please do ping me to discuss further. Thanks and Regards, DataSoolutions

$60 USD in 2 days

0.0

(0 reviews)

0.0

@SajidYousuf

A dynamic and diversified individual with results driven approach with over 7 years of proven leadership experience and 14+ Years of extensive International & Local working experience in reputed IT / Business Oriented Organizations. Change agent & Problem-solver with a passion for transformation, technology, conceptualization, developing and implementing solutions and having vast business domain exposure.

$222 USD in 5 days

0.0

(0 reviews)

0.0

@DevStar925

Flag of LAO PEOPLE'S DEMOCRATIC REPUBLIC

Hi, Dear Employer! I am really interested in your project. I have enough experience in PowerShell, Python, C/C++, C#, java programming. I am 100% sure I can satisfy your requirements perfectly. Clear Algorithm Will Encourage Your Project. I want a long-term relationship with you. Thank you and best regards!

$200 USD in 3 days

0.0

(0 reviews)

2.0

@prj102

I will work with you to completely understand your requirements and will work to create a powershell script that will pull the required data from files from a directory and export the data required in a csv format. Requirements -Sample files for testing -Script would need to be run on a system with excel installed Thank you for the opportunity and look forward to working together if selected.

$138 USD in 3 days