# Replace Entire Field Column with Spreadsheet Data

**URL:** https://community.mp3tag.de/t/replace-entire-field-column-with-spreadsheet-data/56887
**Category:** Support
**Created:** [March 31, 2022, 2:31pm UTC](https://community.mp3tag.de/t/replace-entire-field-column-with-spreadsheet-data/56887 "2022-03-31T14:31:03Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![djScottie](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/d/7ab992/32.png) [@djScottie](https://community.mp3tag.de/u/djScottie)
#### Post date: [March 31, 2022, 2:31pm UTC](https://community.mp3tag.de/t/replace-entire-field-column-with-spreadsheet-data/56887/1 "2022-03-31T14:31:03Z")

</div>

I have a 3,000 song DJ Series with only title and artist tags.  
I have a corresponding spreadsheet of all the genres and years.  
The Disc Track sort in MP3tag matches perfectly to the spreadsheet.  
Is it possible to import the column data from the spreadsheet to a MP3tag field column?

---

<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: [March 31, 2022, 2:36pm UTC](https://community.mp3tag.de/t/replace-entire-field-column-with-spreadsheet-data/56887/2 "2022-03-31T14:36:07Z")

</div>

See the docs on Converter\>Text file-Tag:

> **[Import Tags from Text Files – Mp3tag Documentation](https://docs.mp3tag.de/converters/import-tags-from-text-files/)**
>
> Documentation on Text File to Tag, a converter to import tags from text files. Mp3tag is the universal Tag Editor.

---

<div class="post-metadata">

### Author: ![djScottie](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/d/7ab992/32.png) [@djScottie](https://community.mp3tag.de/u/djScottie)
#### Post date: [March 31, 2022, 2:47pm UTC](https://community.mp3tag.de/t/replace-entire-field-column-with-spreadsheet-data/56887/3 "2022-03-31T14:47:42Z")

</div>

NOTE: the "Format Strings and Placeholders" doc page does not include the %dummy% string, or information on purpose and use.

---

<div class="post-metadata">

### Author: ![LyricsLover](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/l/c6cbf5/32.png) [@LyricsLover](https://community.mp3tag.de/u/LyricsLover)
#### Post date: [March 31, 2022, 2:50pm UTC](https://community.mp3tag.de/t/replace-entire-field-column-with-spreadsheet-data/56887/4 "2022-03-31T14:50:44Z")

</div>

It is already mentioned here (in the above linked "Import Tags from Text Files") doc page:

![image](https://community.mp3tag.de/uploads/default/original/2X/6/67828b1317f73b0925fbf386c333a7fbb341bc0f.png)

But you are right `%dummy%` is not listed in [Format Strings and Placeholders](https://docs.mp3tag.de/format/).

---

<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: [April 30, 2022, 2:50pm UTC](https://community.mp3tag.de/t/replace-entire-field-column-with-spreadsheet-data/56887/5 "2022-04-30T14:50:49Z")

</div>

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