Hi,
I can't seem to find how do import an excel file of auto text. I have a spreadsheet with a column of the abbreviation, and a column with the replacement text. I can't do it as a CSV because there are commas in the replacement text. Is there a way to import these? I ask because I have several hundred, and creating each one manually would be difficult.
Thanks,
Will
Import excel file?
FastKeys can read Phrase files - they are text files in following format
::abbreviation::replacement
You need to export the file from excel in this format. If you have the abbreviation in A1 cell and replacement in B1 cell, you just create another field with the formula:
="::" & A1 & "::" & B1
Replace formulas with values, Export to txt file to FastKeys/Phrase files folder (name it MyFile.fkp) and then load it into FastKeys using Insert/New file.
::abbreviation::replacement
You need to export the file from excel in this format. If you have the abbreviation in A1 cell and replacement in B1 cell, you just create another field with the formula:
="::" & A1 & "::" & B1
Replace formulas with values, Export to txt file to FastKeys/Phrase files folder (name it MyFile.fkp) and then load it into FastKeys using Insert/New file.