Extract data from Excel files and convert it to desired format using an script

We are getting inventory feeds from our vendors. we will need to format each one (about 20) to the CSV format that we required, Attached is an example of the Excel file that we get and the csv file that we require in order to import automatically.

Keep in mind that we need to have an script or macro or something simple that somebody can place the file in a folder and run an script EASILY. Otherwise we could format in house spending 2-3 minutes each. The idea is to make it in bulk.

We have multiples ongoing basis files that we need to do it, please post price per file, All other files are similar.

Attached desired format

Habilidades: Excel, Python

Veja mais: format price, python: get data, python excel, excel python, desired, inventory excel format, extract data excel file, python convert file csv, convert excel python, macro script file, inventory files, extract excel files, python extract, excel file convert, excel macro csv, format similar, excel required csv, import data macro excel, python convert csv, python convert file, excel script simple example, excel 2014 macro, simple script excel, import files folder, using file python

Acerca do Empregador:
( 21 comentários ) Doral, United States

ID do Projeto: #6789865

47 freelancers estão ofertando em média $74 para esse trabalho


Hi, I'll be happy to help you with this project. Please feel free to message me if you need to discuss any questions

$100 USD in 2 dias
(250 Comentários)

Your code is ready :) I am an VB / Excel Expert. If you see my reviews by navigating to this link http://www.freelancer.com/users/feedback_1193882.html?period=entire_history&category=0 then you will notice th Mais

$30 USD in 0 dias
(148 Comentários)

Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi

$250 USD in 5 dias
(95 Comentários)

Hi: I can write a script for you that you can double click and get the data in the required format. Please note that I have 100% completion rate and 5-star feedback on projects. Please connect with me before awarding t Mais

$55 USD in 2 dias
(143 Comentários)

Hi there. Being highly proficient with VBA Excel, I can write a macro for you that shall convert the feeds to desired Excel format.I am ready to do complete work without any advance payment. Regards.

$160 USD in 2 dias
(68 Comentários)

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I am highly qualified fo Mais

$60 USD in 6 dias
(110 Comentários)

I am good at excel, i can do this manually with formulas, neatly, error-free. let me know please........

$54 USD in 3 dias
(137 Comentários)

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 215 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive Mais

$100 USD in 7 dias
(112 Comentários)

Lets Start. Having a team of Excel Professionals. We provide high quality work with accuracy. Would you like to discus more about your current requirements?

$30 USD em 1 dia
(186 Comentários)

Hey, So if I understand this correctly, you need the material and the quantity columns from the source files to be imported to a csv file. I believe that different vendors will have these columns in different cells in Mais

$35 USD em 1 dia
(88 Comentários)

Hi. I have created many similar programs, so this can be completed within one day. You just have to have all files in an input folder, open the program and press a button. It will give you the output file automatically Mais

$35 USD in 0 dias
(88 Comentários)

I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro containe Mais

$45 USD em 1 dia
(62 Comentários)

Good day, I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. I work with excel since 1999. Mais

$61 USD in 3 dias
(68 Comentários)

Hello, I have experience with manipulating XLS/XLSX/CSV files from Python using modules like csv, xlrd, openpyxl. From what I can tell from the samples you need to extract the data from the "Material" and "Quantity Mais

$100 USD in 3 dias
(21 Comentários)

Hello, I wrote a macro that does the project. You can see the effect: [url removed, login to view] I will gladly answer your questions Thank you very much Jan Krzyzak

$50 USD em 1 dia
(60 Comentários)

Hello, I've done many similar jobs to this in the past and I would propose just having an Excel tool (file) that has a userform that allows the user to press a button to select which file they would like to covert. Mais

$50 USD em 1 dia
(69 Comentários)

Hi, I can offer you a python program (both .py and .exe) that converts these .xls files to .csv files as you have defined (extracting material and quantity columns). The price offered is for a single file as you req Mais

$30 USD in 3 dias
(9 Comentários)

Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert desktop software/macro/bot/ Mais

$100 USD em 1 dia
(23 Comentários)

Hi, My name is Dan. I am an expert in excel and all advanced functionalities. I can code the vba script to automate this process of consolidating about 20 files into the csv format. I understand the only columns req Mais

$111 USD in 3 dias
(10 Comentários)

I have over 8 years of experience in Excel and Access VBA. I have developed several Tools, Automation, Dashboard and Online Tools using VBA. I have done similar project using Excel VBA in the past. The quote is Mais

$45 USD in 3 dias
(12 Comentários)