This article is also available in:
When filling in the location information, you must save the spreadsheet as a CSV file. Generally, all spreadsheet software on the market has this option, in the menu "Files" , option "Save as ...".



In EXCEL

Save As > Type: CSV (comma separated) > Save.
A new interactive window will open automatically, select the option: YES.
If after that it asks if you want to save, click NO and close the file.
Then go to Tools and choose Web Options and go to the Encoding tab and under ''Save this document'' select the option Unicode (UTF-8) and click OK.



Finally, click Save and run the import.

In OPEN OFFICE

Save As > Type: Text CSV (.csv) > Save.
A new interactive window will automatically open, select the option: Keep current format.
In the new screen that will open, under '' Character set '' select the option Unicode (UTF-8).
Click OK and import the saved file.

Setting encoding in Excel for Mac

Microsoft Excel for macOS (Machintosh - Apple) does not support importing or exporting UTF-8 encoding in files.

To save the UTF-8 encoded file, use another spreadsheet program such as Apple Numbers or Google Sheets.

Information for saving UTF-8 encoded files in each of these programs will be listed separately in the next steps.

To know completely how to perform an import, click on HERE

It is necessary that the encoding of the article is in UTF-8 for the import to be done correctly.

Heads up:

When filling in the fields, such as the ''Location'' field that NOT must contain the number, only the street, avenue, road and so on.

Did this content resolve your question or help you?

Vote below and, if you didn't find what you were looking for, send a message in the chat beside.
Was this article helpful?
Cancel
Thank you!