Skip to main content

Translation Error message while exporting/Importing contacts from outlook using csv Format.

Problem:
You may receive a Translation Error message, telling you that a file error occurred in the translator While exporting contacts from Hotmail or Outlook.com website in CSV format and import into Outlook, Note: this error is not limited to CSV files exported from Outlook.com or Hotmail.
Translation Error:
A file error has occurred in the Comma Separated Values translator while initializing a translator to build a field map.
Outlook was unable to retrieve the data from the file "E:\Downloads\WLMContacts.csv". Verify that you have the correct file, that you have permission to open it, and that it is not open in another program.
This is the result of the exported file's Unicode encoding. When the CSV is opened in Excel, all of the comma-separated fields are shown in one cell, not one cell per field. Excel can’t detect the field separators and neither can Outlook.
Note: If you have opened the file in Excel to look at it, close it without saving.
Solution:
Open the CSV file in Notepad and use File, Save as then select ANSI from the Encoding dropdown and Save using the existing file name.
Save CSV using ANSI format
Unicode format causes error
Note:to open using Notepad when Excel is set as the default, right click on the CSV file and choose Open with... from the context menu. Choose Notepad from the menu. If Notepad is not listed, select Choose default program to open the application picker dialog. Deselect the Set as default option from the Choose program dialog before selecting Notepad.

Popular posts from this blog

Setup cannot find office.en-us\dwtrig20.exe during office installation

Problem: 

Setup cannot find office.en-us\dwtrig20.exe during office installation

Solution:

Method 1:

a) Uninstall skype form control panel.

b) After installing office, re-install skype.

Method 2:
a) Browse disk by right clicking on it with mouse.
b) Double click on setup.exe file from the same location.

Method 3:
Note: Take backup of your registry before modifying it. 
For registry backup: open "run" >> type "regedit" >> goto "file" >> click on "export" on desktop.

a) Edit the registry.
HKEY_LOCAL_MACHINE > SOFTWARE > MICROSOFT > OFFICE Delete the keys (items) you find in the OFFICE folder but not the sub-folders. This removes traces of previous installs to avoid possible conflicts when installing the new version of Office.

b)HKEY_LOCAL_MACHINE > SOFTWARE > MICROSOFT > OFFICE > DELIVERY > SOURCEENGINE > DOWNLOADS
Delete the keys (items) you find here.

Excel 2013 right click doesn't work in spreadsheet.

Problem:

Excel 2013 right click doesn't work in spreadsheet.

Solution:

Check if excel works in safe mode.
1. Hold Windows key + R.
2. Copy and paste, or type the following command in the Open box, and then press Enter:
Excel /safe

Note: There is space between Excel and / If Excel safe works, disable the add-ins following steps mentioned below and determine the problem causing add-in: 
Try deleting following key from registry.
Excel 2007. Go to regedit and delete Options entry from HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\ and verify the result.
Note:
• Hold Windows key + R.
• Copy and paste, or type the following command in the Open box, and then press Enter:
regedit
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options
right click on Options and delete it.
Note: Ensure to back up the registry before any modification or deletion.
a) Locate and click the key or subkey that you want to back up.
b) Click the File menu, and then click Export.
c) In the Save in box, select the locati…

Word cannot start the spelling checker in Office MAC.

Problem

When you open a certain document in Word for Mac 2011, you get the following error:

“Word cannot start the spelling checker. The spelling checker files may be missing. Make sure the spelling checker files are installed or use the Microsoft Office Installer to install the spelling checker.”

Cause

The document may have been originally created from another version of Word and contain incompatible formatting.

Solution

If you cannot quit Word:
Press cmd + alt + Esc to show the Force Quit window.
In the list, click Microsoft Word.
Click the Force Quit button.

Update Microsoft Office 2011:
Open Word.
On the top menu, click Help, then Check for Updates.
Click the Check for Updates button.
Install all available updates until there are no more.

If that doesn’t work:
Open a blank document in Word.
On the top menu, click Word, then Preferences.
On the first row, click Spelling and Grammar.
Under the Spelling heading, uncheck “Check spelling as you type”.
Under the Grammar heading, uncheck “Check grammar as y…