How to import big excel file

  • Resolved techbulu

    (@techbulu)


    9 years, 2 months ago

    Hi Friends,

    I have a big excel file which is having around 40000 rows,i tried to use Tablepress to make a searchable and sortable table but no luck as the excel file is large the tablepress gets hang and is importing rows upto around 5500 only

    I want to create a serachable\sortable table or a simple search button and in the backend we have excel sheet so that we can search.

    Can you please help and find us the solution that would be great help.

    If you people have any other solution let me know, as i am not from development background easiest method would be appreciated without any coding(thats why i use TablePress for my other excel data to create tables)

    • This topic was modified 9 years, 2 months ago by techbulu.
Viewing 1 replies (of 1 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    9 years, 2 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    Unfortunately, TablePress is not really good for large tables. You could try saving the table to a CSV file in Excel. Those usually import faster and better.
    However, the loading of the table when shown on a page of your site will probably not be fast.

    Regards,
    Tobias

Viewing 1 replies (of 1 total)

The topic ‘How to import big excel file’ is closed to new replies.