Hi All,
I've spent a few hours collating some data for a project, but now that I about half way to go, I've hit a wall.
I have medium to large sized spreadsheet of about 500 rows, each containing product information where each row represents a separate product. There is the basic information like, title, image URL, main description, bullet point description (1,2,3 etc) as columns.
The data in this sheet needs to be entered into a website page - I already have prepared the bare bones of the HTML template, all that's left to fill in is the product information in its respective positions in the template.
Of course, copying and pasting each piece of information into the template will take weeks and I've thought of a few ideas, but hit a wall when I remind myself the data will be unique for each template!
The HTML code will also be in a cell in a spreadsheet so it's all within Excel.
I initially thought about using the Find and Replace function: I would add some characters amongst the HTML code, search for it, and the replace it with the required info. This doesn't work too well because there would be too much clicking about (selecting the title, description etc in pasting it into the Replace With box each time).
Can I devise a faster streamlined method?
I've spent a few hours collating some data for a project, but now that I about half way to go, I've hit a wall.
I have medium to large sized spreadsheet of about 500 rows, each containing product information where each row represents a separate product. There is the basic information like, title, image URL, main description, bullet point description (1,2,3 etc) as columns.
The data in this sheet needs to be entered into a website page - I already have prepared the bare bones of the HTML template, all that's left to fill in is the product information in its respective positions in the template.
Of course, copying and pasting each piece of information into the template will take weeks and I've thought of a few ideas, but hit a wall when I remind myself the data will be unique for each template!
The HTML code will also be in a cell in a spreadsheet so it's all within Excel.
I initially thought about using the Find and Replace function: I would add some characters amongst the HTML code, search for it, and the replace it with the required info. This doesn't work too well because there would be too much clicking about (selecting the title, description etc in pasting it into the Replace With box each time).
Can I devise a faster streamlined method?