> For the complete documentation index, see [llms.txt](https://docs.theconfigteam.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.theconfigteam.com/prebilt-ewm/configuration-guide/translations/downloading-translations-1.md).
# Transforming the data
The text file can be updated directly by manually replacing the source language field description with the translated text, then saving the changes after completing the update.
The most efficient way to update the fields is using the power query editor in Excel. To do this, open Excel, navigate to the **Data** tab, then select **Get Data** followed by **From Text/CSV**.
Select the downloaded txt file and select **Import**.
Select **Transform Data** then select the Transform tab, select the **Split Column** option by delimiter and maintain the below split by delimiter settings.
After selecting **OK**, the screen field description will be separated from the string.
Select **File** then **Close and Load**.
Add a new column to the right and start translating the screen field descriptions.
After completing the translation, save the file as a new .txt file. The translation can then be uploaded back into SAP.
{% hint style="info" %}
**Note**
Ensure the file only contains the target language when saving.
It may also be necessary to split the menus, function codes and exception codes into a separate .txt file.
{% endhint %}
.png?alt=media)
.png?alt=media)
.png?alt=media)
.png?alt=media)
.png?alt=media)