To translate a CSV file, you translate the text in each cell while keeping every row, column, comma and quote mark where it was, so the file still imports cleanly. The usual case is a product catalog exported from a shop, a table of app strings, or a data export someone needs in another language. This guide covers how to prepare the file, the mistakes that make imports fail, and the quickest way to translate it.
What Makes CSV Files Tricky to Translate
A CSV (comma-separated values) file is a table saved as plain text: one line per row, commas between the columns, and quotes around any cell that contains a comma itself. That simplicity is the problem. Paste it into a translator and a sentence with a comma in it can end up split across two columns, a quote mark gets “corrected” into a curly one, and the import fails on row 312.
How to Translate a CSV File, Step by Step
- Decide what should be translated. Product names, descriptions and categories, yes. SKUs, prices, IDs, image URLs and URL handles, no.
- Make a translation copy. Keep only an ID column plus the text columns, so nothing else can be changed by accident. You’ll match the rows back by ID afterwards.
- Translate the text cells with a tool that reads CSV as a table, not as one long block of text.
- Save as UTF-8. It’s the only encoding that reliably handles every language’s letters.
- Merge and import. Put the translated columns back next to the untouched ones and import a few rows first to check.
Mistakes That Break a Translated CSV
- Splitting cells. A comma inside an unquoted cell becomes a new column, and everything after it shifts.
- Translating identifiers. A translated SKU or URL handle creates a new product instead of updating the old one.
- Round-tripping through Excel. Opening and saving a CSV in Excel can strip leading zeros, turn codes into dates and change the encoding. Open the translated file in a text editor if you need to look at it.
- Wrong encoding. Accented letters and non-Latin scripts turn into question marks or garbage when the file isn’t saved as UTF-8.
- Running out of room. German and French often run a quarter to a third longer than English. Check fields with a character limit, such as product titles or meta descriptions.
How to Translate a CSV File with Taia
Taia is an online translation platform that reads CSV files as tables, so it translates cell by cell and gives you a CSV back.
- Upload the .csv file at translate.taia.io and pick your target languages.
- Choose AI or a professional translator. AI translates a catalog of thousands of rows in minutes. A professional linguist reviews and edits it when customers will read every word.
- Download the translated CSV and import it.
What it takes care of for you:
- Rows and columns stay in place. The file is parsed as a table, so a quoted cell with a comma in it stays one cell.
- You get a CSV back, in the same shape as the one you uploaded.
- Your terminology stays consistent. On Pro, a glossary keeps product names and technical terms the same in every row, and translation memory reuses the wording you approved last time.
One thing to know: every cell is sent for translation, the header row included, and that means SKUs, IDs and URL handles too. Upload a copy with just an ID column and the text columns (as in step 2 above).
How Much Does It Cost?
CSV files are included from the Basic plan, €9/month for 20,000 credits (20,000 words with Standard AI). Pro is €39/month for 100,000 credits (100,000 words with Standard AI) and adds translation memory and glossary. Professional translation is billed per word from €0.06, with no subscription. If your catalog has formulas or formatting, the Excel guide is the better fit.
Frequently Asked Questions
Can I translate a CSV file with Google Translate?
Not as a file. Google Translate’s document upload doesn’t accept .csv, so you’d paste the text in and then rebuild the table by hand, which is exactly where columns get shifted. A tool that reads CSV as a table keeps the structure for you.
How do I translate only some columns of a CSV?
Make a copy with just an ID column and the columns you want translated, translate that, and merge the results back by ID. It’s the simplest way to make sure SKUs, prices and URLs can’t change.
Why do accented letters look wrong in my translated CSV?
The file was opened or saved in the wrong encoding. Save it as UTF-8, and if Excel still shows garbage, import it through Excel’s data import and choose UTF-8 there instead of double-clicking the file.
Which Taia plans include CSV translation?
Basic, Pro and Enterprise. The upload screen shows exactly which formats your plan accepts.
How much does it cost to translate a CSV file?
With Taia, from €9/month on Basic, which includes 20,000 credits (20,000 words with Standard AI). Professional translation is billed per word from €0.06, with no subscription.