How to  /  Run workflows  /  Import a csv into microsoft excel or google sheets or apple numbers

Import a csv file into Microsoft Excel, Google Sheets, Apple Numbers or OpenOffice

After exporting your workflow data you can import the downloaded file into…

Import csv into Microsoft Excel

  1. Open Microsoft Excel.
  2. Start/open a blank spreadsheet/workbook.
  3. Select the Data tab on the ribbon.
  4. Select the From Text option. (If options are grayed out you might need to open a new spreadsheet/workbook).
  5. Find and select the .csv file you’ve downloaded from Kotive. Click on the file and then click Import.
  6. The Text import wizard will open. Make sure the Delimited option is selected. Click the Next button.
  7. Select Comma under Delimiters. The Text qualifier should show “ (double quotes). Click the Finish button.
  8. You may be asked Where do you want to put the data? Click on the top-left cell. Click the OK button.
  9. Excel displays the data in your workbook.

Import csv into Google Sheets

  1. Open an existing sheet in Google Sheets or create a new sheet.
  2. Select File from the main menu, then Import.
  3. Select the Upload tab.
  4. Drag the file you’ve downloaded from Kotive into the upload area and drop it.
  5. Select one of the options under Import action.
  6. Click on the Import button.
  7. Google Sheets displays the data in your sheet.

Import csv into Apple Numbers

  1. Open the .csv file in a text editor like TextEdit on Mac.
  2. Do a find&replace. Find "," and replace with ";".
  3. Save the .csv file.
  4. Drag-and-drop the file onto the Numbers app icon.
  5. Apple Numbers displays the data in a new sheet.

Import csv into OpenOffice

  1. Open OpenOffice.
  2. Select File from the main menu, then Open.
  3. Select Files of Type.
  4. A list of file types that can be imported appears. Select Text CSV.
  5. Find and select the .csv file you’ve downloaded from Kotive. Click on the file and then click the Open button.
  6. Enter 1 in the From Row box since your data starts in the 1st row.
  7. Select Comma under the Separated By section. _If your .csv is data is separated by another character instead of comma you should specify it here (e.g. semicolon or tab).
  8. Click on the OK button to import the .csv file.