You cannot import data to a gauge in spreadsheet format. In PopChart Builder you will be given the following interface for manipulating gauges.
Because you cannot import data to a gauge in spreadsheet form, do not use the loadData() or setData() PopChart Embedder methods or the LoadFile() PCScript method with gauges. Instead you should use PopChart XML or the SetGaugeRange() and SetGaugeValue() PCScript methods.