copy paste list into excel separated by semi colons

Suppose column A contains 'Last Name, First Name'. Once you've opened up the Excel file (and the formatting looks good), you can re-save the file (if your default separator is a comma) so the 'sep=' line is no longer present, which will allow for imports.In Excel (2016, 2013, 2010) it's possible to parse data from one column into two or more columns. Note : This newly added line will not show up when opening the file in Excel.

Save your changes ( command + S or control + S), then re-open in any Spreadsheet app.

Press Enter/ Return to create a new line at the very top, and add sep= if the separator used in the CSV is a semicolon ( ), or sep=, if the separator is a comma (,).

When you have a CSV that is separated by semicolons ( ) and your system/Excel default is commas (,), you can add a single line to tell Excel what delimiter to use when opening the file.

Remember to Save your file so it keeps the new format.Īdding 'sep= ' or 'sep=,' to the CSV file.

The preview will show the columns being separated.

Select Comma (this is Affinity's default list separator).

Select Delimited, then make sure the File Origin is Unicode UTF-8.

Select the CSV file that has the data clustered into one column.

These steps will apply to both Mac and PC versions of Excel.

Open the Excel file that you're trying to change in terms of data formatting.Adding 'sep= ' or 'sep=,' to the CSV file.Here are two ways to open files without needing to change your Excel settings: This can either cause file upload issues or cluster all the field values into column A because exported files from Affinity use commas (,) as the default delimiter/separator.

Depending on your Excel's regional setting, your default delimiter/separator may either be using semicolons ( ) or commas (,) to separate items in a CSV file.

Copy paste list into excel separated by semi colons