Re: Ottawa Open Data Excel files

[Edward Ocampo-Gooding]

On 2013-01-26, at 2:09 PM, nim....@simplebi.com wrote:

> I am noticing that Ottawa Open Data Excel files contain a lots of headers, City Logo (image) and merged cells for the title. Data from other cities seems to be much easier to work with. Are we able to get cleaner files for importing, ie cvs.

Yes, just ask :)

Ping Rob Giggey with as much info as possible (i.e. the data set and a reference in the file to what you need to not be there) so that he can pass on the message. Providing rationale for removing it also helps.

> Or are there any good ways to clean up these files in a generic / automated way without having to write a program or macro to handle each different file?

Probably not. This is more of a people problem than a technological one. Asking Rob is the way to go here.