Fix corrupted accented names in a payroll CSV

Accented employee names can turn into strings such as José instead of José when a payroll CSV is opened or transferred. The wrong characters can cause confusion in records, but changing names in a payroll file also carries a risk of altering other data.

First work out whether the characters are only displaying incorrectly or have been changed in the file itself. Then correct only the affected name fields and check the saved copy before handing it off. The CSV Editor can open a CSV, find entries, and edit cells in your browser. Files stay on your device.

Check and correct the names

1. Make a separate copy of the original payroll CSV. Open the copy in the CSV Editor, not the file you plan to keep as your untouched source.
2. Find a name that looks wrong and compare it with a trusted source, such as the employee record in your payroll system. For example, José might be intended to read José, but do not guess based on appearance alone.
3. Check whether the problem affects just a few names or many accented characters. Look for patterns such as é where you expect é, and note which rows and fields need attention.
4. Edit only the affected name cells. Keep employee IDs, pay amounts, dates, and other columns unchanged. If a name is uncertain, confirm it with the authoritative employee record before editing.
5. Save or export the corrected copy, then open that saved file again. Check the corrected names and compare key payroll fields with the original before sending it.

If you need to inspect more than the names, the CSV Editor can also help you find values in a large file. For a broader explanation of odd character sequences, see How to fix strange accent characters in a CSV.

What the result means

The saved file shows the names correctly

If the accented names look right after you reopen the saved copy, the correction was written into the file as expected. Still compare employee IDs and payroll values, because a name that looks correct does not prove the rest of the file is unchanged.

The names look wrong in one program but right in another

The characters may be stored correctly but interpreted or displayed differently by the program opening the CSV. A CSV is plain text and does not reliably tell every program which character encoding to use. Encoding is the rule a program uses to turn stored bytes into letters. If the receiving payroll system imports the file with a different rule, names can appear corrupted there even when they looked fine in your editor.

The same wrong characters appear in the saved file everywhere

The text may already have been altered, rather than merely displayed incorrectly. Replacing the visible characters manually can fix a small number of confirmed names, but it will not reliably restore a large set of names without an authoritative source.

Accents appear as boxes or question marks

This may indicate that a program cannot display or interpret the characters, or that the underlying text was replaced during an earlier import or export. Check the file in another program and compare it with the source record. A font issue can hide a character on screen, but it cannot restore data that has been replaced in the file.

How to prevent the corruption

1. Keep an untouched original. Make a copy before correcting or importing a payroll file. This gives you a reliable reference if a later step changes names, separators, or values.
2. Export again from the source system when possible. If the payroll or HR system still has the correct names, create a fresh CSV from that source instead of repairing dozens of damaged names by hand. Choose a UTF-8 CSV option if the export offers one, and check the receiving system's import instructions.
3. Set the character encoding during import. Some spreadsheet programs guess how to read a CSV when you open it directly. If the program offers an import option for character encoding, choose the same encoding used by the export, commonly UTF-8. Import choices vary by program and version, so follow the instructions for the software you use rather than relying on a single menu path.
4. Do not use a font change as a data repair. A different font can change how letters look, but it does not fix text that has already been converted into the wrong characters. Confirm the actual name in the source record.
5. Check the file after every transfer. Reopen the final CSV in the program that will receive it, or use a test import if your payroll process supports one. Verify a few names with accents from different parts of the alphabet, not just one example.
6. Compare important payroll fields. Check that row counts, employee IDs, dates, and pay amounts still match the approved source. Pay particular attention to leading zeros in IDs and values that may be interpreted as dates or numbers by spreadsheet software.

When manual correction is not enough

If many names are corrupted and you cannot confirm the original spelling, stop before sending the file. Ask the person responsible for the employee records or payroll export for a clean copy. Reconstructing names from damaged characters can produce incorrect legal or payroll records.

Also check with the payroll recipient about its required CSV format. It may require a particular encoding, column order, or delimiter. A delimiter separates columns, often a comma or semicolon. Changing that format without confirmation can make a correct file difficult to import.

For payroll data, keep the original and corrected files in an approved secure location, and share only the version the recipient needs.