Import Data

Import Data helps you bring external data into WPS Sheets from files, websites, and databases. It provides the tools you need to consolidate data from different sources, making your work more efficient and helping you accomplish tasks with ease. With Import Data, you can import XLSX, ET, CSV, TXT, MDB, DBF, and similar files, set encoding and delimiters for text files, choose table names and fields for spreadsheet files, import table content from a website URL, connect to common databases such as Access, refresh imported data when the source changes, and break external data links when needed. Whether you're integrating file-based data, capturing website tables, or pulling records from a database, Import Data helps you stay productive and complete tasks efficiently. Choose the documentation below that best matches your needs to learn more.

1:53