When working with the SplitMetrics Acquire platform, you might need to download certain data reports. You can do this conveniently with our Export option. All the reports are downloaded in CSV ( comma-separated values) format.
In this guide, you'll learn how to open the CSV files in Microsoft Excel to view the data correctly.
You can import data from a CSV file to a new Microsoft Excel book.
Note. This method not only opens a CSV file in Excel but converts the .csv format into .xlsx.
Create or open an Excel workbook
1. Create a new Excel workbook or open an existing one and click the cell where you need to import data from the CSV file.
2. Click Data > Get External Data > From Text.
3. Search for the necessary CSV file and double-click it.
The Text Import Wizard will be displayed. You have to follow its steps.
Text Import Wizard - Step 1
Select the data format and the row number from which you want to start importing.
Note. Select Unicode (UTF-8) in the File origin field for the correct import of all characters, including the non-Latin.
The preview area at the bottom of the Wizard dialogue box shows the first few records of the imported CSV file.
Text Import Wizard - Step 2
At this step, select row delimiters and text qualifiers.
Delimiter (Separator) is the character that separates the values in the CSV file.
Select Tab and Comma so that the information is placed in different rows and cells.
A text qualifier is a character that contains values. All text enclosed between such characters, for example, "text 1, text 2", will be imported as a single value, even if this text contains a symbol specified by you as a separator.
Select the quotation marks (") as a row delimiter. As a result, all the numbers with a decimal separator (which can also be a comma) will be imported into one cell.
❗❗ If you don't specify quotation marks as a row delimiter, all numbers (for example, from "Time" columns) will be imported into different cells.
Text Import Wizard - Step 3
Step 3. Check the Data preview area. If you are satisfied with what your data looks like, click Finish.
Choose whether to insert the imported data in the existing or a new sheet and click OK to complete the CSV file import into Excel.
➡️ You are trying to open the CSV file with Excel, and the data isn't correctly allocated by columns.
Your default settings might not correspond to the data in the file. There are two options to open a CSV file correctly in this case:
Change the extension from .csv to .txt. Opening a TXT file in Excel will run Text Import Wizard, and you'll be able to select the appropriate delimiters as described in Import CSV into Excel.
Select the necessary delimiters in the Convert Text to Columns Wizard:
Click Data > Text to Columns.
Step 1. Select the Delimited file type > Next.
Step 2. Select Tab and Comma as delimiters and quotation marks (") as a Text qualifier.
Click Finish.
Note. You can configure settings for one column at a time.
➡️ Fields including Cyrillic characters are imported partially: only Latin characters and numbers.
Check what Unicode has been selected in the File origin when importing the file.
There should be 65001 Unicode (UTF-8) for the correct display of all types of characters.