Adam - this sounds like you have been given a heavily-formatted spreadsheet designed to be presented to and read by humans...i.e. the spreadsheet you have is not really a complete, proper data set/data feed with all values (or nulls) explicitly supplied for all fields.

Omniscope cannot really automatically create data structure where none exists, unless you can write formulae that 'fill-in-the-blanks' deductively by inspecting other fields in the row. In general, Omniscope does not really need to import most summary level data, since the summary level values should be re-producible inside Omniscope from the only the granular data.

The Omniscope DataManager File import block gives you a lot of options for importing selectively from heavily-formatted 'presentation' spreadsheets, but if some headings need to be copied/pasted in the spreadsheet to ensure completeness, then either you or the person supplying the spreadsheet need to do this.

Hi TJ,

Yes i was aware of the import features the other issue with this is that i am batch appending something like 400 files which takes a very long time to load and doesn't manage very well with loading a mix of .xls and .xlsx.

I think i am going to have to come up with a creative formula in omniscope to fill in the blanks as doing it manually is not an option atm.

Thanks