Viewing exported CSV reports from PitneyTrack Inbound in Excel

When opening exported CSV reports in Excel, Excel auto-formats the cells, which can cause data to be displayed incorrectly. To view exported reports with the data formatted correctly, the file must be imported instead of opened.

The features and options you see may vary depending upon your role and subscription. If you have any questions regarding your permissions, please contact your administrator.

1. Export the report from PitneyTrack Inbound in CSV format.
   Important: Do not open the file yet.
2. Open Excel and open a new blank workbook.
3. Select the Data tab.
4. Choose Get External Data > From Text or From Text/CSV.
5. Choose the CSV file that you exported in step 1 and click Open.
6. In newer versions of Excel, a window opens with the file name at the top and the data as shown below. Make sure that the Delimiter is set to Comma, then click Load.
   
7. In older versions of Excel, the Text Import Wizard opens:
   1. In step 1 of 3, choose Delimited and check the My data has headers. box, then click Next.
      
   2. In step 2 of 3, check the Comma box and uncheck the Tab box, then click Next.
   3. In step 3 of 3, in the Data preview section, select each column by clicking the column heading, then select Text under Column data format. Once this is done, the column heading in the Data preview window will say Text. Be sure to scroll side to side and make sure this is done for all columns.
      
   4. Click Finish.
   5. In the Import Data window, leave Existing worksheet selected and click on the square icon in the field below the radio button, then click OK.
8. Save the file as an XLSX file.