Why is Excel Changing my Exported Data?

When exporting data that contains dashes or forward slashes from the MarketPush, we've found that Excel automatically converts certain data into dates, causing a change in the cell value. For example, if the cell originally contains "6-3460," it will be exported as "6/1/3460."

To ensure the correct import of your product template, you need to adjust the format of the column(s) that contain the product or manufacturing part number from "General" to "Text" in Excel.

If you have already imported the file without updating the column format as mentioned above, you can follow these step-by-step instructions:

1. Navigate to the Products Page
2. Click on the Download Offer Template button
3. Open a new blank Excel spreadsheet.
4. Click to the Data tab in ribbon banner selection
5. On the far left corner of your Excel spreadsheet, click on "Get Data (Power Query)" as shown below
   
   
6. A new screen called "Choose Data Source" will appear
7. Select the "Text/CSV" option, as shown below.

   
   

8. Another screen titled "Connect to Data Source" will pop up. Click on the "Browse" button and select the downloaded file
   
   
9. Once the file name displays on the screen next to the Browse button, in the lower right corner, click the "Next" button in the lower right corner
10. A Preview of the file will open.  Click the "Transform Data" button in the lower right corner of the spreadsheet next to the "Load" button
11. The Power Query Editor for the file will be displayed. In the top left corner of the spreadsheet, under the home button, click on "Close & Load" as shown below
    
    
12. Your spreadsheet will now open and display the correct cell data as originally entered when importing your product and/or offer spreadsheet.