Export data to Excel from SNAP

Optical Toolbox
1

Dear all,

I would like to export data in Excel or a text file using SNAP. My product is a .tif format. I know that I could achieve it by clicking on File- Export - CSV but it doesn’t work; probably because there is metadata associated to my product. I tried to subsent the band 1, but when I use the Raster - Subset and then the Metadata tab, I can’t unclick the metadata of this product.

I don’t know how to export the data. If you have any ideas !

Thanks all,

Lucas

2

Hi dear
See this topic Export pixel values of a whole region

3

Hi Mohammad,

Thank you for your answer.

When I define the zone with a polygon and right click the picture I can’t extract all the pixels infos of this zone, I only can extract the pixel located under my cursor…

I also tried to use the Pixel Extractionl Tool, but in the parameters and especially coordonates I can’t define a polygon or at least ask for all the pixel infos of my product.

Thanks again !

4

Hi dear @lbertoncini
I will send you screenshots that how to extract pixel value with a polygon or shapefile.

1 Like
5
  1. at first, you should draw a polygon or import shapefile to your raster data
    (for example, I draw a polygon on LST band of SLSTR data)

Ashampoo_Snap_Saturday, February 08, 2020_08h52m58s_002_
Ashampoo_Snap_Saturday, February 08, 2020_08h52m58s_002_1366×709 119 KB

  1. go to this direction: Raster>Export>Mask Pixels

Ashampoo_Snap_Saturday, February 08, 2020_08h54m54s_004_
Ashampoo_Snap_Saturday, February 08, 2020_08h54m54s_004_1366×712 103 KB

  1. Select Mask: Select the geometry, if you draw a polygon or Select your imported shapefile

Ashampoo_Snap_Saturday, February 08, 2020_08h55m16s_005_
Ashampoo_Snap_Saturday, February 08, 2020_08h55m16s_005_1366×768 222 KB

  1. select the header and then click Write To File, then select the path to save file

Ashampoo_Snap_Saturday, February 08, 2020_08h56m41s_007_
Ashampoo_Snap_Saturday, February 08, 2020_08h56m41s_007_1366×703 141 KB

  1. open excel, Drag text file to excel, All pixel values you selected, will shown in excel

Ashampoo_Snap_Saturday, February 08, 2020_08h57m59s_008_
Ashampoo_Snap_Saturday, February 08, 2020_08h57m59s_008_1366×731 435 KB

Ashampoo_Snap_Saturday, February 08, 2020_08h58m46s_009_
Ashampoo_Snap_Saturday, February 08, 2020_08h58m46s_009_1366×711 70.4 KB

Cheers,
Mohammad

2 Likes
6

I manage to export the polygon as shapefile and to import it into other products. This allows me to activate the mask (polygon) in the mask manager but as I try to export the pixel values in the way you suggested, I get an error:

stepforum1
stepforum11874×651 149 KB

The product where I originally created the polygon is working well with exporting the pixel values as csv. What is the problem?

7

I don’t really know what happened but it seems to work now. Maybe I have to fully select the conc_chl band. Nevertheless, its working now :slight_smile:

1 Like