When I export data from inFlow On-Premise, the leading zeroes are getting lost. Help!

Please note: we will sunset inFlow On-Premise on July 31, 2024. After sunset we will stop selling or activating new licenses for inFlow On-Premise and stop providing support (including online KB articles).

In the meantime we will still provide technical support to customers with an active Support Plan.

For example, you might have a Product named “007” in your product list. At some point you may have clicked Main Menu > General > Export Data to save your products to a CSV file. Then when you open the CSV file in Excel, you see it just showing up as “7” and wonder if there is some secret agent modifying your products.

Actually, what’s going on here is that inFlow On-Premise is correctly exporting “007” (you can check this by opening the .CSV file in a text editor like Notepad), but Excel interprets this as a number, and simplifies the display by showing it just as “7”.

There are two workarounds, shown below:

Modify your data so that Excel can’t interpret it as a number

If instead of naming your product 007, you named it 007* or 007-BOND, Excel wouldn’t be able to misinterpret it as a number to be simplified, and this would get around the issue.

Of course, this would require that you rename things in inFlow, and this isn’t possible in some cases, most notably for barcodes that start with 0.

Use Excel’s Data Import Wizard

Instead of opening the CSV file just by double-clicking on it, you can use another method in Excel. (Instructions for Excel 2013)

  1. Open a new empty document in Excel.
  2. Go to the Data tab, then click Get External Data > From Text.
  3. Select your CSV file.
  4. Excel’s Text Import Wizard should show up. Select the file type Delimited, and click Next.
  5. Check the Tab and Comma box under Delimiters, and under Text qualifier, select the (double) quotation mark. Click Next.
  6. Click on each column that you’re having a problem with, then set the Column data format to Text.
  7. Click Finish. When Excel asks you where to put the data, you can insert it into the Existing worksheet.
inFlow Inventory
Archon Systems
260 Carlaw Ave #397
Toronto, ON, M4M 3L1
May 11, 2018

Rate this article

Not enough ratings yet
1 star2 stars3 stars4 stars5 stars
  • Did this article help? If not, please let us know so we can improve it.

  • This field is for validation purposes and should be left unchanged.