# Importing glossary in csv - target shows as untranslated

**URL:** <https://forum.xbench.net/t/importing-glossary-in-csv-target-shows-as-untranslated/804>\
**Category:** Technical Support\
**Created:** [June 23, 2021, 3:57pm UTC](https://forum.xbench.net/t/importing-glossary-in-csv-target-shows-as-untranslated/804 "2021-06-23T15:57:45Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Y-cahn](https://avatars.discourse-cdn.com/v4/letter/y/b3f665/32.png) [@Y-cahn](https://forum.xbench.net/u/Y-cahn)\
**Post date:** [June 23, 2021, 3:57pm UTC](https://forum.xbench.net/t/importing-glossary-in-csv-target-shows-as-untranslated/804/1 "2021-06-23T15:57:45Z")

</div>

Hello! I am trying to import a simple csv glossary into xbench. When I imported it as Microsoft Glossary and ran Key Term Mismatch in QA, the target entry for glossary showed up as untranslated. My csv has two columns, one for the source text and the other for the traget.

Things I tried:  
I tried adding the column titles at the top, “Source” and “Target” each. Didn’t work.

xBench Version: 2.9

How should the csv file be formatted? What am I doing wrong?

---

<div class="post-metadata">

**Author:** ![pcondal](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.xbench.net/pcondal/32/305_2.png) [@pcondal](https://forum.xbench.net/u/pcondal)\
**Post date:** [June 25, 2021, 9:13pm UTC](https://forum.xbench.net/t/importing-glossary-in-csv-target-shows-as-untranslated/804/2 "2021-06-25T21:13:47Z")

</div>

I would recommend saving the CSV file as tab-delimited text file with Excel, with Source text in the first column and target text in second column.