Once you have the template set up, it's easy to refresh the imported data in Rows.

This process has more steps than importing a CSV, but it's useful if you plan to keep using the Google Sheet as the source of truth. The easiest way to get data from Google Sheets is to use a template called the Google Sheets data importer. Importing data directly from Google Sheets

Leave the dropdown option 'Insert new table(s)' so that the import happens directly in the current spreadsheet.

Select the 'Import' option in this menu.

Click the dropdown arrow on the right of your spreadsheet's name.

Wait for the import confirmation, then click Open to review your imported file.Īlternatively, you can import a CSV or XLSX file directly into an existing spreadsheet.

If the imported data doesn't look correct, import it again and select the correct delimiter.

(optional) Select a delimiter to indicate how your data is split.īy default, Rows tries to automatically identify the right delimiter, so you can leave it set to automatic in most cases.

In the dialog that appears, upload your CSV/XLSX file and select a destination folder.

Open a workspace and click Import in the top-right of the screen.

To import a CSV or XLSX file, follow these steps: You can easily import data from other tools to Rows by clicking Import in your workspace dashboard.

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

copy and paste your data directly into a Rows spreadsheet.export a CSV file and import it into Rows.If you use another spreadsheet application, you can: It’s possible to bring in data that you’ve created elsewhere, but the process depends on what spreadsheet application you’re using.

Upload csv to google sheets