When importing new data - for example addresses or products that don't exist yet in 2sxc - you must do the following:
- Go to 2sxc and export a template-import-file which contains the correct structure for re-importing later on. Of course this requires that your designer or developer already created a content-type for your data to import.
- Open the template-file in excel
- Add your content to the table with copy-paste or similar
- Save as XML
That's it. If you have more questions regarding the GUID or languages - you'll find answers further below.
Note that if you ever want to sync data again (for example, to update parts of the data like the price) you should have some kind of ID in your data (to help matching in the future). If your data has GUIDs you could use that (then place it in the GUID column), otherwise it would be wise to also import the external ID into one of the columns as well.