Importing data
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
- Open Library and start a collection import in a location where you have permission.
- Choose or drop a CSV or XLSX file and give the collection a name.
- For a CSV, check the preview and delimiter.
- 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