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.

Attached desired format

Habilidades: Excel, Python

Ver 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 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
(250 Comentários)
7.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
(148 Comentários)
6.5
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
(95 Comentários)
6.6
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
(143 Comentários)
6.8
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
(68 Comentários)
6.7
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
(110 Comentários)
6.4
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
(137 Comentários)
6.4
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
(112 Comentários)
6.2
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
(186 Comentários)
6.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
(88 Comentários)
6.2
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
(88 Comentários)
5.8
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
(62 Comentários)
5.7
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
(68 Comentários)
5.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
(21 Comentários)
5.4
macroPOL

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)
5.6
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
(69 Comentários)
5.4
voneiden

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)
5.3
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
(23 Comentários)
5.1
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
(10 Comentários)
4.3
sreejithakaz

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)
3.9