Encerrado

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.

Habilidades: Excel, Python

Ver mais: format price, 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, macro import csv

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

ID do Projeto: #6789865

48 freelancers estão ofertando em média $75 para este trabalho

zExcel

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
(120 Comentários)
6.6
koolsidz

Your code is ready :) I am an VB / Excel Expert. If you see my reviews by navigating to this link [url removed, login to view] then you will notice th Mais

$30 USD in 0 dias
(115 Comentários)
6.1
maverick44000

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
(44 Comentários)
6.0
DeepSyaal

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
(131 Comentários)
5.9
mantislin

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
(45 Comentários)
5.9
nagybatonyi

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
(55 Comentários)
5.7
dpune

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
(45 Comentários)
5.5
aarifakhtar

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
(38 Comentários)
5.3
shikhamehta

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
(51 Comentários)
5.2
kher78

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
(52 Comentários)
5.0
ineedWorkJob

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
(22 Comentários)
5.0
SiroosJafary

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
(41 Comentários)
4.8
Venkylancing

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

$54 USD in 3 dias
(37 Comentários)
4.8
iticus

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
(5 Comentários)
4.6
paris2785

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
(24 Comentários)
4.2
dank111

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
(9 Comentários)
4.1
williammatheson

Hello, I am very interested in this project. If there are patterns to your input data, I can make an Excel VBA macro that searches for specific words/phrases (column headers). It can then detect the input file by Mais

$177 USD in 3 dias
(6 Comentários)
3.9
Attractionnet

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
(13 Comentários)
3.8
ahmedsobherfan

A proposal has not yet been provided

$30 USD em 1 dia
(21 Comentários)
3.7
excel4engineers

I will provide you VBA macro script under windows excel which you can use at all your files. You will get excel file with button which will allow you to select the source file. You will be able to assign SKU code an Mais

$30 USD em 1 dia
(9 Comentários)
3.5