Our importer supports for UTF-8 without bom only. While format your csv please use the ‘ ” ‘ as the text delimeter. We have tested with ” ‘ ” in post content. You can check here.
Thread Starter
jaemaz
(@jaemaz)
Thanks for your response. Your method does work for post, but I am actually using it for custom posts, so mapping the content doesn’t seem to work correctly. I found a post on how to fix the source file, so I’ll be going with that I suppose. Here it the information, in case anyone is having this issue:
[ MS Excel ]
1. Open the *.xlsx file from MS Excel
2. Click menu > Save As
3. Put any name for the file and choose “Unicode Text (*.txt)” for “Save as type :” and Click Save
[ MS Notepad ]
4. Open the unicode text file using Microsoft Notepad. Some characters can appear as a box, however, this is because Notepad cannot display some unicode characters, so you can ignore this at this point.
5. It must be the tab delimited file. Replace tabs with comma(“,”) using find & replace.
– select tab character by dragging the character between two column headers and press ctrl+c
– Replace all tab characters with comma using Replace function (ctrl+H)
6. In notepad, Click Save As
7. Put a filename and change Encoding: to “UTF-8”
8. Change the file extension from “*.txt” to “*.csv” by adding .csv at the end of the file name.
9. Click Save.
[ MS Excel ]
10. Open this CSV file from Excel and verify if the data is okay.
*** Even if you find any problem in this step, you should NOT save the file from Excel. It will cause the encoding problem!! Just check the data only in Excel. If you see a data problem at this stage, fix the data from the original spreadsheet and repeat the steps again. Or, you can change it from Notepad but should ensure that the file is saved as UTF-8 format.
Thanks for the detailed notes. This should help others. There is a similar thread already but this one is more detailed.