One of my suppliers can provide me with CSV feed of products, and it works fine (I tested). But to import it in my shop I need to adjust some fields, like change price, change titles, description, variations. Unfortunately I can't open that CSV file in my excel (2011 mac) to make adjustments.
I need someone who can show me the best way or tool how to edit that csv file, so I can import products to my shop (wordpress woocommerce) with layout I need.
Thanx
Hi,
Shall provide you with an Excel based automated tool using VBA to generate the output file in required format.
Please note that the solution for Mac will be different from that for Windows. And I am capable of doing for both OS.
Let me know and provide further details.
Regards,
Arul
Hi, If you could send me the csv file I will try to create a routine to automate the extraction of data
-------------------------------------------------------------------------------------------------------------------
Hi Ivo. I can show you how to do it and can write a macro that would always reorder the data for you in desired formate. Lets discuss and begin the job.
Usman.
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
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.
Here are the links for my past experiences:
https://www.freelancer.com/projects/Excel/Drawing-EXCEL.html
https://www.freelancer.com/projects/4848189.html
https://www.freelancer.com/projects/Visual-Basic-Excel/Excel-user-form.html
https://www.freelancer.com/projects/Excel/Excel-Spreadsheet-Timecard-for-work.html
https://www.freelancer.com/projects/Data-Entry-Excel/Excel-Line-Restructured.html
Regards.
Dear Sir, We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words,
let's get it done right away and I mean RIGHT AWAY !! Looking forward to hear from you soon - GOD Bless You.
Respected Hiring Manager - I have read your post and have understood it clearly - i am confident that i will be able to get this work done - I am willing to start this work immediately, I have bid for least price and got some great reviews from my client for whom i have worked for
Thanks,
vaibhav
Comma Separated Values (CSV) files can be edited several ways. The best way for you may depend on how large the files are, and what % of the entries need to be changed.
Hi There,
I can either update the CSV for you directly or walk you through a program than can open large size flat-files. I have opened files larger than 2GB with this program
Hi
i am ready to start this work.
i will Provide Web Solutions Fast - Accurate - Professional. Our main target is 101% client satisfaction. We are part of a Professionals network..
i have brief knowledge of every thing required and necessary for website development. so if you are interested.
Thanks
Hello.
CSV is a text file. Normally fields r separated by Comma or Tab character.
U can edit it by u'r text editor or a spreadsheet program like Micro$fot Excel or free and open source, equivalent of Micro$oft Office called OpenOffice (Calc).
Please tell exactly what's u'r problem
?
Hi,
I can complete this project within hours depending on the complexity of the requirement and I can start working immediately.
If you are on Mac, you can check "appleworks spreadsheet" to open the csv file.
PM me for further discussion.
Thanks,
Abhishek