Data Import
Data Import helps you bring external data into WPS Sheets in Collaboration Mode. It provides the tools you need to import file-based and database data into the current worksheet, making your work more efficient and helping you accomplish tasks with ease. With Data Import, you can import local files in XLSX, XLS, ET, and CSV formats, import online cloud documents including Smart Sheets, and set scheduled imports from MySQL or SQL Server by configuring connection details, choosing tables, and defining refresh frequency for automatic synchronization. Whether you're consolidating data from local files, locating shared or stored cloud documents, or keeping worksheet data updated from databases, Data Import helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.