Importing CSV, XLSX, XLS and GSheets files

It’s possible to bring in data that you’ve created elsewhere, but the process depends on what spreadsheet application you’re using.

• If you use another spreadsheet application, you can:

  • export a CSV, XLS, XLSX or TSV file and import it into Rows
  • copy and paste your data directly into a Rows spreadsheet.
    
    

• If you’re a Google Sheets user and want to keep your data synchronized, you’re in luck: we have an integration for that.

Importing data from a file

You can easily import data from other tools to Rows by clicking Import in your workspace dashboard.

To import a CSV or XLSX file, follow these steps:

1. Open a workspace and click Import in the top-right of the screen.
   
   
2. In the dialog that appears, upload your CSV/XLSX/XLS/TSV file and select a destination folder.
   
   
3. (optional) Select a delimiter to indicate how your data is split. By default, Rows tries to automatically identify the right delimiter, so you can leave it set to automatic in most cases.
   If the imported data doesn't look correct, import it again and select the correct delimiter.
   
   
4. Wait for the import confirmation, then click Open to review your imported file.

Alternatively, you can import a file directly into an existing spreadsheet. Following these steps:

1. Click the dropdown arrow on the right of your spreadsheet's name. This will open a menu.
   
   
2. Select the "Import" option in this menu.
   
   
3. In the dialog that appears, upload your file and select a destination folder.
   
   
4. Leave the dropdown option "Insert new table(s)" so that the import happens directly in the current spreadsheet.
   
   
5. (optional) Select a delimiter to indicate how your data is split. By default, Rows tries to automatically identify the right delimiter, so you can leave it set to automatic in most cases.
   If the imported data doesn't look correct, import it again and select the correct delimiter.

Importing data directly from Google Sheets

To import data from Google Sheets, follow these steps:

1. Click on the Data Actions option from the tool bar
2. Search for Google Sheets
3. Enter the URL of the Google Sheet or click on the Drive icon to select the file
4. If you've clicked on the Google Drive, you'll then need to authorise your Google Account and choose the Google Sheet from the Google Drive file picker pop-up
5. Click on Get Data

Note: Formulas in your source sheet won’t be retained, only the output values are imported. If the data in the Google Sheets has changed since you imported it, you can refresh the imported data by clicking Get Cells again.