Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 05-17-2016 20:48:46

Registered: 11-21-2010
Posts: 272
Website for Bulk Changes

From time-to-time I need to export a file to make bulk changes.  The problem with Excel is it changes the UPC code and other large numbers like the date stamp into scientific notation (exponential).  There's a clumsy multi-step way around it, Yuck!

I came across an oldie but goodie in Open Office.  It downloads the CSV file as text so it eliminates the undesired modifications that Excel makes.  If you export/import regularly, this free program is well worth the download.



#2 05-18-2016 07:19:33

From: York, PA
Registered: 04-20-2001
Posts: 19715

Re: for Bulk Changes

Thanks for the post.  Anybody using leading zeros for anything will generally have troubles with Excel.  We've had success manually importing and marking columns as text in Excel, but that's a pain and not something you'd want to do regularly.  Also had success with Google Sheets, but the interface is slow and clumsy.  I will definitely be checking out open office as I spend a lot of time adjusting CSV files in Excel prior to being able to work with them.

Nick Hendler



#3 05-18-2016 10:52:32

From: Fairview, PA
Registered: 11-19-2003
Posts: 549

Re: for Bulk Changes

Yes Open Office is definitely the way to go.  Plus the price is right (Free), and is nearly just as good as any MS Office product.

Last edited by Iceit88 (05-18-2016 10:52:46)


Hat Trick Sports, LLC



Board footer