Generate 10,000 Flare topic files in 7 minutes

Tired of setting up Flare topic files manually? Got enough work to last until Christmas next year? Keep reading and learn how you can use Excel to create 10,000 topic files in less than 7 minutes.

Click here to download an example spreadsheet.

Excel to Flare topics
Excel to Flare topics
  1. Set up or import your data to Excel (e.g. a list of topics).
  2. Set up the HTML column.
    • Remember the XML-declaration.
    • Use char(34) to replace quotation marks in the HTML code. 
  3. Set up the “escaped” HTML column using the SUBSTITUTE function.
  4. Set up the “DOS command column” with the ECHO command.
    • Remember to specify the destination path.
  5. Click & Drag to expand the formulas to all rows
  6. Copy-Paste from Excel to DOS.
    • All files are created in the folder you’ve specified.

Click here to download an example spreadsheet.

2 Replies to “Generate 10,000 Flare topic files in 7 minutes”

Leave a Reply

Your email address will not be published. Required fields are marked *