The Google Fusion Tables API will not be available after Dec. 3, 2019. Learn more

Table: importRows

Requires authorization

Import more rows into a table. Try it now.

This method supports an /upload URI and accepts uploaded media with the following characteristics:

  • Maximum file size: 100MB
  • Accepted Media MIME types: application/octet-stream


HTTP request

This method provides media upload functionality through two separate URIs. For more details, see the document on media upload.

  • Upload URI, for media upload requests:
  • Metadata URI, for metadata-only requests:


Parameter name Value Description
Path parameters
tableId string The table into which new rows are being imported.
Required query parameters
uploadType string The type of upload request to the /upload URI. Acceptable values are:
  • media - Simple upload. Upload the media only, without any metadata.
  • multipart - Multipart upload. Upload both the media and its metadata, in a single request.
  • resumable - Resumable upload. Upload the file in a resumable fashion, using a series of at least two requests where the first request includes the metadata.
Optional query parameters
delimiter string The delimiter used to separate cell values. This can only consist of a single character. Default is ','.
encoding string The encoding of the content. Default is UTF-8. Use 'auto-detect' if you are unsure of the encoding.
endLine integer The index of the last line from which to start importing, exclusive. Thus, the number of imported lines is endLine - startLine. If this parameter is not provided, the file will be imported until the last line of the file. If endLine is negative, then the imported content will exclude the last endLine lines. That is, if endline is negative, no line will be imported whose index is greater than N + endLine where N is the number of lines in the file, and the number of imported lines will be N + endLine - startLine.
isStrict boolean Whether the CSV must have the same number of values for each row. If false, rows with fewer values will be padded with empty values. Default is true.
startLine integer The index of the first line from which to start importing, inclusive. Default is 0.


This request requires authorization with the following scope (read more about authentication and authorization).


Request body

In the request body, supply a Table resource as the metadata. For more information, see the document on media upload.


If successful, this method returns a response body with the following structure:

  "kind": "fusiontables#import",
  "numRowsReceived": long
Property name Value Description Notes
kind string Type name: a template for an import request.
numRowsReceived long The number of rows received from the import request.

Try it!

Note: APIs Explorer currently supports metadata requests only.

Use the APIs Explorer below to call this method on live data and see the response. Alternatively, try the standalone Explorer.