/widgets.js";var sz=d.getElementsByTagName(s)[0];sz.parentNode.insertBefore(z,sz)}(document,"script","zb-embed-code"));

What are the best plugins to import Excel or CSV files into WordPress?

This really depends on what your desired output is. As Eric Rosenberg said, WordPress is not a spreadsheet program — it’s not designed to handle CSV or spreadsheet data. There may be plugins that allow you to import data this way, but they will be for a very specific thing, like importing a large number of events into an event management plugin like Event Espresso. If you are importing posts into WordPress, then it sounds like Ryan Bayne‘s ...

Continue Reading →
google-contacts

Google Contacts: How to force MS Excel to import a CSV file without messing up with leading numbers like ‘0’ or ‘+’ sign automatically?

Google Contacts: How to force MS Excel to import a CSV file without messing up with leading numbers like ‘0’ or ‘+’ sign automatically?

Here’s how I do it. (Google Contacts)  I standardize everything with +International Code. So taking an INDIAN example:
A phone number is 91 1234567890 (91 is the area code and the phone number follows). So in this example, I’ll enter the number as follows:

+91 1234567890

Then using Excel or Google Sheets, set the Phone Number Column as Text.
Continue Reading →