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…
- Microsoft Excel (on Windows and Mac)
- Google Sheets
- Apple Numbers (on Mac)
- OpenOffice (on Linux)
Import csv into Microsoft Excel
- Open Microsoft Excel.
- Start/open a blank spreadsheet/workbook.
- Select the Data tab on the ribbon.
- Select the From Text option. (If options are grayed out you might need to open a new spreadsheet/workbook).
- Find and select the .csv file you’ve downloaded from Kotive. Click on the file and then click Import.
- The Text import wizard will open. Make sure the Delimited option is selected. Click the Next button.
- Select Comma under Delimiters. The Text qualifier should show “ (double quotes). Click the Finish button.
- You may be asked Where do you want to put the data? Click on the top-left cell. Click the OK button.
- Excel displays the data in your workbook.
Import csv into Google Sheets
- Open an existing sheet in Google Sheets or create a new sheet.
- Select File from the main menu, then Import.
- Select the Upload tab.
- Drag the file you’ve downloaded from Kotive into the upload area and drop it.
- Select one of the options under Import action.
- Click on the Import button.
- Google Sheets displays the data in your sheet.
Import csv into Apple Numbers
- Open the .csv file in a text editor like TextEdit on Mac.
- Do a find&replace. Find
","and replace with
- Save the .csv file.
- Drag-and-drop the file onto the Numbers app icon.
- Apple Numbers displays the data in a new sheet.
Import csv into OpenOffice
- Open OpenOffice.
- Select File from the main menu, then Open.
- Select Files of Type.
- A list of file types that can be imported appears. Select Text CSV.
- Find and select the .csv file you’ve downloaded from Kotive. Click on the file and then click the Open button.
- Enter 1 in the From Row box since your data starts in the 1st row.
- 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).
- Click on the OK button to import the .csv file.