Excel Macro Converting CSV to HTML

I need an excel macro that will convert a CSV file to HTML or PHP format that I will paste on a page on my zen cart website.

CSV lacks pricing information so I have to manually input such field. CSV is also received on a weekly basis so Excel file must retain pricing information inserted previously. I have summarized procedure below, feel free to ask any questions.

The process is as following:

1. CSV is opened and inserted into Excel. Columns are set up accordings.

2. Pricing column is added. Dialog is opened asking pricing for each entry. Value is saved in the field.

3. Macro then outputs a txt file with full HTML or PHP.

On the next week the following will happen:

1. Previous Excel file is opened.

2. Macro imports new CSV file.

3. Macro will only add new entrys from CSV file and request pricing. It will also delete any entries that are no longer in the CSV.

3. Macro then outputs txt file.

I will be providing CSV file, formatted Excel file (that i manually created as template).

CSV file has about a total of 200-300 lines.

Ask any questions you may have.

Thank you.

Compétences : Traitement de Données, Excel, HTML, PHP

en voir plus : converting csv html php, pricing template free, jolla, data entry macro, convert excel to website, ask excel, csv html macro, pricing excel, macro, excel to html, excel html, data entrys, csv to excel, php process csv, 200 questions html, excel macro add, txt convert excel, excel macro txt, php excel csv, excel file convert, input data excel website, excel macro csv, php convert html excel, csv column format, csv convert

Concernant l'employeur :
( 6 commentaires ) Miami Beach, United States

Nº du projet : #2338511

Décerné à:


Hello Jolla I am an Excel VBA developer with many successfully completed projects on Scriptlance. Your detailed requirements are clear and have already answered most of my questions. My proposal is to create a V Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 2 jours
(30 Commentaires)

14 freelance font une offre moyenne de $61 pour ce travail


Hi, I have past experience of creating macros to export HTML....See PMB for working sample..

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(126 Commentaires)

Hi, I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I am interested to work for your project. I will make sure that I deliver you the best with 100% ac Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(47 Commentaires)

Hi, Not a problem at all but I think I have bid on this already. If not just send a message David

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(26 Commentaires)

Hi, I can do it. I'm programmer for years and very familiar with vba for excel. which version of excel you need ( 2003,2007,2010 for windows or 2008, 2011 for Mac)? Looking forward to hearing you, Cuong NH

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(23 Commentaires)

Very Good at Excel 2003-2010 and Excel VBA Macros. Please allow me to do it. Will ensure everything is as per your requirement

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(43 Commentaires)

I am well experienced native VB developer with years of VBA experience, and, if you choose to award the project to me, I would finalize the project in a matter of hours, on your full satisfaction, and would be free to Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(6 Commentaires)

hello, please check PMB

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(7 Commentaires)

Please check PM for details

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(5 Commentaires)

Please check the PMB

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)

Hi Sir I am experienced VBA developer.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)

i am doing this type of works at office for various [login to view URL] to take this project also.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)

Send me the files.I am ready to start.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)

Dear Sir, Greetings! We are Reform Consulting with 5 year of experience under our belt. We are really interested to work on your project. Please see PM. Thank you. Regards, RCPL.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(3 Commentaires)