Import excel file?

willhs · Post by **willhs** » Jul 5th, ’16, 23:24

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

Post by **Tom** » Jul 6th, ’16, 14:45

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.

willhs · Post by **willhs** » Dec 12th, ’16, 06:25

Brilliant! Thank you so much!