Import Excel File With More Than 255 Columns

[TroyPurdue]

I have a table with approx. 306 columns. When I export I only get the first 255 unless I choose to export as a CSV.

 

However, when I try to import the table back after modifications it only lets me import the first 255 columns.

 

Solutions?

[GoCubbies]

The maximum number of columns on an import is 255.  The same goes for an export.  Inside Caspio, your table can have more fields than that, but anything over 255 will not be exported.

[TroyPurdue]

Thanks jasonj but Caspio does let me export all columns via CSV. Surely there is a solution to upload more than 255 columns or to add columns and data to existing records.

[Jan]

Hello tpurde,

Can you open the .CSV file via Exel and edit it?

I think then you can save the file as a .CSV and import it back.

[TroyPurdue]

I can import the data into Excel to make the changes but when I try to upload the CSV back into Caspio it still only supports the first 255 columns.

 

Is there a way to add data to the table for existing records?