...
- Open an Excel workbook
- Go to Data menu | Get & Transform ribbon section | New Query dropdown
- Choose From Other Sources | From Web
- Paste the URL into the From Web box. Click OK.
- Your data will preview in a popup window. You should be able to leave all defaults. Click Load.
Click Edit. - The Advanced editor will be displayed. Click the gear icon for Source under Applied Steps.
Set Line Breaks to Ignore quoted line breaks and click OK
Tip Why this step? Projector encloses any text field in double quotes. When that quoted field contains line breaks, we need Excel to treat it as a single entry and not try to create a new row of data.
- Click Close and Load. The data is inserted into your spreadsheet.
...