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

Table: importRows

Requires authorization

Imports 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: 250MB
  • 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 line up to which data will be imported. Default is to import the entire file. If endLine is negative, it is an offset from the end of the file; the imported content will exclude the last endLine lines.
isStrict boolean Whether the imported 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 The kind of item this is. For an import, this is always fusiontables#import.
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.