Shopify provides CSV exports/imports for various resources (products, URL redirects, etc). Here are some handy rules when manipulating data from old sources such as when updating during the course of a platform migration to Shopify
=CONCAT(firstItem, secondItem)
=REGEXREPLACE(selection, "[^a-zA-Z0-9 ]", "")