CSV files can be opened in the Excel application. Excel uses a semicolon (;) and not a comma (,) for separating columns and that is why we have to use a guide to open (import) a CSV file.
This guide can differ based on the various versions of Excel, but the principle and steps are the same.
- Open a blank workbook in Excel.
- Click ‘‘Data‘‘ in the upper menu.
- In the menu on the next line (usually on the left), you will find section ‘‘Upload and transform data‘‘ and then ‘‘From text/CSV‘‘. Different versions of Excel have slight differences but the names and places are very similar.
- Choose ‘‘From text/CSV‘‘ and search the downloaded file.
- Click the button for import.
- Depending on the version of Excel you are using, the following steps might differ a bit. But the principle is always the same.
- Select that your file contains dividers.
- If the language you are viewing isn’t right (Czech for example), use coding ‘‘UTF 8‘‘.
- Choose a comma as a divider and finish the import.
Older versions of Excel:
You should see all your data in Excel in the right form and columns. If it didn’t work out, please contact us on the phone or write an email to our support.
Do you have any question? We will gladly answer them. You can contact our customer support and write an email to: support@onquanda.com.