Namensschilder Posted December 2, 2020 Share Posted December 2, 2020 As said in the title, Publisher only imports the first two letters of each column from a CSV-File. Tried with , and ; as separator, made no difference. I can send the CSV-File by PM or an link to it, I can't upload it as it contains some sensitive data not meant for public. Greetings, Mattias Link to comment Share on other sites More sharing options...
Namensschilder Posted December 2, 2020 Author Share Posted December 2, 2020 Well, it seems it works now. I copied the content of the CSV file to another Texteditor and resaved it there, now its working, though the files both look the same when opening in Excel. Don't know why, seems like the other one made some stupid things with the codepage of the file... If you still want to check out the CSV file, just drop me a message. Greetings, Mattias Link to comment Share on other sites More sharing options...
Staff Jon P Posted December 3, 2020 Staff Share Posted December 3, 2020 @Namensschilder If you can upload the original csv here I'll take a look. Thanks Serif Europe Ltd. - www.serif.com Link to comment Share on other sites More sharing options...
polochon Posted December 7, 2020 Share Posted December 7, 2020 An Excel or OpenOffice .xlsx sheet works fine. The .csv exports are often capricious! Pay attention to the codification. I used a .csv sheet that worked with InDesign and not here. Ironed in .xlsx with OpenOffice and AffinityPublisher takes it perfectly. Link to comment Share on other sites More sharing options...
Recommended Posts