Import tables with HTML breaks

Hi Tobias

Thanks for the reply.

In the “Auto Import Tables” settings, for each table in the “source” field we have the link to the google spreadsheets URL that delivers the CSV.

This is setup and working for some of the tables perfectly fine, those of which all seem to not include any HTML in the fields. Whilst the tables on google sheets that include some HTML such as “Test” seems to break like the screenshot I included.

The google spreadsheets URL that is being used in the “source” field for example is something like this:
https://docs.google.com/spreadsheets/d/e/2PACX-1vQ*spreadsheetid*/pub?gid=12345&single=true&output=csv

Any suggestions appreciated.

Thanks.

• This reply was modified 7 years, 10 months ago by Elliot Sowersby.
• This reply was modified 7 years, 10 months ago by Elliot Sowersby.

Hi

Here is an example table with the type of HTML:

https://docs.google.com/spreadsheets/d/1bO55PR5UVatyBuvGuYp94jKbs-EK4-ynKvXJwmiy_1c/edit#gid=0

They return something like this:

https://i.gyazo.com/f529648ddeb85b7eeff0cfd7558dde11.png

Thanks, the URL provided is just an example. I can’t share the actual sheet at is has some provide stuff. But the google sheet has multiple tabs/sheets, and using the API CSV URL in the auto import “Source”, which is something like:

https://docs.google.com/spreadsheets/d/e/2PACX-*docid*/pub?gid=*gid*&single=true&output=csv

This allows a CSV file to be download without login.

This format is used for all the sheets, but it seems it’s just the sheets that have HTML in them that don’t import properly and show something like this:

https://i.gyazo.com/d0e999ad5b968b05b512a93ab9693346.png

Thanks!

Sure, thanks. I’ve sent an email.