How to specify Excel's columns as separators?

Support
1

Hi,

Metadata noob here. I'm trying to add metadata through a .csv with 2 columns. It looks like this. How would I specify the use of two columns (in the format string) in stead of the usual comma-separator?

Thanks in advance!

snippet

2

Use something different to export the files from Excel as suggested by Microsoft:

If you use the tab character, load the file into e.g. MS Word and replace the tab character with a unique character, e.g. |
Then use that unique character as separator between the field variables.

3

Thanks for the quick help!