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 :)
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 ...
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 ...
How to Use Calculated Fields
In this article, we look at how you can use Calculated Fields to generate better reports for your storefront. Note: Calculated Fields are created by our Report Toaster staff. Please contact firstname.lastname@example.org with the details and we will take care ...
Didn't find what you were looking for in our knowledge base? Click here
to suggest an article, and we'll try to put something together for you.