Find Jobs
Hire Freelancers

Excel Data Formating

$30-250 USD

In Progress
Posted over 15 years ago

$30-250 USD

Paid on delivery
You are bidding on 2 excel data formatting automation spreadsheets. I think these can be done with excel macros and visual basic, but that’s beyond my skills. I have some complicated data formatting that needs to be done on csv files I download from our website. I hope to automate it so I don’t have to do so much copy and pasting. These are reformatting csv files I export from our wig sales website with volusion shopping cart, so I can upload the files back to the database. I need to format them as follows: 1st spreadsheet (see attached files [login to view URL], [login to view URL], [login to view URL]) I download columns productcode, catID, optionid, optiondesc (see [login to view URL]) Column k is just a copy of optionid with “-“ instead of “/” to fit the jpg filenames. The rest of the columns are just html code to make some color choice charts with pictures. I want all of these condensed into one field for each productcode (“AS_ANGELA” in sample file) Attachment [login to view URL] is a sample of what I want in each product field. The <table> tag on top, and </table> tag on bottom must also be included, and the “<tr>” tag must be after every rows (column “M” in [login to view URL]). So the code in [login to view URL] must then be placed in a column field called extinfo (see attachment [login to view URL]). Each product code has (10-50 options). So AS_ANGELA would be 1 row, with the “extinfo” field containing everything in 2.txt. Other productcodes would each have 1 row. I can then upload the resulting spreadsheet back up to our web site database. 2nd Excel formatting project: See attachment: [login to view URL] This one has the column names: id,optioncatid,optionsdesc,applytoproductcodes,ArrangeOptionsBy ID is the product option ID, optioncat is the product category, options desc is a description (usually a color number), applytoproductcodes is the product code the option is used for, and ArrangeOptionsby is the order the options for each product appear in the drop down menu on the website. The problem is each product can have as many as 50 options, and each product has a different combination of options. With 20,000 products, there are over 400,000options which is straining our server. I need to condense it so each option applies to multiple product codes. The applytoproductcodes field can have multiple product codes, but is limited to 255 characters. I need to reuse each ID for as many product codes such as “BJ_Amy” and “BJ_Charli” that will fit in 255 characters. For common colors such as 1 or 2, several option fields called 1 or 2, ect. will be needed. Excel will need to not go over 255 characters, and create as many options as needed to fit all the productcodes that use that color. The catID must stay the same. Some colors are rare and may only have a couple applytoproductcodes. I will try to clarify it better if you have any questions, and I can send larger samples if needed. Thank you!
Project ID: 341825

About the project

16 proposals
Remote project
Active 15 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I am an Excel expert, please see PMB.
$40 USD in 1 day
5.0 (56 reviews)
4.9
4.9
16 freelancers are bidding on average $68 USD for this job
User Avatar
I can help you with this. Please refer to PMB for the results.
$50 USD in 1 day
5.0 (39 reviews)
5.2
5.2
User Avatar
You may check PM.
$30 USD in 3 days
4.9 (32 reviews)
4.5
4.5
User Avatar
Dear Budgetech! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB.
$38 USD in 2 days
4.8 (16 reviews)
4.2
4.2
User Avatar
This can certainly be done using Excel VBA. I am ready to start IMMEDIATELY. Please refer to PM.
$40 USD in 1 day
5.0 (14 reviews)
4.0
4.0
User Avatar
Dear Mr / Ms Please have the kindness to check Project Message Board. Thanks
$50 USD in 3 days
4.1 (12 reviews)
3.5
3.5
User Avatar
i m interseted
$65 USD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, Ready to start. Please check PMB. Regards
$40 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Greetings, can do you task easily. Expert in writing macros in Excel. Let me know if you are interested. Can provide you sample macros of previously related projects.
$50 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello I can do this
$200 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Kindly see PM...
$100 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
This absolutely can be done with VBA (An Excel Macro) I have entensive experience with data manipulation and would be happy to get this done quickly and efficently...
$50 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
sir, i am very very interest of your project. please select me a bid winner.
$150 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Professional Work
$60 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, This would be an everyday routine for me, look forward to hearing from you ;). Cheers
$63 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Ashland, United States
5.0
120
Payment method verified
Member since Nov 11, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.