Select Page
Common searched topics: Manufacturing, Label printing, Sales order
Browse features guide
Managing products
Label printing
Reordering and forecasting reports
Imports, exports & integrations
Stock level reports
inFlow settings
Imports, exports & integrations
  • Exporting
Export help: Zeroes are removed

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

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 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 From Text/CSV.
  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.60916240_2
  6. Click on each column that you’re having a problem with, then set the Column data format to Text.60916240_3
  7. Click Finish. When Excel asks you where to put the data, you can insert it into the Existing worksheet.
Was this guide helpful?
Yes, thanks!
Not really
Thank you for your input, your feedback is important to us!


Submit a Comment

Your email address will not be published. Required fields are marked *

In this tab
  • Modify your data so that Excel can’t interpret it as a number
  • Use Excel’s Data Import Wizard
Similar articles

A complete guide on how to set up inFlow.

Get advice and answers from the inFlow Support team