---
schema_version: "1"
id: 5849e42a6731586640e4304012864569c4d58d0fba3688446f74d51c56921fbd
title: Upload an ETL File Manually
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_pers_etl_file_upload.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_pers_etl_file_upload.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 402ee85554f3d3ed5cd972dad2231807096e9db770aa0ce3d80e4845d377c581
description: ETL data feeds are commonly configured to automatically upload the ETL files using the SFTP site. However, you can upload files manually if, for example, you want to ingest data that doesn’t get updated frequently, or if you want to confirm the .CSV file format without committing changes.
products:
  - Marketing
  - Salesforce Personalization
release: "264"
---
# Upload an ETL File Manually

ETL data feeds are commonly configured to automatically upload the ETL files using the SFTP site. However, you can upload files manually if, for example, you want to ingest data that doesn’t get updated frequently, or if you want to confirm the .CSV file format without committing changes.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d63965e38">Permissions
              Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d63965e38 ">To upload an ETL file:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d63965e38 ">A role with Administrator permissions</td>

          </tr>
        </tbody>
      </table>

1. From the main navigation, select **Feeds** | **Feeds Dashboard**. The Feeds Dashboard opens in a new tab.
2. Select the desired ETL data feed from the list of available feeds.
3. Click **Validate** | **or** | **Execute**.
4. To select a file that you previously manually uploaded, click **Select File** and navigate to the **Testing** folder to select the file.
5. To select a new file to upload, click **Upload File** and navigate to the desired file to upload it. After the file successfully uploads, Personalization shows a confirmation message and the data appears in the File Data section.
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mc_personalization-264-0-0-production-enus/16bf1f60-f44c-4260-a56e-f052cfe515a3/images/icon_note.png)
    
    Note When uploading a new ETL file, make sure the file is in .csv format and that it meets the schema requirements for the selected ETL data feed.
6. In the **Review Staged Changes** section, click **Run Test** (not available for User ETL). Details about the file’s successes and errors appear.
    
     
    | Item | Description |
    | --- | --- |
    | **Extracted** | Indicates the number of rows that were successfully extracted from your file, and the number of rows that have errors. |
    | **Staged** | Indicates the number of rows that the file adds when you commit changes. |
7. Review any file additions, changes, and deletions below the **Run Test** button (not available for User ETL).
    
     
    | Row Appearance | Meaning |
    | --- | --- |
    | blue row | Indicates modified data to update. |
    | green row | Indicates new data to add. |
    | red row | Indicates data to remove. |
    | Rows without highlights | Have no effect on the existing data. |
8. To download a CSV file that indicates the data that the file affects, click the **Export** button.
9. To add the data to Personalization, click **Commit**.
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mc_personalization-264-0-0-production-enus/16bf1f60-f44c-4260-a56e-f052cfe515a3/images/icon_note.png)
    
    Note If you’re just testing an ETL file, don’t commit the data.