How to export Microsoft Word Autocorrect to a file and then import it into Type Pilot

How can I import phrases from Microsoft Word autocorrect or from an Excel spreadsheet or at least rapidly make up a large database of phrases?

You can import the file with common phrases of Microsoft Office 365 (year 2022). This file is located here; see Autocorrect.

However, you might want to create your own Autocorrect file, for example if you want to use Autocorrect from a most recent MS Office version, or if you use a different language. Please see the instructions below.

For this tutorial, we will be using Word for Microsoft 365. These steps might be similar in some older versions of Word. However, your interface may look different than the interface shown here.

1. Open a blank document in MS Word.

2. Click View -> Macros (or Alt+F8)

Click View Macros

3. In the “Macro name” window, type the name of the macro: ExportAutocorrect. Click “Create”.

Create a Macro

4. The VBA editor will be invoked. Now paste the following codes there:

Sub ExportAutocorrect()
Selection.WholeStory
Selection.Delete Unit:=wdCharacter, Count:=1

Selection.TypeText Text:="[MSOfficeAutocorrect]"
Selection.TypeParagraph
Dim acEntry As AutoCorrectEntry

For Each acEntry In AutoCorrect.Entries
  Selection.TypeText Text:=acEntry.Name + "=" + acEntry.Value
  Selection.TypeParagraph
Next acEntry

ActiveDocument.SaveAs FileName:="ExportMSOfficeAutocorrect.ini", FileFormat:=wdFormatText _
    , LockComments:=False, Password:="", AddToRecentFiles:=True, _
    WritePassword:="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts:=False, _
    SaveNativePictureFormat:=False, SaveFormsData:=False, SaveAsAOCELetter:= _
    False, InsertLineBreaks:=False, AllowSubstitutions:=False _
    , LineEnding:=wdCRLF

End Sub

5. Click “Run” (or press “F5”) to run the macro.

The list of Autocorrect phrases will be created in the opened document. It will then automatically be saved in “\Documents\ExportMSOfficeAutocorrect.ini” file.

6. Open the main window of Type Pilot, select menu File -> Import…

Import Autocorrect into Type Pilot

select INI-files (*.ini) Type and select the path to the ExportMSOfficeAutocorrect.ini file. Click “Open”.

The phrases will be imported into Type Pilot.

 

– Type Pilot F.A.Q. –

– Type Pilot main page –