Copy to Excel

Top  Previous  Next

 

§ YOU CAN COPY AND PASTE ALL YOUR DATA OR A SELECTION OF DATA FROM YOUR LAYER DATA GRID TO EXCEL.

 

 

 

 

1. To select all your data right click any row in your grid and click SELECT ALL to select all rows.

 

 

 

 

Copy to excel from grid

 

 

 

 

 

2. To select filtered data only first filter the column(s) you want to copy and then right click any row in your grid and click

 

SELECT ALL to select all rows in your filter.

 

 

 

 

3. To select a selection of rows left click and hold shift/control to select the rows in your grid.

 

 

 

 

4. Once you have selected your data right click again and click COPY SELECTED DATA.

 

 

 

 

5. A CHOOSE COLUMNS box will appear where you can choose the columns you want to copy to clipboard. (They are all ticked    

 on as default.)

 

 

 

 

6. Tick off the first column ACTUAL GEOMETRY as this will copy unnecessary columns.

 

 

 

 

7. Click OK and your grid data will copy to clipboard.

 

 

 

 

 

Copy to excel from grid - 1

 

 

 

 

 

8. Open excel and paste the data to a spreadsheet.

 

 

 

 

 

Copy to excel from grid - 2

 


Copyright (c) PrimeThought Software Solutions CC