convert excel into filemaker pro database

Storing text clips in FileMaker also allows you to manipulate them before they are moved back on to the clipboard. Clipboard Explorer lets you capture whatever format your word processor uses to represent its text on the clipboard so that you don't have to worry about losing font information, indents, and so on. If you copied those pieces of text into a database, you could link them to keywords, categories, record the date different statistics were last updated, and so on.

Say you write grant proposals for your organization using a word processor and you often find yourself searching through previous grant proposals to find bits of wording or statistics to use in new grant proposals. When you're done editing, use Clipboard Explorer to convert the XML text back to script steps on the clipboard, then paste the altered script steps back into your script.Ĭlipboard Explorer preserves the formatting of data copied from almost any program, so you can create databases of:

Notice the words circled in blue in the XML match the same words in the original script. The XML looks different than regular script steps, but it contains the same information.

Next, use an example database that comes with Clipboard Explorer to view the script steps as 'XML' text that you can edit.

Convert excel into filemaker pro database