The stuff in the wrong cells is a result of missing information. That information can be subsituted by putting in an additional comma in its place. So if you have:
Name, AddressLine1, AddressLine2, Postcode, etc. and AddressLine2 doesn't have any information, just put a comma in its place.
You're going to run into issues where the data itself contains ",". I think if you put a pair of double quotes round all your fields it should be fine, like : "field1", "field2".
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.