skip to Main Content

Heavyweight CSV files

How do you deal with a TM delivered to you as a 47MB csv file? Well – of course you open it (using MS Excel). That doesn't really work because it obviously has more than 65536 rows (and if it opens there's nothing to see because it doesn't t have the correct character page anyway). So what about importing it into DV (thinking that is the easiest to create a TMX). That worked well for 6 hours but then DV collapsed (though it imported about 1/3 of the file (maybe just around 65536 rows?). Next try is MS Access – which worked fine – but then what?

So finally OOffice 2.0beta came to save my life – not only does it tell me that the import was incomplete (which MS Office did too) but it allowed to insert a value in an optional field “import from row…”. So here we go – Finally I can split the TM up into 3 “valid” csv files….

“Thank you Mr Open Office” (for all who know the “Thank you Mr Hooker” girl from a local real estate agent's TV ad…)


Lingo24 is a global translation company, with interests in marketing, e-commerce, product management and many other areas that are of relevance to our clients. We share news on our company performance, innovative technology solutions, exciting new hires and guest posts from some of our translators.

Back To Top