# Excel – How to add / upload bulk entries to Excel 2010 Autocorrect

microsoft-excel-2010vba

I currently have about 200 entries of autocorrect but it's painful to add one by one manually to "autocorrect" (File > Options > Proofing > AutoCorrect Options > AutoCorrect tab). These entries are phrases for long piece of text e.g. ROI = Return Of Investment etc.

Is there any way to upload these entries quickly ?

• You will need to add them to the .acl file as explained in this KB.
To use your AutoCorrect entries on another computer (or to share them with another user profile on your computer), locate the .acl files in the %AppData%\Microsoft\Office folder. (You can type the path in Windows Explorer exactly as shown here and the %AppData% environment variable will automatically expand to the full path. In Windows 7, that path is C:\Users\username\AppData\Roaming\Microsoft\Office by default, but it might be different on your computer.)