Importing excel to multiterm - applying a batch status
Thread poster: Wendy Cummings

Wendy Cummings  Identity Verified
United Kingdom
Local time: 23:01
Member (2006)
Spanish to English
+ ...
Nov 22, 2011

I have an excel spreadsheet that I wish to convert then import into a new termbase. The spreadsheet just has 2 columns, source and target.

The termbase definition that I will be using has a "status" field, one of the options for which is "client approved". When I import the spreadsheet, I want every single item from that spread sheet to have the status "client approved".

What is the best way to do this?



Martina Klett  Identity Verified
Local time: 00:01
Italian to German
+ ...
Insert an additional column in the excel file Nov 22, 2011

Dear Wendy,

there may be other solutions, but I would simply insert an additional column in excel called "status" and containing the value "client approved" for each term before converting the excel file.
If you want to add the status to both source and target terms, then you should add said column after the source term column and after the target term column.



To report site rules violations or get help, contact a site moderator:

You can also contact site staff by submitting a support request »

Importing excel to multiterm - applying a batch status

Advanced search

Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »
SDL Trados Studio 2021 Freelance
The leading translation software used by over 270,000 translators.

SDL Trados Studio 2021 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2021 transforms how new users get up and running and helps experienced users make the most of the powerful features.

More info »

  • All of
  • Term search
  • Jobs
  • Forums
  • Multiple search