• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 10. Advanced Excel and Web Features > Saving Data to Use in Another Applic...

Saving Data to Use in Another Application (Exporting)

With the worksheet that contains the data you want to save for export displayed onscreen, open the File menu and choose Save As to open the Save As dialog box.

The Save As dialog box opens. Click the down arrow next to the Save as type field and choose Text (Tab delimited) from the list that appears.

Type a name for the file in the File name field (or keep the current workbook name) and click the Save button.

Excel notifies you that only the active worksheet—not the entire workbook—will be saved in the manner you've specified. Click OK.

INTRODUCTION

You might find that the data you've entered into your worksheet would be useful in another Office application. For example, you might want to upload the regional sales data you've entered in to Excel to an Access database (which has more extensive reporting tools), or use it in a Word mail merge. Thanks to Excel's exporting capabilities, you can. In this task, you'll learn how to save your Excel worksheet data in a tab delimited format that other applications can use, and to see what that data looks like in another application (here, Word). (Delimiters are the items that separate one field of data from the next, and can be tabs, semicolons, commas, spaces, or other types.)


TIP

Exporting workbooks

To export an entire workbook, you must save each worksheet in the workbook individually if you want them to be tab delimited.


Excel warns you that the worksheet might contain some features (such as formatting) that cannot be retained when the sheet is saved in the new format. Click Yes to continue.

In another application, for example, Microsoft Word, open the File menu and choose Open.

The Open dialog box opens. Click the down arrow next to the Files of type field and choose All Files from the list that appears.

Double-click on the file you saved in step 3 to see what the tab-delimited file looks like in Word.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint