Support » Plugin: TablePress » How to import google spreadsheet

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for the question.

    The easiest way would be to simply download the table as a “comma separated file” (CSV). You can then import that into TablePress.

    Note that this will only import the data, but not the styling/coloring. You would have to re-do that with CSS code.

    Regards,
    Tobias

    lucamoiana

    (@lucamoiana)

    wow, thank you for the quick reply.

    Styling it with css is exactly what I want, so it fits better with the theme.

    So there is no way to dinamically impprt the csv? the only way is to export and import every time I update the data?

    Thanks for your time

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    no problem for the reply 🙂

    CSS styling is not directly connected to TablePress, but for a few examples, please see the TablePress FAQ at http://tablepress.org/faq/

    And yes, you can not “connect” TablePress to the Google Spreadsheet, if that’s what you mean. You’ll have to export/import each time (and choose to replace the existing table).

    Regards,
    Tobias

    cj1490

    (@cj1490)

    Hello! sorry If I am asking in this thread but I think it’s kind of relevant. I wanted to import a csv file from a dropbox URL.

    I am inputting the direct download link of the file from my dropbox and I inputted it in the file from URL part inside the import tab. But I always get an error that says the file is invalid or cannot be accessed or something.

    I got the link by going to the public URL of the file in my dropbox and I right clicked the download button and copied the link. Is this the URL that I need?

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for the question, and sorry for the trouble.

    Most likely, this means that the server then has no access rights to that URL, either because outgoing requests fail or because Dropbox blocks it somehow.

    I recommend to simply download the file and then import the table with the “File Upload” method.

    Regards,
    Tobias

    lucamoiana

    (@lucamoiana)

    At this point I should consider the DB workaround and create a DB inside WP where I can insert data for different athletes. Do you know how to or can you point me to a tutorial or plugin?

    Thanks

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    no, sorry, I don’t really have a starting point for that 🙁 You might want to start with the WordPress Codex, to learn about plugin development.

    Best wishes,
    Tobias

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘How to import google spreadsheet’ is closed to new replies.