Skip to main content
Question

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

  • May 13, 2020
  • 4 replies
  • 314 views

wishbone-1

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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

4 replies

itay
Supporter
Forum|alt.badge.img+18
  • Supporter
  • 1442 replies
  • 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
  • 5 replies
  • 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.

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


chrisatsafe
Contributor
Forum|alt.badge.img+2
  • Contributor
  • 606 replies
  • 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
  • 5 replies
  • 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.

Thank you Chris