Import a CSV or XLSX file to create a new collection, not to append rows to an existing table.

File Import behavior
CSV Preview the data and check the delimiter before importing.
XLSX Create a table for each sheet in the workbook; no preview is shown.

Import a file

  1. Open Library and start a collection import in a location where you have permission.
  2. Choose or drop a CSV or XLSX file and give the collection a name.
  3. For a CSV, check the preview and delimiter.
  4. Import the file, then open the resulting table and check the data.

Before importing, remove duplicate or unwanted rows and use clear column headings. After importing, check a few records, especially dates and numbers, against the source file.

Bring in data from a service

For a connected service, ask Play in chat to read the source and write to the destination table. Specify any transformations rather than assuming the source and destination have the same structure:

Import all contacts from Google Sheets into my Contacts table. Show me how the source columns match the destination before writing the records.

For a recurring transfer, create a task with the source connection, destination table, and update rules. State how to identify existing records so the task does not create duplicates on each run.

Still stuck? Email support@play.fast