Excel 2007: How to Import Data From One Excel Sheet to Another

by Stephen Lilley

In computing terms, a "spreadsheet" is a type of large table that is used to display information. Microsoft Excel 2007 is just one of the many programs that is capable of creating and working with these spreadsheets. If you have one spreadsheet that you'd like to import into another spreadsheet document, you can do so using Microsoft Excel 2007's feature specifically for this purpose.

1

Click "Start," followed up by "All Programs." Click on the "Microsoft Office" folder in this menu, followed by "Microsoft Excel 2007." Microsoft Excel 2007 will now be open on your monitor.

2

Click on the "Office" button and then "New." This will create a new blank Excel spreadsheet document in the Excel program window on screen.

3

Click "Data" in the Excel 2007 "Ribbon" toolbar. Click "From Text" from the "Get External Data" portion of the "Data" tab on screen.

4

Locate the Excel spreadsheet on your computer's hard drive that contains data you'd like to import into your new document and double click it. This will open a Excel 2007 utility called the Text Import Wizard.

5

Pick the row in your spreadsheet document where the data you'd like to import starts. Click "Next" to continue. Use the next screen to create any "break lines" (horizontal spaces between blocks of data) you need in your imported data and click "Next" to continue. Choose the column data format for your imported data from the following screen and click "Next" to continue. Select a position on your blank spreadsheet document where you'd like your data imported and click "OK." Your data will now be imported from one Excel spreadsheet to another.

About the Author

Stephen Lilley is a freelance writer who hopes to one day make a career writing for film and television. His articles have appeared on a variety of websites. Lilley holds a Bachelor of Arts in film and video production from the University of Toledo in Ohio.