MemoQ - How to import an entire Excel cell as one segment?
Շարքի հրապարակողը: Fabrice Brunon

Fabrice Brunon  Identity Verified
Ֆրանսիա
Local time: 17:39
Անդամ (2005)
անգլերենից ֆրանսերեն
+ ...
Jan 4

Hello!

When importing an Excel file for translation into MemoQ (9.2), is it possible to split segments so that one segment = one full Excel cell (several sentences), as opposed to one segment = one sentence?

Thanks!


 

mikhailo
Local time: 19:39
անգլերենից ռուսերեն
+ ...
re Jan 5

Fabrice Brunon wrote:

Hello!

When importing an Excel file for translation into MemoQ (9.2), is it possible to split segments so that one segment = one full Excel cell (several sentences), as opposed to one segment = one sentence?

Thanks!


Bad question. You haven't specified separator in cells. If line break — xlsx filter settings checkbox «Import linebreaks as inline tags» (and RTFM)


 

Stepan Konev  Identity Verified
Ռուսաստանի Դաշնություն
Local time: 19:39
անգլերենից ռուսերեն
https://helpcenter.memoq.com/hc/en-us/articles/360010377519-Importing-the-content-of-an-Excel-spread Jan 6

To invoke it, press 'Import With Options...' - locate your file - press 'Change filter & configuration'

 

Lincoln Hui  Identity Verified
Հոնկ Կոնգ
Local time: 00:39
Անդամ
չինարենից անգլերեն
+ ...
Punctuation Sep 21

mikhailo wrote:

Fabrice Brunon wrote:

Hello!

When importing an Excel file for translation into MemoQ (9.2), is it possible to split segments so that one segment = one full Excel cell (several sentences), as opposed to one segment = one sentence?

Thanks!


Bad question. You haven't specified separator in cells. If line break — xlsx filter settings checkbox «Import linebreaks as inline tags» (and RTFM)

MemoQ uses punctuation. The "Import linebreaks as inline tags" setting does not work; what the webpage posted above says is a flat-out lie.

The only workaround I've found is to create a new segmentation rule set for Excel files, and put a torch to all the separators in the Advanced View.

[Edited at 2020-09-21 05:07 GMT]


 

Kay-Viktor Stegemann
Գերմանիա
Local time: 17:39
Անդամ (2016)
անգլերենից գերմաներեն
Import it as multilingual delimited text file Sep 21

You can import Excel files as multilingual delimited text files:

Import with Options - choose file type "Multilingual delimited text file" - choose file. In the "document import options" window, make sure that "Filter" says "Multilingual delimited text filter" (in older MemoQ versions, this defaults to a Microsoft Excel filter if you chose an XLS(x) file).
Now, "change filter and configuration" and set the column with the source texts and another column for the target texts.... See more
You can import Excel files as multilingual delimited text files:

Import with Options - choose file type "Multilingual delimited text file" - choose file. In the "document import options" window, make sure that "Filter" says "Multilingual delimited text filter" (in older MemoQ versions, this defaults to a Microsoft Excel filter if you chose an XLS(x) file).
Now, "change filter and configuration" and set the column with the source texts and another column for the target texts.

That should do the trick: one cell, one segment.
Collapse


 

Stepan Konev  Identity Verified
Ռուսաստանի Դաշնություն
Local time: 19:39
անգլերենից ռուսերեն
A simpler way Sep 22

1. Clone the segmentation rules for Excel files
2. Go to the Advanced view
3. Remove all rules


 


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


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

MemoQ - How to import an entire Excel cell as one segment?

Advanced search






PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »
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 »



Forums
  • All of ProZ.com
  • Բառերի որոնում
  • Պատվերներ
  • Ֆորումներ
  • Multiple search