CSV files are a flexible and widely used format for transferring data between different applications that might not otherwise be compatible. By transforming a .CSV export into columns, you can enhance readability and make it easier to manage your data in your preferred spreadsheet software.
Transforming a .CSV Export with Microsoft Excel
Open the .CSV File: Right-click the downlaoded .CSV file and choose to open it with Microsoft Excel.
Prepare to Split Text:
Select the cell or column that contains the text you want to split, typically Column A.
Navigate to Data > Text to Columns.
Configure the Wizard:
In the Convert Text to Columns Wizard, select Delimited > Next.
Choose the delimiters, in TWICE, typically Semicolons (;) are used as separators in .CSV files. The Data preview window will show how your data will appear > Next
Choose where you want the new columns to appear by selecting the Destination in your worksheet.
Click Finish to see your data organized into separate columns.
Transforming a .CSV Export with Google Sheets
Start a New Google Sheet:
Open Google Sheets and start a new document.
Go to File > Import and choose your downloaded .CSV file.
Import Settings:
In the Import file window, select your import location and separator type. In TWICE, typically Semicolons (;) are used as separators in .CSV files. Decide whether you want text converted to numbers, dates, and formulas.
Click Import data.
Adjust Columns if Needed:
If some data does not display correctly, highlight the affected cells.
Go to Data > Split text to columns to manually adjust them.