Convertor from .log to .xls?
Thread poster: Maria Asis

Maria Asis  Identity Verified
Spain
Local time: 12:54
English to Spanish
+ ...
Feb 11, 2003

Dear all!



I was once browsing the web and found that a translation agency had created a tool that converted Trados logs into Excel files, which I found very useful. I think this was freeware.



I didn\'t bookmarked it then , but maybe some of you know it.



Could you please tell me?



Thanks a lot!



Maria José


Direct link Reply with quote
 

gianfranco  Identity Verified
Brazil
Local time: 07:54
Member (2001)
English to Italian
+ ...
Import in Excel the .csv file Feb 11, 2003

There is no need of special tools. You can import the results of a Trados analysis directly into Excel.



The analysis produces two files: a .log file and a .csv file.

The .csv file can be imported into Excel, but make sure you specify the correct separator between fields (semicolon).

You will obtain a neat table containing all the words and fuzzy matches for each file of your Trados project.



Gianfranco







[ This Message was edited by:on2003-02-11 17:43]


Direct link Reply with quote
 

Maria Asis  Identity Verified
Spain
Local time: 12:54
English to Spanish
+ ...
TOPIC STARTER
Thanks! But how...? Feb 12, 2003

Thanks Gianfranco!



Quote:


The analysis produces two files: a .log file and a .csv file.

The .csv file can be imported into Excel, but make sure you specify the correct separator between fields (semicolon).

You will obtain a neat table containing all the words and fuzzy matches for each file of your Trados project.



Gianfranco





Maybe this is basic knowledge but I don\'t know how to do it. Could you please tell me where shall I specify the correct separator between fields (semicolon)? I\'ve tried to open the .csv file directly from Excell and the format is not correct.



Thanks again!



Maria José



[ This Message was edited by:on2003-02-12 08:06]

Direct link Reply with quote
 

gianfranco  Identity Verified
Brazil
Local time: 07:54
Member (2001)
English to Italian
+ ...
Procedure to import .csv Trados analysis files in Excel Feb 12, 2003

(I\'m referring to the English version of Excel 2000)



1. Go to the menu Data.

2. Select the option \"Get External Data\".

3. Select the option \"Import text file\" (the csv file is a text file).

4. Select the file in the opened Import text file dialog (select files *.* and not .txt).

5. Click Import. It is a wizard with 3 steps.

6. Step 1: Select Delimited (and not Fixed width), then select Next.

7. Step 2: Select \'Semicolon\' in the delimiters, then Next.

8. Skip the Step 3, click on Finish.



and voila\', you\'ve got your .csv file in Excel format.



Gianfranco



Note: if you need only the word count for each fuzzy matches bracket and the total, you will need to delete some unnecessary columns.





[ This Message was edited by:on2003-02-12 17:11]


Direct link Reply with quote
 
Henning Schlicht
Local time: 12:54
Export from Excel to .csv Nov 20, 2009

Dear all,

does anyone know how to Export an Excel file back to .csv?

The instructions in this thread were very useful for the important, but now I received edited file and I'll have to get it back in shape (csv format).

Would be very thankful if someone had a solution for this, I don't see myself copy-pasting 1.200 strings ...


Yours
Henning


Direct link Reply with quote
 


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

Moderator(s) of this forum
Maria Castro[Call to this topic]

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

Convertor from .log to .xls?

Advanced search







PDF Translation - the Easy Way
TransPDF converts your PDFs to XLIFF ready for professional translation.

TransPDF converts your PDFs to XLIFF ready for professional translation. It also puts your translations back into the PDF to make new PDFs. Quicker and more accurate than hand-editing PDF. Includes free use of Infix PDF Editor with your translated PDFs.

More info »
CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »



All of ProZ.com
  • All of ProZ.com
  • Term search
  • Jobs