Choosing Columns to Load When Uploading Files


When using Get Data to upload a file, you can choose which columns will be loaded to the target database or data store, so you only load the columns you need.

Choose Columns to Load

When uploading an Excel or delimited file, you can choose the columns that you want to be loaded.

  1. Upload an Excel or delimited file using Get Data.

    The Preview page displays, as shown in the following image.

  2. Click the Choose Columns icon .

    The Choose Columns dialog box displays.
     
  3. Clear the check boxes for the columns you do not want to be loaded, as shown in the following image. All columns are selected by default.

    You can return the columns to their original selected settings by clicking Reset to defaults.

  4. Click OK.

    The Preview page displays, and shows only the columns you want to be loaded, as shown in the following image.

    You can click the Choose Columns icon again to change which columns you want to be loaded.

  5. Click Load to load your data.