Publishers of technology books, eBooks, and videos for creative people

Home > Blogs > Creating a Microsoft Excel 2008 Automator workflow

Creating a Microsoft Excel 2008 Automator workflow

Today’s Office 2008 Automator workflow is for Excel. This workflow will retrieve a list of selected tracks in iTunes. It will then create a formatted and sorted list of the names of those tracks in a new Excel workbook and save that workbook in HTML format. You could then incorporate the HTML into your Web site to display a list of your favorite iTunes tracks.

To build the workflow, locate the following actions in Automator, drag them to the workflow area, and configure them as shown. If you have any trouble, don’t worry. You can download the completed workflow here.

1. Get Selected iTunes Items (in the Music or iTunes category).


2. Filter Paragraphs (in the Text or TextEdit category).


3. Copy to Clipboard (in the Utilities or System category).


4. Get Specified Text (in the Text or TextEdit category).


5. Create New Excel Workbook (in the Documents or Microsoft Excel category).


6. Paste Clipboard Content into Excel Workbooks (in the Documents or Microsoft Excel category).


7. AutoFormat Data in Excel Workbooks (in the Documents or Microsoft Excel category).


8. Sort Data in Excel Workbooks (in the Documents or Microsoft Excel category).


9. Save Excel Workbooks (in the Documents or Microsoft Excel category).