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 ...

• Whats New? - September 2024

  Autumn is here, and with the start of the busy holiday season we can showcase some incredible new reports. Let's take a look! ABC Inventory Report Thanks to the recent development of formula fields in Report Toaster (essentially a special calculated ...

• How to Determine Names for Location ID/Staff ID

  Some of you may have noticed the columns for Location ID or Staff ID on our various POS reports (e.g. Sales by POS Location). Using these fields, you can see your Sales at each of your retail locations and have the totals broken down to each specific ...