Viewing SendSuite Tracking Online exported CSV reports in Excel

When opening exported CSV reports in Excel, it 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.
Products affected: SendSuiteĀ® Tracking Online
When opening exported CSV reports in Excel, it 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.
  1. Export the report from SendSuite Tracking Online 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 shown below:
    excel-import-csv-newer_500x375
    1. 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.
      excel-import-csv-older_500x381
    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.
      ExcelImportWizard-step3-edited_500x381
    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.

UPDATED: August 14, 2021

Contact Us
Live Chat
Available • Closes at 8pm ET
Sales team hours are 8am-6pm ET
Live Chat
Live Chat is currently unavailable.
Chat is available Mon-Fri, 8am-8pm ET
Create a case
Submit support requests (Sign in required)