Andrew Pollack's Blog

Technology, Family, Entertainment, Politics, and Random Noise

What is it that makes people think "Excel Format" is a standard for transferring data?

By Andrew Pollack on 09/28/2005 at 12:39 PM EDT

What follows is the text of an actual response I sent to an associate of mine after reviewing a response to questions we had on an RFP. I had asked what kind of format we could expect to see for the regular updates of data to be sent to us.

Only comment --

Why do sales and marketing people always think "Excel format" is "very easy to work with"? Its not. Its the least likely to be stable, reliable, and always formatted the same way. It is the data format equivalent of crayons on waxpaper. It almost always has column headers in the same columns as row data, and is almost impossible to reliably machine process.

Grr. I've been dealing with the exact statement since at least 1992.

Anyway -- as with other clients, the lack of a formally defined (standardized, documented) file for data transfers makes the import process subject to potential costly project creep. Please be aware of this.

There are  - loading -  comments....

crayons on wax paper...By jonvon on 09/28/2005 at 01:30 PM EDT
LOL!!! crayons on wax paper... too funny!! too true!!!!
Completely Agree But...By Chris Whisonant on 09/28/2005 at 03:23 PM EDT
I agree with that - sometimes Excel data is HORRIBLY formatted (especially if
you have to import data...). BUT, a properly formatted spreadsheet is very
useful for getting data. I'm working on a project and someone gave me a floppy
disk with the "file" of prospective customers.

I get it back to the office and it's an HTML file that just points to the
organizations website of members. There's no way to get them imported easily
that way. It's just a website with a listing of Business name, address, and
phone number. Good grief - I would take an Excel file anyday! =)
My own thoughts on this are...By Tom on 09/29/2005 at 11:58 AM EDT
Yeah, I'm with Chris on that one- most of the common alternatives to Excel are
way worse. When someone tells me they have a spreadsheet with the data in it,
I'm usually relieved.

Sure, a one time dump maybe. But on a regular, automated basis?By Andrew Pollack on 09/29/2005 at 08:46 PM EDT
You may as well send smoke signals. Why not just take a photograph of a
monitor showing the data, then print a copy of the photo and send it through a
cheap fax machine?

Other Recent Stories...

  1. 01/26/2023Better Running VirtualBox or VMWARE Virtual Machines on Windows 10+ Forgive me, Reader, for I have sinned. I has been nearly 3 years since my last blog entry. The truth is, I haven't had much to say that was worthy of more than a basic social media post -- until today. For my current work, I was assigned a new laptop. It's a real powerhouse machine with 14 processor cores and 64 gigs of ram. It should be perfect for running my development environment in a virtual machine, but it wasn't. VirtualBox was barely starting, and no matter how many features I turned off, it could ...... 
  2. 04/04/2020How many Ventilators for the price of those tanks the Pentagon didn't even want?This goes WAY beyond Trump or Obama. This is decades of poor planning and poor use of funds. Certainly it should have been addressed in the Trump, Obama, Bush, Clinton, Bush, and Reagan administrations -- all of which were well aware of the implications of a pandemic. I want a military prepared to help us, not just hurt other people. As an American I expect that with the ridiculous funding of our military might, we are prepared for damn near everything. Not just killing people and breaking things, but ...... 
  3. 01/28/2020Copyright Troll WarningThere's a copyright troll firm that has automated reverse-image searches and goes around looking for any posted images that they can make a quick copyright claim on. This is not quite a scam because it's technically legal, but it's run very much like a scam. This company works with a few "clients" that have vast repositories of copyrighted images. The trolls do a reverse web search on those images looking for hits. When they find one on a site that looks like someone they can scare, they work it like ...... 
  4. 03/26/2019Undestanding how OAUTH scopes will bring the concept of APPS to your Domino server 
  5. 02/05/2019Toro Yard Equipment - Not really a premium brand as far as I am concerned 
  6. 10/08/2018Will you be at the NYC Launch Event for HCL Domino v10 -- Find me! 
  7. 09/04/2018With two big projects on hold, I suddenly find myself very available for new short and long term projects.  
  8. 07/13/2018Who is HCL and why is it a good thing that they are now the ones behind Notes and Domino? 
  9. 03/21/2018Domino Apps on IOS is a Game Changer. Quit holding back. 
  10. 02/15/2018Andrew’s Proposed Gun Laws 
Click here for more articles.....

pen icon Comment Entry
Your Name
*Your Email
* Your email address is required, but not displayed.
Your thoughts....
Remember Me  

Please wait while your document is saved.