I am not sure but i think you wrong spelled. If it is speled as sugoi, it means amazing or a salng term of suge which also means amazing.

Its actually spelled "sUgoi" And it means "Thats so cool/awesome!" Thats what my native japanese friend Jennifer Konda said.
Hope I helped :D

Thanks for the correction.

Depends on how it is said and the content in the sentence.

It can mean "That is good/awesome/etc" But it can also be used in a negative way.

Again, depends on the content and how it's being used.

where did you listen to it.i want to know

Read the context. You'll find the answer you seek.

As with many Japanese words it is context
Meaning is fantastic or terrible or sometimes sorry
sugoi is extreme of expression really fantastic or really terrible
sometimes sorry as if Japanese person bumps against or knocks in to another person they say sugoi ne meaning sorry translated actually means that was bad
so difficult to translate Japanese as context is so important