# Import File Text from Excel **URL:** \ **Category:** Support\ **Created:** [January 29, 2016, 7:59am UTC](https://community.mp3tag.de/t/import-file-text-from-excel/17600 "2016-01-29T07:59:29Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Tranber44](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/t/e9a140/32.png) [@Tranber44](https://community.mp3tag.de/u/Tranber44)\ **Post date:** [January 29, 2016, 7:59am UTC](https://community.mp3tag.de/t/import-file-text-from-excel/17600/1 "2016-01-29T07:59:29Z")
Hello, Wishing to update the tags of a file ( 60 titles(securities)) I exported the data towards Excel under shape csv, then I reorganized my sheet(leaf) Excel in 3 columns, Title, Artist, Year. Made corrections I now wish to use the function(office) Text file - \> Tag. Under what shape do I have to export my Excel file? Thank you. Cordially ---
**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:** [January 29, 2016, 8:54am UTC](https://community.mp3tag.de/t/import-file-text-from-excel/17600/2 "2016-01-29T08:54:52Z")
Use csv (again). Caution: the number of lines in the excel-sheet must be more or equal the number of selected files in the files list. And the order must be the same. You have to enter something like %title%;%artist%;%year when importing the data. Next time, when you export data, also include %\_filename% to align the text data with the audio files. ---
**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, 3:53pm UTC](https://community.mp3tag.de/t/import-file-text-from-excel/17600/3 "2025-03-04T15:53:43Z")
Closed on March 4, 2025, 3:53pm UTC This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.