Why can’t I copy/paste from word and keep the formatting like bold etc.??
You can. Just go to preferences -> clipboard handling and select keep formatting. If you want another font you can swap bold and regular by using the menu type -> find font feature!
How do I import from Excel into datamerge – it keeps coming up with errors?
Well – use Google Sheets instead and export as CSV. or
- Check that there are no empty columns first/middle
- Keep single words in first row
- Check that there are no hidden columns.
- export as TAB seperated values
- Close the document before importing into InDesign
Hope that worked for you.