# How to specify Excel's columns as separators?

**URL:** <https://community.mp3tag.de/t/how-to-specify-excels-columns-as-separators/50533>\
**Category:** Support\
**Created:** [October 20, 2020, 1:34pm UTC](https://community.mp3tag.de/t/how-to-specify-excels-columns-as-separators/50533 "2020-10-20T13:34:37Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![GVA1994](https://community.mp3tag.de/user_avatar/community.mp3tag.de/gva1994/32/8219_2.png) [@GVA1994](https://community.mp3tag.de/u/GVA1994)\
**Post date:** [October 20, 2020, 1:34pm UTC](https://community.mp3tag.de/t/how-to-specify-excels-columns-as-separators/50533/1 "2020-10-20T13:34:37Z")

</div>

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](https://community.mp3tag.de/uploads/short-url/fbh4foVvSwwewLDWC1scxoOZGS8.png)

---

<div class="post-metadata">

**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\
**Post date:** [October 20, 2020, 1:41pm UTC](https://community.mp3tag.de/t/how-to-specify-excels-columns-as-separators/50533/2 "2020-10-20T13:41:51Z")

</div>

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

> **[Import or export text (.txt or .csv) files](https://support.microsoft.com/en-us/office/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba)**
>
> To import a text file, you can open the file or import the text file as an external data range. To export a text file, use the Save As command.

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.

---

<div class="post-metadata">

**Author:** ![GVA1994](https://community.mp3tag.de/user_avatar/community.mp3tag.de/gva1994/32/8219_2.png) [@GVA1994](https://community.mp3tag.de/u/GVA1994)\
**Post date:** [October 20, 2020, 1:42pm UTC](https://community.mp3tag.de/t/how-to-specify-excels-columns-as-separators/50533/3 "2020-10-20T13:42:42Z")

</div>

Thanks for the quick help!

---

<div class="post-metadata">

**Author:** ![system](https://community.mp3tag.de/uploads/default/original/2X/c/ce7035d426cb755a7916793326d23b465222a407.png) [@system](https://community.mp3tag.de/u/system)\
**Post date:** [March 4, 2025, 4:11pm UTC](https://community.mp3tag.de/t/how-to-specify-excels-columns-as-separators/50533/4 "2025-03-04T16:11:52Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.