How to export an analysis (statistics) from memoQ

The calculator reads memoQ statistics exported as CSV. Here is how to export them.

1. Run Statistics

Open the project and go to Translations in Project home.
Select the documents to bill (or all of them) and choose Statistics (on the Documents ribbon or via right-click).
Choose the translation memories and settings you agreed with the client and click OK.

2. Export to CSV

In the statistics results, click Export.
Choose one of the CSV formats: CSV (Per-file, All information) gives one row per document; CSV (Per-file, TRADOS-compatible) also works; CSV (Reflecting displayed results) gives the project total only.
As separator, memoQ recommends Tab. Semicolon and comma also work here.
Save the file and drop it into the calculator.

memoQ often saves CSV files as UTF-16 (Unicode). The calculator detects UTF-8 and UTF-16 automatically.

What the calculator reads

It looks for the source-word columns of the memoQ match rows: X-translated, 101%, Repetitions, 100%, 95%-99%, 85%-94%, 75%-84%, 50%-74%, No match and Fragments. Segment, character, tag, percent and target columns are ignored, and so are the All/Total rows. X-translated and 101% are context matches; Fragments are counted as no match. See the full mapping.

Troubleshooting

HTML export: not read. Export again as CSV.
Custom match ranges or renamed columns: may not be recognised; use manual entry.
Different numbers than expected: memoQ statistics depend on the selected memories and on homogeneity/repetition settings. Run the statistics again with the settings agreed with your client.

The export is read by your browser on your computer; this site does not upload it.

Open the calculator