Joystiq has your stash of criminally complete GTA IV news!

Mac Automation: automating Microsoft Excel 2008

This is the second part of Mac Automation: automating Microsoft Office 2008. In this how-to, I will show you how to create an importer for Microsoft Excel 2008. This importer will allow you to type text in TextEdit.app (or other text editor) and import it into an Excel file.

For this automation, you will need the following Automator actions (in the same order):
  • Create New Excel Workbook
  • Set Excel Workbook Properties
  • Get Specified Finder Items
  • Import Text Files to Excel Workbook
  • Save Excel Workbooks
Continue reading to learn how to automate this process.

Running the workflow
To run the workflow, just fill in the required information into the proper Automator actions. Specify information in the "Set Excel Workbook Properties" and "Save Excel Workbooks." In the "Import Text Files to Excel Workbook," select "Tab" under the "Delimiters" section -- this allows you to specify between columns/rows.

Next, let's look at how you need to format your text documents. When you are typing the data that you want to go in the spreadsheet, use a tab to separate the columns and a return to separate the rows. Your document should look similar to the one that I have created below. Note that I have a tab each time I want a new column and a return where I want a new row.

Be sure to save your text in the proper format! This Automator action requires that you save it as either: .txt, .csv, .htm, or .xml. Any other format will not work. I would recommend using a .txt format. Once you have your text saved, click the "Add" button in the "Get Specified Finder Items" action and navigate to your saved text file.

You can now click the "Run" button in the top-right corner of Automator. Your workflow will start working and create the new Excel workbook and import the text in the proper cells.



Saving the workflow
You can now save the workflow to your liking.

Application of this workflow
You can use this workflow to bridge the gap between someone that uses Excel and someone that doesn't. You can also use it to create Excel documents on-the-go on, say, an iPhone. Just e-mail yourself a document. You can use periods to denote new columns and line breaks to denote new rows. Reminder: if you use a different text formating for rows/columns, be sure to specify that in the "Import Text Files to Excel Workbook" action.

Related Headlines

Reader Comments (Page 1 of 1)

Add your comments

Please keep your comments relevant to this blog entry. Email addresses are never displayed, but they are required to confirm your comments.

When you enter your name and email address, you'll be sent a link to confirm your comment, and a password. To leave another comment, just use that password.

To create a live link, simply type the URL (including http://) or email address and we will make it a live link for you. You can put up to 3 URLs in your comments. Line breaks and paragraphs are automatically converted — no need to use <p> or <br> tags.

New Users

Current Users

TUAW Features

Mac 101 iPhone Around the Worldask-tuaw
Mac News
Macworld (497)
.Mac (36)
Accessories (624)
Airport (75)
Analysis / Opinion (1288)
Apple (1607)
Apple Corporate (545)
Apple Financial (185)
Apple History (38)
Apple Professional (49)
Apple TV (160)
Audio (440)
Bad Apple (119)
Beta Beat (146)
Blogging (87)
Bluetooth (15)
Bugs/Recalls (56)
Cult of Mac (868)
Deals (199)
Desktops (114)
Developer (203)
Education (93)
eMac (10)
Enterprise (126)
Features (369)
Freeware (358)
Gaming (344)
Graphic Design (15)
Hardware (1268)
Holidays (41)
Humor (584)
iBook (65)
iLife (237)
iMac (183)
Internet (302)
Internet Tools (1285)
iPhone (1334)
iPod Family (2017)
iTS (958)
iTunes (791)
iWork (18)
Leopard (355)
Mac mini (109)
Mac Pro (50)
MacBook (195)
MacBook Air (76)
Macbook Pro (214)
Multimedia (428)
Odds and ends (1412)
Open Source (270)
OS (889)
Peripherals (190)
Podcasting (181)
Podcasts (82)
Portables (195)
PowerBook (137)
PowerMac G5 (50)
Retail (569)
Retro Mac (47)
Rig of the Week (42)
Rumors (608)
Software (4195)
Software Update (393)
Steve Jobs (252)
Stocking Stuffers (55)
Surveys and Polls (96)
Switchers (110)
The Woz (34)
TUAW Business (225)
Universal Binary (280)
UNIX / BSD (60)
Video (907)
Weekend Review (73)
WIN Business (49)
Wireless (80)
XServe (35)
Mac Events
One More Thing (27)
Liveblog (0)
Other Events (231)
WWDC (180)
Mac Learning
Ask TUAW (95)
Blogs (85)
Books (23)
Books and Blogs (63)
Cool tools (442)
Hacks (462)
How-tos (479)
Interviews (33)
Mods (184)
Productivity (582)
Reviews (99)
Security (145)
Terminal Tips (56)
Tips and tricks (558)
Troubleshooting (159)
TUAW Features
iPhone 101 (23)
TUAW Labs (3)
Blast From the Past (17)
TUAW Tips (141)
Flickr Find (32)
Found Footage (68)
Mac 101 (80)
TUAW Interview (30)
Widget Watch (196)
The Daily Best (2)
TUAW Faceoff (4)

RESOURCES

RSS NEWSFEEDS

Powered by Blogsmith

Sponsored Links

The Unofficial Apple Weblog (TUAW) bloggers (30 days)

#BloggerPostsCmts
1Cory Bohon456
2Dave Caolo420
3Mat Lu363
4Michael Rose3219
5Erica Sadun300
6Scott McNulty271
7Brett Terpstra260
8Mike Schramm214
9Robert Palmer713
10Christina Warren617
11Steven Sande55
12Joshua Ellis31
13Chris Ullrich30
14Nik Fletcher22
15Lisa Hoover10
16Jason Clarke12
17Victor Agreda, Jr.13

Featured Galleries

Macworld 2008 Keynote
Macworld 2008 Build-up
Macworld Expo 2007 show floor
The Macworld Faithful in Line
iPhone First Look
iPhone 2.0 - .Mac push e-mail
iMac 1998
TUAW Faceoff: Screenshot apps on the firing line
Boston Apple Store (Boylston Street)

 

    Most Commented On (7 days)

    Recent Comments

    More Apple Analysis

    More from AOL Money and Finance

    Weblogs, Inc. Network

    Other Weblogs Inc. Network blogs you might be interested in: