![]() 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |