2

Has anyone tried linking a Sharepoint Excel spreadsheet with CartoDB?

My spreadsheet has a URL like it would from Google Drive or Dropbox and it is shared with editing and viewing privileges for everyone (public), however it keeps erroring when I try to import.

error:

Error 1001

Download error

What about...

The remote URL returned an error. Please verify your file is available at that URL.

Any ideas? I would like to use Excel as the program for my team to edit my data and I want it synced to CartoDB.

1
1

That import error is probably due to a non-valid URL for CartoDB, as it needs the URL to give directly a file in a supported format.

What usually happens with Google Drive, Dropbox, Sharepoint and similar services in general is that the URL to share them is not a direct download URL to the exported table but it's an URL that sends you to an HTML site. In these cases, CartoDB downloads this HTML code, which is not a supported format, and the import crashes.

I'm not very familiar with Sharepoint but if the system allows you to get a direct download URL you might want to try that. Platforms like Dropbox usually block those direct links if they see lots of activity for the resource and they add an intermediate step of sending you to an HTML page with a download button instead of giving you the file directly. For this reason, using the Google Drive and the Dropbox connector is the approach to follow to get your files from those services, as URLs might stop working, but unfortunately there's not any Sharepoint importing integration at this moment.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.