1
0
-1

When I try to open one of the larger table csv files like person.csv in google sheets, it tells me that it cannot open because the file requires a password. That was confusing because I didn't think dbpedia limited the access to its csv/json files. I'm not sure if this has anything to do with google sheets just not being able to handle the size of the file or something else I did, but if anyone has any information explaining why I get this response and how I can get access to files like person.csv that would be much appreciated.

    CommentAdd your comment...

    3 answers

    1.  
      2
      1
      0

      Exactly what steps are you taking to try to open these files in Google Sheets?  What is the URL of one of the problematic files?  

      I've just downloaded the 187 MB Person.csv.gz.  That extracts to 6.3 GB — 471 columns, and 1,517,820 rows — or 714,893,220 cells.

      Google Sheets only accepts up to 2,000,000 cells – well below this file's content.  Perhaps that's the issue you're really hitting...


      1. Danny

        Looks like you were right about the file just being too big for google sheets. I ended up splitting person.csv up using a csv splitter, and I was able to open up the smaller files on google sheets.

        Thanks for the help!

      CommentAdd your comment...
    2.  
      2
      1
      0

      Looks like you were right about the file just being too big for google sheets. I ended up splitting person.csv up using a csv splitter, and I was able to open up the smaller files on google sheets.

      Thanks for the help!

      1. Ted Thibodeau Jr

        Please make this non-answer into a comment on one of the answers, and accept it, so the question is marked as answered....

      CommentAdd your comment...
    3.  
      2
      1
      0

      As Ted mentioned, please try to test this outside Google Sheets and see if it is a Google Sheet issue or a csv issue, then please edit the question respectively

        CommentAdd your comment...