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

Importing Data

Microsoft Graph makes it easy to insert data from other sources, such as a plain text file or a Microsoft Excel worksheet. You have control over how much of the data in a file you want to insert, and, in the case of an imported text file, you can indicate how Graph should arrange your data once it is imported.

Import Data into the Datasheet

In Microsoft Graph, click the View Datasheet button on the Standard toolbar.

Click the cell where you want the data to begin.

Click the Edit menu, and then click Import File.

Double-click the file that contains the data you want to import.

If you are importing a text file, follow the Text Import Wizard steps. If you are importing Excel worksheet data, select the sheet that contains the data you want to import in the Import Data Options dialog box.

  • To import all the sheet data, click the Entire Sheet option.

  • To import only a range, click the Range option, and then type the range of data. For example, to import cells A1 through C10, type A1:C10.

  • If you selected a cell in step 2, clear the Overwrite Existing Cells check box.

Click OK.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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