Licensing options for this format begin with FME Professional Edition.
Note: Due to Google API deprecation, this format may stop working. Please migrate workspaces to the Google Sheets format.
Google Docs is a web-based suite of office tools including a spreadsheet application. The Google Spreadsheet Reader allows FME to read any arbitrary single spreadsheet accessible in a particular user's document list by name.
The Google Spreadsheet Writer allows single feature types to be converted to CSV files and automatically uploaded to the account of an authenticated Google docs user.
Individual worksheets or pages in the spreadsheet will be treated as separate feature types in FME. Each column in a spreadsheet corresponds to an attribute name on a feature type and each row a feature.
Reader Overview
The Google Spreadsheet Reader produces an FME feature for each row in a worksheet in the provided spreadsheet.
Note that the spreadsheet cannot be changed once generated since this determines the feature types.
Writer Overview
The Google spreadsheet writer produces a Google spreadsheet document with a row for each feature type. The rows are written in a worksheet in the output spreadsheet.
Currently a single worksheet is writable per spreadsheet. If multiple worksheets are supplied, the last one will overwrite the previous worksheets.
The Google Spreadsheet writer first opens the spreadsheet, then writes all the rows from the worksheets defined in the mapping file.
If a file already exists, it can be overwritten if the OVERWRITE_EXISTING_SHEET directive is set to YES.