Import excel file?

Suggestions, feature requests and bug reports.
willhs

Import excel file?

PostPosted by willhs » Tue Jul 05, 2016 10:24 pm

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

User avatar
Posts: 100
Joined: Tue Nov 24, 2015 11:39 pm

Re: Import excel file?

PostPosted by Tom » Wed Jul 06, 2016 1:45 pm

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:
Code: Select all
="::" & 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

Re: Import excel file?

PostPosted by willhs » Mon Dec 12, 2016 6:25 am

Brilliant! Thank you so much!


Last bumped by Anonymous on Mon Dec 12, 2016 6:25 am.

Return to Suggestions

Who is online

Users browsing this forum: No registered users and 0 guests