This article is also available in:
When completing the Places information, you should 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 the EXCEL

Save as > Type: CSV (Comma Separated) > Save.
A new interactive window will automatically open, select the option: YES.
If after asking you if you want to save, click NO and close the file.

Then go to Tools and choose Web Options and go to the Coding tab and under '' Save this document '' as select the Unicode option (UTF-8) and click OK.

Finally click on Save and perform the import.

In the OPEN OFFICE

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

Configuring Coding in Excel for Mac

Microsoft Excel for MacOS (Machintosh - Apple) does not support the import or export of UTF-8 encoding in files.

To save the UTF-8 encoded file, use another spreadsheet program, such as Apple's 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 find out how to complete an import , click HERE

Attention:

When filling in the fields, for example the field '' Street '' which NO must contain the number, just the street, avenue, road and etc.

Did this content solve your question or help you?

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