Frequently asked questions

Q: Why do you not provide Excel XLS files for your expanded databases?

A: The reason why we do not make the XLS format available for any of the expanded versions is due to a limitation of Microsoft Excel. Excel cannot cannot worksheets with more than 65,536 rows or 256 columns. Since all of our expanded databases contain over 73,000 records, it would be impossible to open or import an entire expanded database into Excel. This holds true regardless of what file format you purchase, meaning that purchasing one of the alternate file formats (CSV or MDB or DBF) will not give you different results. In other words, you cannot use an expanded version of our ZIP Code databases in Excel. Excel's ceiling prevents more than 63,636 records/rows in a worksheet.

 

If you have any additional questions, please contact us.

ZIPCode, ZIP, Mr. ZIP, Mister ZIP, Zippy, Mr. Zippy, database, files, software, import, excel, spreadsheet, access, usa, postal, post office, mailing, shipping, latitude, longitude, coordinates, distance, city, cities, state, preferred, usps

ZIP Code files, latitude, longitude, 5 digit, Zone improvement plan, history, coordinates, distance, city, cities, state, preferred, usps

Copyright 2001 by PC Shareware, Inc.