I'm trying to make data collection from client personal efficient and sanitized.In recent projects we have been using excel sheet for input data from the client, let's say list of all products along with it's metadata and pictures.The metadata in most of the cases has 1 to many relationship, let's say if we have a diamond ring, so it's variation will be different carat weights and associated prices. The product comes with images as well.Here's how our excel sheet looks likeId, name, carats,           prices.             description1, ring1, .25,.50,1.0,1.5.  100,200,300,400     {ring1;url.com/info1},{ring2;url.com/info2},{ring2;url.com/info2}As you can see we kind of enforced a pattern for input data, description field was a little complicated, a comma separated list with some meta info and more detail url.The problem is that it's difficult for the client to adhere to the rules so data input was not so efficient and had to fix many things. Client also provided product images in a separate folder and I had a field in excel sheet for the same.images (based on carat weights)01-.25.jpg,01-.50.jpg,01-2.0.jpgSo it got messier and messier. there were mistakes with image names etc.I looked for alternative options, something quick instead of making a custom CMS.I looked into access db as well since it provides forms for data input and all I've to do is to link up tables with forms but it works for windows only. Wish mysql had forms feature like this (free ones)So basically I'm not finding excel an efficient approach when it comes to data input like this. Looking for suggestions and improvements when it comes to some kind of enforced input and validated data along with images input.
Data input from client personnel
mysql;data;validation;excel;microsoft access