Skip to main content
Question

CSV upload limit?

  • September 2, 2022
  • 0 replies
  • 222 views
AdamKeever1
Forum|alt.badge.img+2
Is there a limit to the number of records or file size for CSV upload? A file I have been uploading increasing in size daily uploaded fine until today and now I get this message (pretty sure it's not the network on my end):


------------------------------
Adam Keever
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+22
    • MarkShnierYou
    • Quickbase Alumni
    • September 2, 2022
    There is a limit but I can't lay my hands on a published statement of what that limit is. Clearly you have hit it. I believe it is based on the file size and not the number of records, so if you have a lot of columns then it will allow you fewer Rows.

    A workaround is to break the import into two separate imports.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    AdamKeever1
    Forum|alt.badge.img+2
    • AdamKeever1
    • Author
    • Quickbase Alumni
    • September 8, 2022
    So there is a limit, but I hit thanks to being upgraded to Office 365 on a new laptop...

    The version of Excel that I ran my macros in was set to auto save and it saved my macro file after 5 tabs of data were added so when I ran it the next time it compiled nearly double the data.

    I removed the extra 5 tabs of data and was able to import/merge my data as usual. Problem solved.

    For reference, the file contains 3,600,917 cells of data and the file is 76,728 KB and it imports just fine. The file with duplicate data contains 6,379,655 cells of data and the file is 124,958 KB and does not import.

    The limit is somewhere in between.

    ------------------------------
    Adam Keever
    ------------------------------
    Terms & ConditionsAccessibility statement