Skip to main content
Question

How do I copy the data in the Table view and/or export to a spreadsheet


wishbone-1

How do I copy the data in the Table view and/or export to a spreadsheet

4 replies

itay
Supporter
Forum|alt.badge.img+17
  • Supporter
  • May 13, 2020

Hi,

If you mean the table from the visual preview the I do not think there is a button to save the displayed data, but you can open the preview by clicking on the Data Inspector button and save it.

The Data Inspector uses the quick translator (I suspect) to translate the data to any supported FME format.

Hope this helps.


wishbone-1
  • Author
  • May 13, 2020
itay wrote:

Hi,

If you mean the table from the visual preview the I do not think there is a button to save the displayed data, but you can open the preview by clicking on the Data Inspector button and save it.

The Data Inspector uses the quick translator (I suspect) to translate the data to any supported FME format.

Hope this helps.

GeoJSON to Excel does not pass coordinates ?? Am I missing something?


chrisatsafe
Contributor
Forum|alt.badge.img+2
  • Contributor
  • May 13, 2020

Hi @wishbone-1,

Building on @itay's answer, yes you can save data directly from the feature table (see the Data Retrieval article for more). Please note that only attributes that are exposed in the table view will be included when using the Save Data As (or save selected data as) option.

If you want to include the coordinates, you will want to either extract the geometry using a GeometryExtractor or use the CoordinateExtractor depending on the geometry/expected output.


wishbone-1
  • Author
  • May 13, 2020
itay wrote:

Hi,

If you mean the table from the visual preview the I do not think there is a button to save the displayed data, but you can open the preview by clicking on the Data Inspector button and save it.

The Data Inspector uses the quick translator (I suspect) to translate the data to any supported FME format.

Hope this helps.

Thank you Chris


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings