Skip to main content
Solved

Question mark appeared next to phone number in field

J

Hi! I imported an Excel spreadsheet into a new Base. When I did, some of the addresses and phone numbers had a question mark appear next to them. What is this and how can I get rid of it? 434-332-8227�

Best answer by Jason11

M_k wrote:

Hi @Jennifer_Williams1

I think this has to do with encoding, if I understand correctly, it has to do with origin of the data.

The other option would be to try Google Sheets and see if that might help.

Or perhaps you can take a look at this post for a possible solution.

Hope it helps.

Mary Kay

If this helps to resolve the issue, can you check mark the solution. Thank you! :grinning:


Hi @Jennifer_Williams1,

Something else you can check is if the file is encoded in Unicode (UTF 8) format. You’ll want to be sure you have that selected when exporting from Excel.

For certain programs (such as Mac Excel 2011) that don’t support UTF 8, another option is to simply copy/paste the data from Excel into Airtable (click here for a guide on this).

Another possible workaround is to convert the CSV file to a different encoding, by opening the CSV in Sublime Text (http://www.sublimetext.com). Then click File -> Save With Encoding -> UTF-8 LE with BOM.

View original
Did this topic help you find an answer to your question?

2 replies

M
  • M_k
  • Inspiring
  • 614 replies
  • June 3, 2020

Hi @Jennifer_Williams1

I think this has to do with encoding, if I understand correctly, it has to do with origin of the data.

The other option would be to try Google Sheets and see if that might help.

Or perhaps you can take a look at this post for a possible solution.

Hope it helps.

Mary Kay

If this helps to resolve the issue, can you check mark the solution. Thank you! :grinning:

J
1 person likes this
  • J
    Justin_Barrett
J
  • Jason11
  • Inspiring
  • 375 replies
  • Answer
  • June 26, 2020
M_k wrote:

Hi @Jennifer_Williams1

I think this has to do with encoding, if I understand correctly, it has to do with origin of the data.

The other option would be to try Google Sheets and see if that might help.

Or perhaps you can take a look at this post for a possible solution.

Hope it helps.

Mary Kay

If this helps to resolve the issue, can you check mark the solution. Thank you! :grinning:


Hi @Jennifer_Williams1,

Something else you can check is if the file is encoded in Unicode (UTF 8) format. You’ll want to be sure you have that selected when exporting from Excel.

For certain programs (such as Mac Excel 2011) that don’t support UTF 8, another option is to simply copy/paste the data from Excel into Airtable (click here for a guide on this).

Another possible workaround is to convert the CSV file to a different encoding, by opening the CSV in Sublime Text (http://www.sublimetext.com). Then click File -> Save With Encoding -> UTF-8 LE with BOM.

Reply


Most helpful members this week

Terms & Conditions