Fixing ZIP Codes and Missing 0's in CSV/Excel

Often, certain fields (like ZIP Codes) display correctly in Report Toaster but do not export correctly to CSV/Excel.

You may notice this problem when you open up the Excel file the field displays without the first 0s. 

This happens because Excel tries to convert what it sees as a Number, rather than interpreting it as Text. 

The solution is thankfully fairly straightforward. 

1.) Open up a blank excel file (or simply open up Microsoft Excel and start a blank workbook). 
2.) Go to the data tab, click 'From Text/CSV". 
3.) Browse to your original file location (probably downloads) and click Import. 
4.) A window should pop up that looks something like this:

As you can see you have several options for selecting the File Origin text type and Delimiter (typically, we found UTF-8 and Comma work best, but feel free to adjust as needed). 

Click the Transform data button at the bottom. This opens up the Power Query editor in a new window. 

5.) From here, click the column header for the row in question (Address / Zip). Make sure Data Type: Text is selected in the menu at the top. Notice that now the ZIPs are formatted correctly with zeros at the beginning?

6.) Once you're happy with it, click Close & Load (top left). This will result in a correct excel file. 

For more information about using Report Toaster, check out our FAQ or reach out to us at any time :)

• Related Articles

• Fixing Special Characters in CSV/Excel

  Often, non-English characters display correctly in Report Toaster but can become garbled when exporting the data to CSV/Excel. You may notice this problem when you open up the excel file and the non-English text appears to be garbled or poorly ...

• How Do I Export/Print a Report?

  Another entry in our 'Basics' series, this article will cover all your options for exporting a report in Report Toaster. For instance, say I wanted to save a copy of this report to my desktop? Or get a version of the data to excel so I can add ...

• Premium Report - Product Cleanup

  Product Cleanup This report is for merchants who are looking to update and cleanup their products in Shopify. Using this report, you can see exactly which products are missing which values, navigate directly to them in Shopify (click the hyperlink ...

• Report Toaster and Store Performance

  Some of the more keen-eyed among you may have noticed that Shopify recently made a change to the app store to help merchants identify which apps affect store performance.  This new 'speed tested' highlight clearly identifies which apps do and don't ...

• How Do I Schedule a Report?

  Another entry in our 'Basics' series, this article will cover how to setup a Scheduled Report in Report Toaster. Note - You must be on a paid plan of Report Toaster to have access to this feature. You can check out our app listing for more ...